Changes between Version 5 and Version 6 of Ticket #84, comment 3


Ignore:
Timestamp:
May 28, 2018 8:29:06 AM (7 years ago)
Author:
cedric
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #84, comment 3

    v5 v6  
    1616}}} 
    1717 
    18 = Hard upgrade of the trac = 
     18= Hard upgrade = 
    1919 
    2020following instructions [http://www.postgis.org/docs/postgis_installation.html#hard_upgrade on postgis], I need a hard updgrade to reinstall the database to the new server 
    … …  
    9393F: 
    9494cd F:/base 
    95 pg_dump -h 1.100.1.6 -p 5432 -U postgres -Fc -b -v -f "eda2.backup" eda2 
     95set PGPORT=5432 
     96set PGHOST=w3 
     97set PGUSER=postgres 
     98set PGPASSWORD=? 
     99set THEDBSOURCE=eda2 
     100set PGINSTALL=C:\Program Files\PostgreSQL\9.6 
     101set PATH=%PATH%;"%PGINSTALL%\bin" 
     102 
     103set SCHEMA=anglian 
     104set BACKUPFILE=anglian.backup 
     105pg_dump --schema %SCHEMA% --file %BACKUPFILE% --verbose -Fc -b %THEDBSOURCE% 
     106 
     107set SCHEMA=bd_map 
     108set BACKUPFILE=bd_map.backup 
     109pg_dump --schema %SCHEMA% --file %BACKUPFILE% --verbose -Fc -b %THEDBSOURCE% 
     110 
     111set SCHEMA=belge 
     112set BACKUPFILE=belge.backup 
     113pg_dump --schema %SCHEMA% --file %BACKUPFILE% --verbose -Fc -b %THEDBSOURCE% 
     114 
     115REM OK 
     116set SCHEMA=ccm21 
     117set BACKUPFILE=ccm21.backup 
     118pg_dump --schema %SCHEMA% --file %BACKUPFILE% --verbose -Fc -b %THEDBSOURCE% 
     119 
     120set SCHEMA=clc 
     121set BACKUPFILE=clc.backup 
     122pg_dump --schema %SCHEMA% --file %BACKUPFILE% --verbose -Fc -b %THEDBSOURCE% 
     123REM TODO 
     124set SCHEMA=dbeel 
     125set BACKUPFILE=dbeel.backup 
     126pg_dump --schema %SCHEMA% --file %BACKUPFILE% --verbose -Fc -b %THEDBSOURCE% 
     127REM OK 
     128set SCHEMA=dbeel_nomenclature 
     129set BACKUPFILE=dbeel_nomenclature.backup 
     130pg_dump --schema %SCHEMA% --file %BACKUPFILE% --verbose -Fc -b %THEDBSOURCE% 
     131REM OK 
     132set SCHEMA=dmeer2003 
     133set BACKUPFILE=dmeer2003.backup 
     134pg_dump --schema %SCHEMA% --file %BACKUPFILE% --verbose -Fc -b %THEDBSOURCE% 
     135REM OK 
     136set SCHEMA=ecoregion2003 
     137set BACKUPFILE=ecoregion2003.backup 
     138pg_dump --schema %SCHEMA% --file %BACKUPFILE% --verbose -Fc -b %THEDBSOURCE% 
     139REM OK 
     140set SCHEMA= europe 
     141set BACKUPFILE= europe.backup 
     142pg_dump --schema %SCHEMA% --file %BACKUPFILE% --verbose -Fc -b %THEDBSOURCE% 
     143REM OK 
     144set SCHEMA= european_wise2008 
     145set BACKUPFILE= european_wise2008.backup 
     146pg_dump --schema %SCHEMA% --file %BACKUPFILE% --verbose -Fc -b %THEDBSOURCE% 
     147REM OK 
     148set SCHEMA= france 
     149set BACKUPFILE= france.backup 
     150pg_dump --schema %SCHEMA% --file %BACKUPFILE% --verbose -Fc -b %THEDBSOURCE% 
     151REM OK 
     152set SCHEMA= geobs2010 
     153set BACKUPFILE= geobs2010.backup 
     154pg_dump --schema %SCHEMA% --file %BACKUPFILE% --verbose -Fc -b %THEDBSOURCE% 
     155 
     156set SCHEMA= ia 
     157set BACKUPFILE= ia.backup 
     158pg_dump --schema %SCHEMA% --file %BACKUPFILE% --verbose -Fc -b %THEDBSOURCE% 
     159 
     160set SCHEMA= ireland 
     161set BACKUPFILE= ireland.backup 
     162pg_dump --schema %SCHEMA% --file %BACKUPFILE% --verbose -Fc -b %THEDBSOURCE% 
     163REM TODO 
     164set SCHEMA= onema 
     165set BACKUPFILE= onema.backup 
     166pg_dump --schema %SCHEMA% --file %BACKUPFILE% --verbose -Fc -b %THEDBSOURCE% 
     167 
     168set SCHEMA= oria 
     169set BACKUPFILE= oria.backup 
     170pg_dump --schema %SCHEMA% --file %BACKUPFILE% --verbose -Fc -b %THEDBSOURCE% 
     171REM TODO 
     172set SCHEMA= temperature 
     173set BACKUPFILE= temperature.backup 
     174pg_dump --schema %SCHEMA% --file %BACKUPFILE% --verbose -Fc -b %THEDBSOURCE% 
     175 
     176set SCHEMA= tidal 
     177set BACKUPFILE= tidal.backup 
     178pg_dump --schema %SCHEMA% --file %BACKUPFILE% --verbose -Fc -b %THEDBSOURCE% 
     179 
     180set SCHEMA= uk 
     181set BACKUPFILE= uk.backup 
     182pg_dump --schema %SCHEMA% --file %BACKUPFILE% --verbose -Fc -b %THEDBSOURCE% 
     183 
     184set SCHEMA= vilaine 
     185set BACKUPFILE= vilaine.backup 
     186pg_dump --schema %SCHEMA% --file %BACKUPFILE% --verbose -Fc -b %THEDBSOURCE% 
     187REM TODO 
     188set SCHEMA= wrbd 
     189set BACKUPFILE= wrbd.backup 
     190pg_dump --schema %SCHEMA% --file %BACKUPFILE% --verbose -Fc -b %THEDBSOURCE% 
     191 
    96192}}} 
    97193 
    … …  
    137233set PGHOST=1.100.1.6 
    138234set PGUSER=postgres 
    139 set PGPASSWORD=supersecret 
     235set PGPASSWORD=? 
    140236set THEDBSOURCE=eda2 
    141237set THEDEBDESTINATION=eda2.0 
    … …  
    158254}}} 
    159255 
    160 anglian             
     256 anglian             
    161257 bd_map              
    162258 belge