Re: Improve handling of parameter differences in physical replication
Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
To: PostgreSQL-development <pgsql-hackers@postgresql.org>
Cc: Sergei Kornilov <sk@zsrv.org>, Masahiko Sawada <masahiko.sawada@2ndquadrant.com>, Kyotaro Horiguchi <horikyota.ntt@gmail.com>, Álvaro Herrera <alvherre@2ndquadrant.com>
Date: 2020-07-15T13:47:25Z
Lists: pgsql-hackers
Attachments
- v4-0001-Replace-a-macro-by-a-function.patch (text/plain) patch v4-0001
- v4-0002-Pause-recovery-for-insufficient-parameter-setting.patch (text/plain) patch v4-0002
Here is a minimally updated new patch version to resolve a merge conflict. On 2020-06-24 10:00, Peter Eisentraut wrote: > Here is another stab at this subject. > > This is a much simplified variant: When encountering a parameter change > in the WAL that is higher than the standby's current setting, we log a > warning (instead of an error until now) and pause recovery. If you > resume (unpause) recovery, the instance shuts down as before. > > This allows you to keep your standbys running for a bit (depending on > lag requirements) and schedule the required restart more deliberately. > > I had previously suggested making this new behavior configurable, but > there didn't seem to be much interest in that, so I have not included > that there. > > The documentation changes are mostly carried over from previous patch > versions (but adjusted for the actual behavior of the patch). -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Commits
-
Pause recovery for insufficient parameter settings
- 15251c0a60be 14.0 landed
-
Replace a macro by a function
- b5acf10cfc63 14.0 landed
-
Improve handling of parameter differences in physical replication
- 246f136e76ec 13.0 landed
-
Prefer standby promotion over recovery pause.
- 496ee647ecd2 13.0 cited