newsgroups-index (beta)

Current group: pgsql.general

Re: Restoring fscked up postgres 7.1

Re: Restoring fscked up postgres 7.1  
Greg Stark
From:Greg Stark
Subject:Re: Restoring fscked up postgres 7.1
Date:21 Jan 2005 11:37:15 -0500

Kristaps Armanis 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


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
   

Copyright © 2006 newsgroups-index   -   All rights reserved   -   Impressum