Re: Postgres Admin - Export Database

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!