Re: Replication and PITR

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: Replication and PITR
Дата
Msg-id 20060926091011.GA19913@svana.org
обсуждение исходный текст
Ответ на Re: Replication and PITR  (Csaba Nagy <nagy@ecircle-ag.com>)
Список pgsql-general
On Tue, Sep 26, 2006 at 11:00:56AM +0200, Csaba Nagy wrote:
> Of course there might be other problems too.

Another thing would be that the read-only transaction still needs a
snapshot, and whatever transaction ID it uses will have been used by
the server also.

I think the visibility issue may be solvable as long as the transaction
ID on the slave doesn't pass the VACUUM horizon of the server. But it
would require careful studying of the WAL write order to be confident
it would actually work.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Csaba Nagy
Дата:
Сообщение: Re: Replication and PITR
Следующее
От: "Gurjeet Singh"
Дата:
Сообщение: Re: in failed sql transaction