From: samana srikanth <samanasrikanth@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Postgressql backup/restore question
Date: Wed, 4 Mar 2009 17:26:32 +0530
Message-ID: <e42828680903040356o307031c2k7898562d8e2d275c@mail.gmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: samanasrikanth@gmail.com
Subject: Re: Postgressql backup/restore question
In-Reply-To: <e42828680903040356o307031c2k7898562d8e2d275c@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox