back to first page ..
back to CookBook Eda

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
Restore the backup file
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