back to first page [..][[BR]]
back to ["CookBook Eda"] [[BR]]

= !CookBook postgres =
----------------


Saving a database : either use pgAdmin or in case of problems (cedric) use the script below...
{{{
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump.exe --host localhost --port 5433 --username postgres --format custom --blobs --verbose --file "C:\Documents and Settings\cedric\Mes documents\Migrateur\eda\BDMAP\export_BDMAP_pgsql_05022010.backup" "BDMAP"
}}}
Create a new postgres database with argis template [[BR]]
Restore the backup file [[BR]]
Cédric
{{{
REM move to local file where backup is stored
cd C:\Documents and Settings\cedric\Mes documents\Migrateur\eda\BDMAP
REM using postgresSQL 8.4
C:\"Program Files"\PostgreSQL\8.4\bin\pg_restore  -d BDMAP -U postgres -p 5433 export_BDMAP_pgsql_05022010.backup
}}}
Céline
{{{
REM move to local file where backup is stored
D:
cd D:\CelineJouanin\workspace\EDA
C:\"Program Files"\PostgreSQL\8.4\bin\pg_restore -d BDMAPEDA -U postgres -p 5432 export_BDMAP_pgsql_19012010.backup
}}}
''' How to save only a table '''
here I assume that the database is ''' BDMAP ''' user is ''' postgres ''' and table is codier  
{{{
cd C:\Documents and Settings\cedric\Mes documents\Migrateur\eda\backup2
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5433 -t ccm21.riversegments eda2.0> riversegments_backup.sql
}}}
''' How to load this table in another database '''
here the file is restored into the CCM_EDA database
{{{
C:\base>C:\"Program Files"\PostgreSQL\8.4\bin\psql -d CCM_EDA -p 5433 -U postgres -f stationsp2.sql
}}}
''' How to save only a schema '''
{{{
--schema=<SCHEMA>
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5433 --schema=ccm21 eda2.0> ccm21.sql
}}}
''' Save eda2.0 '''
{{{
cd C:\Documents and Settings\cedric\Mes documents\Migrateur\eda\backup2
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5433 --schema=ccm21 --verbose eda2.0> eda20ccm21.sql

restore

cd C:\Documents and Settings\cedric\Mes documents\Migrateur\eda\backup2
C:\"Program Files"\PostgreSQL\8.4\bin\psql --host=192.168.1.104 -d eda2.0 -p 5432 -U postgres -f eda20ccm21.sql

from abroad
C:\"Program Files"\PostgreSQL\8.4\bin\psql --host=93.20.247.238 -d eda2.0 -p 5432 -U postgres -f eda20ccm21.sql

sauvegarde de la base eda2.0, format tar, compression, creation de la base
cd C:\eda\backup
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump -U postgres -p 5433 --create --format=t --file=eda.tar eda2.0

from abroad
C:\"Program Files"\PostgreSQL\8.4\bin\pg_restore --host=93.20.247.238 -d eda2.0 -p 5432 -U postgres -f eda.backup

}}}