Re: lost database

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.