Page 1 of 1

Postgres Export

Posted: Tue Apr 13, 2004 3:37 am
by phppick
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??

Thanks.

Posted: Tue Jun 22, 2004 12:39 pm
by d-m
Try these:

/usr/local/pgsql/bin/pg_dump -U username -C DATABASENAME > /tmp/dump_DATABASE