Postgres fails to start

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.

Responses

Browse pgsql-general by date

  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