Re: [PATCHES] wal_checksum = on (default) | off - Mailing list pgsql-hackers

From Zeugswetter Andreas ADI SD
Subject Re: [PATCHES] wal_checksum = on (default) | off
Date
Msg-id E1539E0ED7043848906A8FF995BDA57901A358BD@m0143.s-mxs.net
Whole thread Raw
In response to Re: [PATCHES] wal_checksum = on (default) | off  ("Simon Riggs" <simon@2ndquadrant.com>)
Responses 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>)
List 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 by date:

Previous
From: "Simon Riggs"
Date:
Subject: Re: [PATCHES] wal_checksum = on (default) | off
Next
From: Tom Lane
Date:
Subject: Re: [PATCHES] wal_checksum = on (default) | off