back to first page..
go to Work program - Spain

Saving and loading the database with Eider and Aizkorri

Saving the database dbeel and eda2.0 -from Céline computer

---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
---Saving ecoregion2003
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5432 --schema ecoregion2003 --verbose eda2.0> ecoregion2003.sql
---Saving anglian
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5432 --schema anglian --verbose eda2.0> anglian.sql
---Saving wrbd
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5432 --schema wrbd --verbose eda2.0> wrbd.sql

Integrating into PostgreSQL on the Eider and Aizkorri server

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 para PostgreSLQ 9.1
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'"

---Creation de la base de données bd_carthage2011 para PostgreSLQ 8.4
C:\"Archivos de programa"\PostgreSQL\8.4\bin\psql -p 5432 -U postgres -c "CREATE DATABASE eda2.0  WITH OWNER = postgres  template=postgis;"
C:\"Archivos de programa"\PostgreSQL\8.4\bin\psql -p 5432 -U postgres -c "COMMENT ON DATABASE eda2.0 IS 'database eda2.0 with the projection in ETRS LAEA'"

--Restore
cd ..
cd C:\EDA_Spain\export_table
C:\"Archivos de programa"\PostgreSQL\8.4\bin\psql -U postgres -h localhost --dbname "eda2.0" --file "oria.sql"
C:\"Archivos de programa"\PostgreSQL\8.4\bin\psql -U postgres -h localhost --dbname "eda2.0" --file "ccm21.sql"
C:\"Archivos de programa"\PostgreSQL\8.4\bin\psql -U postgres -h localhost --dbname "eda2.0" --file "clc.sql"
C:\"Archivos de programa"\PostgreSQL\8.4\bin\psql -U postgres -h localhost --dbname "eda2.0" --file "europe.sql"
C:\"Archivos de programa"\PostgreSQL\8.4\bin\psql -U postgres -h localhost --dbname "eda2.0" --file "rbd_f1v3.sql"
C:\"Archivos de programa"\PostgreSQL\8.4\bin\psql -U postgres -h localhost --dbname "eda2.0" --file ecoregion2003.sql
C:\"Archivos de programa"\PostgreSQL\8.4\bin\psql -U postgres -d dbeel -p 5432 -f dbeel_12032010.sql

​http://trac.eptb-vilaine.fr:8066/trac/wiki/CookBook%20shptopostgres
To create the database go here:CookBook shptopostgres

To know how many lines you have in the table estaciones_st from the schema oria
select count(*) from oria.estaciones_st
Para riversegments
select count(*) from ccm21.riversegments