Re: [PATCHES] wal_checksum = on (default) | off

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas ADI SD
Тема Re: [PATCHES] wal_checksum = on (default) | off
Дата
Msg-id E1539E0ED7043848906A8FF995BDA57901A358BD@m0143.s-mxs.net
обсуждение исходный текст
Ответ на Re: [PATCHES] wal_checksum = on (default) | off  ("Simon Riggs" <simon@2ndquadrant.com>)
Ответы Re: [PATCHES] wal_checksum = on (default) | off  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [PATCHES] wal_checksum = on (default) | off  (Jim Nasby <decibel@decibel.org>)
Список pgsql-hackers
> > > > What's the use-case for changing the variable on the fly anyway?
Seems a
> > better
> > > > solution is just to lock down the setting at postmaster start.
> >
> > I guess that the use case is more for a WAL based replicate, that
> > has/wants a different setting. Maybe we want a WAL entry for the
change,
> > or force a log switch (so you can interrupt the replicate, change
it's
> > setting
> > and proceed with the next log) ?
> >
> > Maybe a 3rd mode for replicates that ignores 0 CRC's ?
>
> Well, wal_checksum allows you to have this turned ON for the main
server
> and OFF on a Warm Standby.

Ok, so when you need CRC's on a replicate (but not on the master) you
turn it
off during standby replay, but turn it on when you start the replicate
for normal operation.

Andreas

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

Предыдущее
От: "Simon Riggs"
Дата:
Сообщение: Re: [PATCHES] wal_checksum = on (default) | off
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [PATCHES] wal_checksum = on (default) | off