From: | "Rogel Nocedo" <Rogeln(at)theservicemanager(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | pg_dump |
Date: | 2011-09-13 02:40:27 |
Message-ID: | 0D7BDC59EDA696468701EE4ED5FDE5E4498EED@bs1.proware.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
Please advise.
Thanks and Regards,
Rogel
From | Date | Subject | |
---|---|---|---|
Next Message | Reid Thompson | 2011-09-13 02:51:54 | 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 | Richard Broersma | 2011-09-13 02:26:51 | Re: Foreign key check only if not null? |