Postgres Export

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
phppick
Forum Commoner
Posts: 57
Joined: Thu Aug 14, 2003 5:59 am

Postgres Export

Post 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.
User avatar
d-m
Forum Commoner
Posts: 31
Joined: Fri Aug 29, 2003 4:24 pm
Location: Rio de Janeiro - RJ - Brasil

Post by d-m »

Try these:

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