Re: restore database from bare files

From: "Martin Fandel" <martin(dot)fandel(at)alphyra-evs(dot)de>
To: jehan <jehan(dot)procaccia(at)free(dot)fr>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: restore database from bare files
Date: 2005-06-30 06:32:52
Message-ID: 1120113173.18693.39.camel@fandelm.ecommit.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message KÖPFERL Robert 2005-06-30 08:06:38 Re: Checkpoints - what happens actually?
Previous Message jehan 2005-06-30 05:34:54 Re: restore database from bare files