Re: Postgres Admin - Export Database

Поиск
Список
Период
Сортировка
От Greg Spiegelberg
Тема Re: Postgres Admin - Export Database
Дата
Msg-id 407C1641.2070800@cranel.com
обсуждение исходный текст
Ответ на Postgres Admin - Export Database  (JinNet Picker <netpicker9@yahoo.com>)
Список pgsql-admin
JinNet Picker wrote:
> Hi,
>
> I am trying to take Database backup. I use this
> command.
>
> # ./pg_dump -U username -cif filename.sql dbname
>
> Its exporting, but in the Log, its giving like
>
> "LOG:  out of file descriptors: Too many open files;
> release and retry"
>
> Can anybody tell me what is this? And what i have to
> do clear this out??

Try the pg_dump option "-F t".  It will create a single tar file
that pg_restore can use.

./pg_dump -U username -ci -F t -f filename.tar dbname

Greg


--
Greg Spiegelberg
  Product Development Manager
  Cranel, Incorporated.
  Phone: 614.318.4314
  Fax:   614.431.8388
  Email: gspiegelberg@cranel.com
Technology. Integrity. Focus. V-Solve!



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

Предыдущее
От: "scott.marlowe"
Дата:
Сообщение: Re: varchar to text
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Postgres Admin - Export Database