back to first page[..][[BR]]
go to ["Work program - Spain"][[BR]]

= Saving and loading the database with Eider =

{{{
#!sql
---Saving the dbeel
D:
cd D:\CelineJouanin\oria\export table
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5432 dbeel> dbeel_12032010.sql
---Saving schema oria
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5432 --schema oria --verbose eda2.0> oria.sql
---Saving schema ccm21
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5432 --schema ccm21 --verbose eda2.0> ccm21.sql
---Saving schema clc
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5432 --schema clc --verbose eda2.0> clc.sql
---Saving schema europe
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5432 --schema europe --verbose eda2.0> europe.sql
---Saving rbd_f1v3
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5432 --schema rbd_f1v3 --verbose eda2.0> rbd_f1v3.sql

Create new database eda2.0
right clic, create new database, use template postgis to that the database is a geodatabase 
---Creation de la base de données bd_carthage2011
C:\"Archivos de programa"\PostgreSQL\9.1\bin\psql -p 5432 -U postgres -c "CREATE DATABASE eda2.0  WITH OWNER = postgres  template=postgis;"
C:\"Archivos de programa"\PostgreSQL\9.1\bin\psql -p 5432 -U postgres -c "COMMENT ON DATABASE eda2.0 IS 'database eda2.0 with the projection in ETRS LAEA'"

--Restore
C:\"Archivos de programa"\PostgreSQL\9.1\bin\psql -U postgres -h localhost --dbname "eda2.0" --file "dbeel_12032010.sql"