Re: Postgressql backup/restore question - Mailing list pgsql-admin

From Tom Lane
Subject Re: Postgressql backup/restore question
Date
Msg-id 6347.1236199034@sss.pgh.pa.us
Whole thread Raw
In response to Re: Postgressql backup/restore question  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Postgressql backup/restore question  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-admin
Simon Riggs <simon@2ndQuadrant.com> writes:
> On Wed, 2009-03-04 at 15:59 +0200, Peter Eisentraut wrote:
>> samana srikanth wrote:
>>> Can we do a point-in-time restore of a single database out of n
>>> databases??.
>>
>> In principle no.  But you could invent workarounds such as recovering to
>> the point where you are happy with your restored one database, and then
>> restore the other n-1 databases from an SQL dump.

> It is possible, but we just don't currently support it.

It's not as easy as all that.  What will you do with updates to shared
catalogs?

            regards, tom lane

pgsql-admin by date:

Previous
From: Ray Stell
Date:
Subject: Re: standby waiting for what?
Next
From: Tom Lane
Date:
Subject: Re: getting 'full' names of functions?