Postgres fails to start
| От | Haiming Zhang |
|---|---|
| Тема | Postgres fails to start |
| Дата | |
| Msg-id | 840b7ab0ae0d48c9885708d17dad7174@RTS-EXCHANGE01.traffic.redflex.com.au обсуждение исходный текст |
| Ответы |
Re: Postgres fails to start
(Michael Paquier <michael.paquier@gmail.com>)
|
| Список | 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.
В списке pgsql-general по дате отправления:
Предыдущее
От: "Pweaver (Paul Weaver)"Дата:
Сообщение: Re: ERROR: could not access status of transaction 283479860