Re: unable to locate a valid checkpoint

From: Auri Mason <amason(at)syntrex(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: unable to locate a valid checkpoint
Date: 2002-03-25 08:23:08
Message-ID: Pine.LNX.4.44.0203250917040.11445-100000@mendeleev.syntrex.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Gaetano Mendola 2002-03-25 08:40:09 Time stamp on log file
Previous Message Morten Sickel 2002-03-25 07:44:41 Re: Group By Time Stamp