I am trying to start Postgresql 8.2.13 in Windows Server 2008 machine but is not starting..Servi ce 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
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