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

Service not starting.. Timed out waiting for server startup

P: 1
I am trying to start Postgresql 8.2.13 in Windows Server 2008 machine but is not starting..Service is getting timed out..
No specific error in the Aplication log in event viwer..

It was previusly running .. But after a server restart this was happening..

Is there any way I can recover the data?

The pg_log says

2014-08-21 17:13:30 LOG: database system was interrupted while in recovery at 2014-08-21 17:09:36

2014-08-21 17:13:30 HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery.

2014-08-21 17:13:30 LOG: checkpoint record is at 1E/2642B120

2014-08-21 17:13:30 LOG: redo record is at 1E/2642B120; undo record is at 0/0; shutdown FALSE

2014-08-21 17:13:30 LOG: next transaction ID: 0/16132809; next OID: 155877

2014-08-21 17:13:30 LOG: next MultiXactId: 13335; next MultiXactOffset: 28458

2014-08-21 17:13:30 LOG: database system was not properly shut down; automatic recovery in progress

2014-08-21 17:13:30 LOG: redo starts at 1E/2642B170

2014-08-21 17:13:30 FATAL: could not create relation 1663/22834/24343: File exists

2014-08-21 17:13:30 CONTEXT: xlog redo update: rel 1663/22834/24343; tid 6837/17; new 6837/22

2014-08-21 17:13:30 LOG: startup process (PID 225924) exited with exit code 1

2014-08-21 17:13:30 LOG: aborting startup due to startup process failure

2014-08-21 17:13:31 LOG: logger shutting down
Aug 21 '14 #1
Share this question for a faster answer!
Share on Google+

Post your reply

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