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


Ignore:
Timestamp:
May 28, 2018 1:45:04 PM (7 years ago)
Author:
cedric
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #84, comment 4

    v5 v6  
    1 = SCRIPT DE RESTORATION MANUELLE = 
     1= MANUAL RESTORATION = 
    22 
    3 none of other scripts have worked I have to do it the hard way. 
     3none of other scripts have worked I have to do it the hard way for the ccm21 scheme. Then I can apply the hard upgrade on other tables 
     4the manual save is as following : 
    45Save structure of table 
    56Edit manually 
    … …  
    1213source:eda/EDACCM/sql/script_restore_v15to24.sql 
    1314 
    14 === Sauvegarde du schema ccm21 === 
     15=== savingd schema ccm21 === 
    1516{{{#!sh 
    1617 pg_dump -U postgres -h 1.100.1.6 -W -s --schema ccm21 -f "ccm21.catchments_str.sql" eda2 
    1718}}} 
    1819 
    19 virer la référence à public.geometry 
    20 vérifier les fonctions de base OK 
     20remove reference to public.geometry 
     21verify base functions OK 
    2122 
    2223=== catchments === 
    … …  
    3940}}} 
    4041 
    41 == dbeel == 
     42=== dbeel === 
    4243 
    4344{{{#!sh 
    … …  
    5253set PATH=%PATH%;"%PGINSTALL%\bin" 
    5354perl "%PGINSTALL%\utils\postgis_restore.pl" "%BACKUPFILE%" | psql %THEDB% 2> errors.txt 
     55set BACKUPFILE=dbeel.backup 
     56perl "%PGINSTALL%\utils\postgis_restore.pl" "%BACKUPFILE%" | psql %THEDB% 2> errors.txt 
    5457}}}