Re: Postgres-R: internal messaging

Поиск
Список
Период
Сортировка
От Markus Wanner
Тема Re: Postgres-R: internal messaging
Дата
Msg-id 488832C4.1010003@bluegap.ch
обсуждение исходный текст
Ответ на Re: Postgres-R: internal messaging  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Postgres-R: internal messaging
Список pgsql-hackers
Hi,

Tom Lane wrote:
> I hope you're not expecting the contents of shared memory to still be
> trustworthy after a backend crash.

Hm.. that's a good point.

So I either need to bullet-proof the imessages with checksums or some 
such. I'm not sure that's doable reliably. Not to speak about performance.

Thus it might be better to just restart the replication manager as well. 
Note that this means leaving the replication group temporarily and going 
through node recovery to apply remote transactions it has missed in 
between. This sounds expensive, but it's certainly the safer way to do 
it. And as such backend crashes are Expected Not To Happen(tm) on 
production systems, that's probably good enough.

> If the manager is working strictly
> from its own local memory, then it would be reasonable to operate
> as above.

That's not the case... :-(

Thanks for your excellent guidance.

Regards

Markus



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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Do we really want to migrate plproxy and citext into PG core distribution?
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: pltcl_*mod commands are broken on Solaris 10