From: | Haiming Zhang <Haiming(dot)Zhang(at)redflex(dot)com(dot)au> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Postgres fails to start |
Date: | 2015-04-07 00:25:53 |
Message-ID: | 840b7ab0ae0d48c9885708d17dad7174@RTS-EXCHANGE01.traffic.redflex.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi All,
I have experienced that Postgres services was not able to start, I tried from Services and command, and both were failed. Here are the logs I got, please help. (I am using postgres 9.1 and there are plenty disk space left).
2015-04-07 09:01:28 EST LOG: database system was interrupted while in recovery at 2015-04-07 08:53:41 EST
2015-04-07 09:01:28 EST HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery.
2015-04-07 09:01:28 EST FATAL: the database system is starting up
2015-04-07 09:01:28 EST LOG: database system was not properly shut down; automatic recovery in progress
2015-04-07 09:01:28 EST LOG: redo starts at CD1/3C1414D0
2015-04-07 09:01:29 EST FATAL: the database system is starting up
2015-04-07 09:01:30 EST FATAL: the database system is starting up
2015-04-07 09:01:31 EST FATAL: the database system is starting up
2015-04-07 09:01:32 EST FATAL: the database system is starting up
2015-04-07 09:01:33 EST FATAL: the database system is starting up
2015-04-07 09:01:34 EST FATAL: the database system is starting up
2015-04-07 09:01:35 EST FATAL: the database system is starting up
2015-04-07 09:01:36 EST FATAL: the database system is starting up
2015-04-07 09:01:37 EST FATAL: the database system is starting up
2015-04-07 09:01:38 EST FATAL: the database system is starting up
2015-04-07 09:01:39 EST FATAL: the database system is starting up
2015-04-07 09:01:40 EST FATAL: the database system is starting up
2015-04-07 09:01:41 EST FATAL: the database system is starting up
2015-04-07 09:01:43 EST FATAL: the database system is starting up
2015-04-07 09:01:43 EST LOG: unrecognized win32 error code: 1392
2015-04-07 09:01:43 EST CONTEXT: xlog redo split_r: rel 1663/2008723533/2107262657 left 375921, right 379817, next 376394, level 0, firstright 95
2015-04-07 09:01:43 EST FATAL: could not extend file "base/2008723533/2107262657.2": Invalid argument
2015-04-07 09:01:43 EST HINT: Check free disk space.
2015-04-07 09:01:43 EST CONTEXT: xlog redo split_r: rel 1663/2008723533/2107262657 left 375921, right 379817, next 376394, level 0, firstright 95
2015-04-07 09:01:44 EST LOG: startup process (PID 2652) exited with exit code 1
2015-04-07 09:01:44 EST LOG: aborting startup due to startup process failure
Regards,
Haiming Zhang
Software Engineer
________________________________
If you are not an authorised recipient of this e-mail, please contact me at Redflex immediately by return phone call or by email. In this case, you should not read, print, retransmit, store or act in reliance on this e-mail or any attachments, and should destroy all copies of them. This e-mail and any attachments are confidential and may contain privileged information and/or copyright material of Redflex or third parties. You should only retransmit, distribute or commercialise the material if you are authorised to do so. This notice should not be removed.
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2015-04-07 01:36:25 | Re: Postgres fails to start |
Previous Message | Pweaver (Paul Weaver) | 2015-04-06 19:46:08 | Re: ERROR: could not access status of transaction 283479860 |