Re: unable to locate a valid checkpoint - Mailing list pgsql-admin

From Auri Mason
Subject Re: unable to locate a valid checkpoint
Date
Msg-id Pine.LNX.4.44.0203250917040.11445-100000@mendeleev.syntrex.com
Whole thread Raw
In response to Re: unable to locate a valid checkpoint  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: unable to locate a valid checkpoint
List pgsql-admin
Hi Tom & pg_list,

> "Shutdown"?  Exactly what happened there?  It certainly doesn't look
> like you had a clean shutdown.

mmm, yes the postmaster was running in foregroud and was interrupted by a
CTRL+C....

What's the correct way to shutdown? kill -15 I think...

> At this point I think your only hope is contrib/pg_resetxlog, but that's
> a very blunt instrument.  It'd be nice to understand what went wrong.

pg_resetxlog.... mmm I've to read something about this command! U think
this is the solution?

TIA, Auri



pgsql-admin by date:

Previous
From: Morten Sickel
Date:
Subject: Re: Group By Time Stamp
Next
From: "Gaetano Mendola"
Date:
Subject: Time stamp on log file