Re: lost database - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: lost database
Date
Msg-id 200312091818.55401.peter_e@gmx.net
Whole thread Raw
In response to Re: lost database  (Jodi Kanter <jkanter@virginia.edu>)
List pgsql-admin
Jodi Kanter wrote:
> I am not sure I understand your question. why does the type of backup
> matter? It is a tape backup and it includes the entire /var directory
> where the pgsql directory exists.

That was the missing piece of information.

> I am trying to determine what
> particular files need to be retrieved in order to restore the
> database as it existed yesterday. Is this possible?
> Thanks for the assistance.

Shut down the server if still running, put back the entire data
directory (probably /var/lib/pgsql in your case), and start the server.
Partial restoration is not possibly from file system backup.


pgsql-admin by date:

Previous
From: Joe Conway
Date:
Subject: Re: Postgres grabbing an old shared object
Next
From: Joe Conway
Date:
Subject: Re: lost database