Re: lost database - Mailing list pgsql-admin

From Joe Conway
Subject Re: lost database
Date
Msg-id 3FD60426.5040306@joeconway.com
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. 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.

Restore the entire $PGDATA directory. If this is a default Red Hat
system that would be something like /var/lib/pgsql/data

HTH,

Joe



pgsql-admin by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: lost database
Next
From: Teodor Sigaev
Date:
Subject: Re: Full textsearch & gist (fwd)