Changes between Version 16 and Version 17 of Recette PostgreSQL pgDump

Timestamp:

Mar 22, 2010 2:36:05 PM (15 years ago)

Author:

cedric

Comment:

--

Recette PostgreSQL pgDump

@@ -14 +14 @@
 {{{
 CD C:/base
-C:\"Program Files"\PostgreSQL\8.4\bin\pg_restore -U postgres -f BD_CONTMIG_NAT22_03_2010.dump
+C:\"Program Files"\PostgreSQL\8.4\bin\psql -d -U postgres -f BD_CONTMIG_NAT22_03_2010.dump
 }}}
 == 2.1 Sauvegarde d'un schéma ==
@@ -35 +35 @@
 
 == 4 Autres formats pour mémoire (Cédric) == 
-restauration serveur IAV
+sauvegarde poste Cédric sans compression ni create
+{{{
+CD C:\base
+C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -h localhost -p 5433 -U postgres  -c BD_CONTMIG_NAT > BD_CONTMIG_NAT22_03_2010.dump
+}}}
+
+restauration serveur localhost
 {{{
 cd c:\base
-C:\"Program Files"\PostgreSQL\8.4\bin\pg_restore -h 192.168.1.104 -p 5433 -U postgres -C -f BD_CONTMIG_NAT22_03_2010.dump
-}}}
-sauvegarde poste Cédric
-{{{
-CD C:\base
-C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -h localhost -p 5433 -U postgres  -Z -C -c BD_CONTMIG_NAT > BD_CONTMIG_NAT22_03_2010.dump
+C:\"Program Files"\PostgreSQL\8.4\bin\psql -h localhost -p 5432 -U postgres -c "CREATE DATABASE bd_contmig_nat ENCODING 'WIN1252' TEMPLATE template0"
+C:\"Program Files"\PostgreSQL\8.4\bin\psql -h 192.168.1.104 -p 5432 -U postgres -d bd_contmig_nat -f BD_CONTMIG_NAT22_03_2010.dump
 }}}