Changes between Version 2 and Version 3 of Ticket #84, comment 4


Ignore:
Timestamp:
May 28, 2018 12:20:32 PM (7 years ago)
Author:
cedric
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #84, comment 4

    v2 v3  
    77save content of tables using -a options 
    88restore it 
     9 
     10== ccm21 == 
     11 
    912source:eda/EDACCM/sql/script_restore_v15to24.sql 
    1013 
     14=== Sauvegarde du schema ccm21 === 
     15{{{#!sh 
     16 pg_dump -U postgres -h 1.100.1.6 -W -s --schema ccm21 -f "ccm21.catchments_str.sql" eda2 
     17}}} 
     18 
     19virer la référence à public.geometry 
     20vérifier les fonctions de base OK 
     21 
     22=== catchments === 
     23 
     24{{{#!sh 
     25 pg_dump -U postgres -h 1.100.1.6 -a -W --verbose -f "ccm21.catchments.sql" --table ccm21.catchments eda2 
     26psql -U postgres -h localhost -f "ccm21.catchments.sql" eda2 
     27}}} 
     28 
     29=== riversegments === 
     30 
     31{{{#!sh 
     32pg_dump -U postgres -h 1.100.1.6 -a -W --verbose -f "ccm21.riversegments.sql" --table ccm21.riversegments eda2 
     33psql -U postgres -h localhost -f "ccm21.riversegments.sql" eda2 
     34}}} 
     35 
     36