pg_dump

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

Responses

  • Re: pg_dump at 2011-09-13 07:05:28 from John R Pierce
  • Re: pg_dump at 2011-09-13 10:16:15 from Raymond O'Donnell

Browse pgsql-general by date

  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?