Re: pg_dump

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@iol.ie