By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,257 Members | 2,812 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,257 IT Pros & Developers. It's quick & easy.

pg_dump fails with error "The database system is starting up"

P: 5
One of our customers who using PostgreSQL7.2.1 encountered the following error when they back up the database using pg_dump.exe.

[command]:
pg_dump.exe -f <filename> <dbname>

[error message]:
pg_dump.exe: [archiver (db)] connection to database "<dbname>" failed: FATAL 1: The database system is starting up

When "The database system is starting up" error occurs?
On the same system, other sql commands(such as drop table, select,delete, etc) can be executed even after the error.

What is the problem and is there any solution?

Thanks in advance.
Sep 1 '11 #1
Share this Question
Share on Google+
5 Replies


Expert 100+
P: 700
On the same system, other sql commands(such as drop table, select,delete, etc) can be executed even after the error.
What do you mean "even after the error".
Is the database working correctly?
Sep 6 '11 #2

P: 5
>What do you mean "even after the error".
>Is the database working correctly?

Yes. Only pg_dump fails.
Sep 7 '11 #3

Expert 100+
P: 700
Are there any othe error messages? Maybe somehting was written to the log file.
Sep 12 '11 #4

P: 4
Use the pg_dump -U username -f filename.sql databasename OR pg_dump -U username databasename > filename. It will prompt for a password you would have to enter the password.
Or use pg_dumpall function and see what happens. If you get error with particular table not dumping you can use pg_dump with -t or -T to dump certain table.
Sep 20 '11 #5

P: 5
It seems that postgresql has not been startup yet at the moment, because other SQL commands can be executed even after the error. This phenomenon happened at one of our customer and I suggested to execute pg_dump after some minutes, and not soon after postgresql being started.

Thank you very much, rski and hikmat.
Sep 21 '11 #6

Post your reply

Sign in to post your reply or Sign up for a free account.