From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
---|---|
To: | Rogel Nocedo <Rogeln(at)theservicemanager(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg_dump |
Date: | 2011-09-13 10:16:15 |
Message-ID: | 4E6F2D6F.1060102@iol.ie |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)iol(dot)ie
From | Date | Subject | |
---|---|---|---|
Next Message | Vincent de Phily | 2011-09-13 10:34:01 | Re: Re: Need help with what I think is likely a simple query - for each distinct val, return only one record with the most recent date. |
Previous Message | Dave Cramer | 2011-09-13 09:34:11 | Re: Alternative JDBC driver |