Changes between Version 3 and Version 4 of Download and load BDMAP

Timestamp:

Sep 1, 2010 11:58:26 AM (15 years ago)

Author:

celine

Comment:

--

Download and load BDMAP

@@ -6 +6 @@
 = Download and load the data BDMAP from sauv_BDMAP_31072010.backup=
 
-I have created a new database : BDMAP2010[[BR]]
+I have created a new database : BDMAP2[[BR]]
 There are columns : [[BR]]
 
 In cmd console :[[BR]]
 {{{
-C:\"Program Files"\PostgreSQL\8.4\bin\psql -p 5432 -U postgres -c "CREATE DATABASE bdmap2010  WITH OWNER = postgres  template=postgis ENCODING = 'UTF8'  LC_COLLATE = 'French_France.1252'  LC_CTYPE = 'French_France.1252' CONNECTION LIMIT = -1;"
+C:\"Program Files"\PostgreSQL\8.4\bin\psql -p 5432 -U postgres -c "CREATE DATABASE bdmap2  WITH OWNER = postgres  template=postgis ENCODING = 'UTF8'  LC_COLLATE = 'French_France.1252'  LC_CTYPE = 'French_France.1252' CONNECTION LIMIT = -1;"
 cd C:\Program Files\PostgreSQL\8.4\bin\
-pg_restore.exe --host localhost --port 5432 --username postgres --dbname "bdmap2010" --verbose "D:\CelineJouanin\BDMAP\sauv_BDMAP_31072010.backup"
+pg_restore.exe --host localhost --port 5432 --username postgres --dbname "bdmap2" --verbose "D:\CelineJouanin\BDMAP\sauv_BDMAP_31072010.backup"
 }}}
 
-New tables can be find in BDMAP2010 :[[BR]]
+New tables can be find in BDMAP2 :[[BR]]
    * mensurationindiv
    * ssecteur_hydro
@@ -26 +26 @@
 {{{
       --- In sql editor 
-      CREATE SCHEMA bdmap2010.bdmap;
+      CREATE SCHEMA bdmap2.bdmap;
       ALTER TABLE classe_taille_taxon SET SCHEMA bdmap;
       ALTER TABLE entitehydro SET SCHEMA bdmap;
@@ -47 +47 @@
 }}}
 
-Autre manière d'intégrer les données depuis le backup dans bdmap2010.bdmap
+Autre manière d'intégrer les données depuis le backup dans bdmap2.bdmap
 {{{