On 13/09/2011 03:40, Rogel Nocedo wrote: > Hi! > > How can I please a directory folder where my backup files will be > placed? I am calling pg_dump > > C:\Program Files (x86)\PostgreSQL\9.0\bin>pg_dump -i -h localhost -p > 5433 -U postgres -f add.sql --column-inserts -t address my_db > > C:\Program Files (x86)\PostgreSQL\9.0\bin>pg_dump -i -h localhost -p > 5433 -U postgres -f phone.sql --column-inserts -t phone my_db > > I tried these but did not work. > > C:\Program Files (x86)\PostgreSQL\9.0\bin>pg_dump -i -h localhost -p > 5433 -U postgres -f C:\dbbackup13092011\add.sql --column-inserts -t > address my_db > > C:\Program Files (x86)\PostgreSQL\9.0\bin>pg_dump -i -h localhost -p > 5433 -U postgres -f C:\dbbackup13092011\phone.sql --column-inserts -t > phone my_db > > C:\dbbackup does not exist yet. You need to create the directory first - pg_dump won't create it for you. BTW, if you're running a 64-bit OS (from the paths above), there's a 64-bit Windows version of PG. -- Raymond O'Donnell :: Galway :: Ireland rod@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
