Postgres Pro
Downloads
Home   >   mailing lists

Re: pg recovery - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg recovery
Date
Msg-id 6006.1199115273@sss.pgh.pa.us
Whole thread Raw
In response to pg recovery  (Bernhard D Rohrer <graylion@sm-wg.net>)
Responses Re: pg recovery  (Bernhard D Rohrer <graylion@sm-wg.net>)
List pgsql-admin
Tree view 
Bernhard D Rohrer <graylion@sm-wg.net> writes:
> I have a broken database and not much clue about postgres, sorry for the
> n00b questions :(

I think you've got a cross-version problem, as in the database is really
PG 8.0 or earlier but you're trying to run 8.1 against it.  What is in
the PG_VERSION file?  Have you done "pg_resetxlog -f", and if so do you
have the original pg_control file to put back?

            regards, tom lane

pgsql-admin by date:

Previous
From: Bernhard D Rohrer
Date:
Subject: pg recovery
Next
From: Lew
Date:
Subject: Re: high-availability on MS Windows cluster -- need insights