Postgressql backup/restore question

From: samana srikanth <samanasrikanth(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Postgressql backup/restore question
Date: 2009-03-04 11:56:32
Message-ID: e42828680903040356o307031c2k7898562d8e2d275c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all

Can we do a point-in-time restore of a single database out of n databases??.
------------------------------------------------------------------------------------------------------------------------------------------
I have 5 databases in the postgresql server.

I have taken full-backup of the entire data directory (/opt/postgresql/data)
and individual dumps also (for safety).
then i have taken all the log files till now.
Now, the server is crashed.

Is there anyway to restore only 1 database out of total 5 database to
particular point-in-time. (similar to Mysql)

I have individual dumps of each database and all corresponding log files
from that time.
Can i selectively restore the databases.

Can I use dump files + log files to restore the databases.
---------------------------------------------------------------------------------------------------------------------------------------------

Please help me in this regards

Thanks
Srikanth

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2009-03-04 13:59:52 Re: Postgressql backup/restore question
Previous Message Richard Stephan 2009-03-04 01:33:01 SSL Connections from Windows Clients