Re: Postgressql backup/restore question

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Postgressql backup/restore question
Дата
Msg-id 6347.1236199034@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Postgressql backup/restore question  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: Postgressql backup/restore question  (Simon Riggs <simon@2ndQuadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: Ray Stell
Дата:
Сообщение: Re: standby waiting for what?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: getting 'full' names of functions?