Postgres Start up Error

From: Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgres Start up Error
Date: 2011-04-18 05:30:23
Message-ID: 4DABCC6F.8090701@orkash.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

Dear all,

Today I by mistake deleted all the contents of pg_log & pg_xlog
directory and my Postgresql refuses to start due to the below error :-

2011-04-18 10:51:39 ISTLOG: database system was interrupted; last known
up at 2011-04-18 10:06:42 IST
2011-04-18 10:51:39 ISTLOG: could not open file
"pg_xlog/000000010000000600000007" (log file 6, segment 7): No such file
or directory
2011-04-18 10:51:39 ISTLOG: invalid primary checkpoint record
2011-04-18 10:51:39 ISTLOG: could not open file
"pg_xlog/0000000100000005000000C9" (log file 5, segment 201): No such
file or directory
2011-04-18 10:51:39 ISTLOG: invalid secondary checkpoint record
2011-04-18 10:51:39 ISTPANIC: could not locate a valid checkpoint record
2011-04-18 10:51:39 ISTLOG: startup process (PID 11021) was terminated
by signal 6: Aborted
2011-04-18 10:51:39 ISTLOG: aborting startup due to startup process failure

I try to reinstall with the same previous data directory, but it fails
again.

Any suggestions to solve it without losing the previous data.

Thanks & best Regards,
Adarsh Sharma

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Phoenix Kiula 2011-04-18 05:52:01 Help - corruption issue?
Previous Message Craig Ringer 2011-04-18 04:00:29 Re: How to configure a read-only database server and session? (Was: read-only UNLOGGED tables)

Browse pgsql-novice by date

  From Date Subject
Next Message Chetan Suttraway 2011-04-18 07:16:14 Re: [GENERAL] Postgres Start up Error
Previous Message Basil Bourque 2011-04-16 03:36:30 Can a client connection set variables on the server-side?