pg_dump

Поиск
Список
Период
Сортировка
От Rogel Nocedo
Тема pg_dump
Дата
Msg-id 0D7BDC59EDA696468701EE4ED5FDE5E4498EED@bs1.proware.com
обсуждение исходный текст
Ответы Re: pg_dump
Re: pg_dump
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Reid Thompson
Дата:
Сообщение: 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.
Следующее
От: Reid Thompson
Дата:
Сообщение: 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.