Re: Postgressql backup/restore question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Simon Riggs <simon(at)2ndQuadrant(dot)com>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, samana srikanth <samanasrikanth(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Postgressql backup/restore question
Date: 2009-03-04 20:37:14
Message-ID: 6347.1236199034@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Simon Riggs <simon(at)2ndQuadrant(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2009-03-04 20:38:39 Re: getting 'full' names of functions?
Previous Message Ray Stell 2009-03-04 20:34:02 Re: standby waiting for what?