Re: Postgres Start up Error - Mailing list pgsql-general

From Craig Ringer
Subject Re: Postgres Start up Error
Date
Msg-id 4DAC166E.3080305@postnewspapers.com.au
Whole thread Raw
In response to Re: Postgres Start up Error  (Adarsh Sharma <adarsh.sharma@orkash.com>)
List pgsql-general
On 04/18/2011 04:01 PM, Adarsh Sharma wrote:
>
> Thanks Chetan,
>
> The problem is solved by the below command :-:-)
>
> [postgres@ws-test 8.4SS]$ bin/pg_resetxlog -f /hdd-1/PostgresPlus/8.4SS/data

It's a really good idea to pg_dump, initdb, and restore after doing
that. You don't know your database is in a good state.

--
Craig Ringer

pgsql-general by date:

Previous
From: Tore Halvorsen
Date:
Subject: Re: Using column aliasses in the same query
Next
From: Filip Rembiałkowski
Date:
Subject: Re: Help - corruption issue?