Re: restore database from bare files - Mailing list pgsql-admin

From Martin Fandel
Subject Re: restore database from bare files
Date
Msg-id 1120113173.18693.39.camel@fandelm.ecommit.de
Whole thread Raw
In response to Re: restore database from bare files  (jehan <jehan.procaccia@free.fr>)
Responses Re: restore database from bare files  (jehan-free <jehan.procaccia@free.fr>)
List pgsql-admin
Hi

Maybe you must reset the WAL's
( http://www.postgresql.org/docs/7.3/interactive/app-pgresetxlog.html )
after restoring from tarball if postgres doesn't start.

Am Donnerstag, den 30.06.2005, 07:34 +0200 schrieb jehan:
> So I must one way or another run a 7.3, restore the file from the
> tarball as is (just put them back to /var/lib/pgsql), the databases
> should be running correctly then (?), then pg_dump it , upgrade to 7.4
> and restore from the pg_dump .
> before running in all this (and I still don't know how I will be able to
> get a 7.3 on RHEL4 ... ?) is that the correct procedure ?
> thanks

yes, this is the correct way :).

Martin


pgsql-admin by date:

Previous
From: jehan
Date:
Subject: Re: restore database from bare files
Next
From: KÖPFERL Robert
Date:
Subject: Re: Checkpoints - what happens actually?