Changes between Version 17 and Version 18 of Recette PostgreSQL pgDump

Timestamp:

Mar 22, 2010 3:41:22 PM (15 years ago)

Author:

cedric

Comment:

--

Recette PostgreSQL pgDump

@@ -34 +34 @@
 
 
-== 4 Autres formats pour mémoire (Cédric) == 
+== 4 Autres formats == 
 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
+C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -h localhost -p 5433 -U postgres --create BD_CONTMIG_NAT > BD_CONTMIG_NAT22_03_2010.sql
 }}}
 
-restauration serveur localhost
-{{{
-cd c:\base
-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
-}}}
 
+