Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] Postgres Start up Error

From: Chetan Suttraway <chetan(dot)suttraway(at)enterprisedb(dot)com>
To: Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [GENERAL] Postgres Start up Error
Date: 2011-04-18 07:16:14
Message-ID: BANLkTinL12U-d2Z86prsPTEnYxQQH6j64Q@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-novice
On Mon, Apr 18, 2011 at 11:00 AM, Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com>wrote:

> 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
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>


A quick search on message archives pointed to below link:
http://archives.postgresql.org/pgsql-admin/2000-10/msg00000.php
http://archives.postgresql.org/pgsql-admin/2002-04/msg00013.php
http://archives.postgresql.org/pgsql-bugs/2009-03/msg00118.php

Maybe someone here can point the exact steps to be followed.

-- 
Regards,
Chetan Suttraway
EnterpriseDB <http://www.enterprisedb.com/>, The Enterprise
PostgreSQL<http://www.enterprisedb.com/>
 company.

In response to

Responses

pgsql-novice by date

Next:From: Adarsh SharmaDate: 2011-04-18 08:01:01
Subject: Re: Postgres Start up Error
Previous:From: Adarsh SharmaDate: 2011-04-18 05:30:23
Subject: Postgres Start up Error

pgsql-general by date

Next:From: Adarsh SharmaDate: 2011-04-18 08:01:01
Subject: Re: Postgres Start up Error
Previous:From: Phoenix KiulaDate: 2011-04-18 05:52:01
Subject: Help - corruption issue?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group