Re: Restoring fscked up postgres 7.1 - Mailing list pgsql-general

From Greg Stark
Subject Re: Restoring fscked up postgres 7.1
Date
Msg-id 87651qagck.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: Restoring fscked up postgres 7.1  (Kristaps Armanis <krisha@grafton.lv>)
List pgsql-general
Kristaps Armanis <krisha@grafton.lv> writes:

> Is there any solution?

I think what you have to do is use pg_resetxlog with -x and a value just shy
of 2^32. then pg_dump and restore into a fresh database. I've never done it
though so perhaps you should wait until someone with more experience speaks
up. I would also suggest taking a cold backup of the bad database before
running pg_resetxlog.

--
greg

pgsql-general by date:

Previous
From: Mário Gamito
Date:
Subject: static pgadmin
Next
From: Bruno Wolff III
Date:
Subject: Re: Multiline plpython procedure