Re: Postgres Server crashed - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: Postgres Server crashed
Date
Msg-id CAOR=d=37zi6FDPAJji6m=YEx5v4jR17ZidOfd9ATCME_0O-WbA@mail.gmail.com
Whole thread Raw
In response to Re: Postgres Server crashed  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-admin
On Mon, Oct 10, 2011 at 2:59 PM, Kevin Grittner
<Kevin.Grittner@wicourts.gov> wrote:
> Akash Kodibail <akash.kodibail@onmobile.com> wrote:
>
>> Can you please help me out in the options that might have to be
>> set for pg_resetxlog.
>
> It should normally be able to calculate what it needs if you just
> point it at the data directory.  I would run it with the -n (no
> operation) flag first, to see what it plans to do.  If that looks
> sane, run again without the -n switch.

But it uses pg_controldata to determine what it needs automagically.
So...  Since his pg_controldata is not the up to date one he's gonna
have to figure out what number to give it.  I have no clue how to do
that at this point.

pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Postgres Server crashed
Next
From: Akash Kodibail
Date:
Subject: Re: Postgres Server crashed