Re: Two pg_rewind patches (auto generate recovery conf and ensure clean shutdown)

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Paul Guo <pguo(at)pivotal(dot)io>
Cc: Michael Paquier <michael(at)paquier(dot)xyz>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Jimmy Yih <jyih(at)pivotal(dot)io>, Ashwin Agrawal <aagrawal(at)pivotal(dot)io>, Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru>
Subject: Re: Two pg_rewind patches (auto generate recovery conf and ensure clean shutdown)
Date: 2019-09-25 17:48:12
Message-ID: 20190925174812.GA4916@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

CC Alexey for reasons that become clear below.

On 2019-Sep-25, Paul Guo wrote:

> > Question about 0003. If we specify --skip-clean-shutdown and the cluter
> > was not cleanly shut down, shouldn't we error out instead of trying to
> > press on?
> pg_rewind would error out in this case, see sanityChecks().
> Users are expected to clean up themselves if they use this argument.

Ah, good. We should have a comment about that below the relevant
stanza, I suggest. (Or maybe in the same comment that ends in line

I pushed 0001 with a few tweaks. Nothing really substantial, just my
OCD that doesn't leave me alone ... but this means your subsequent
patches need to be adjusted. One thing is that that patch touched
pg_rewind for no reason (those changes should have been in 0002) --
dropped those.

Another thing in 0002 is that you're adding a "-R" switch to pg_rewind,
but we have another patch in the commitfest using the same switch for a
different purpose. Maybe you guys need to get to an agreement over who
uses the letter :-) Also, it would be super helpful if you review
Alexey's patch:

This line is far too long:

+ printf(_(" -s, --skip-clean-shutdown skip running single-mode postgres if needed to make sure target is clean shutdown\n"));

Can we make the description more concise?

Álvaro Herrera
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Žiga Kranjec 2019-09-25 17:55:25 Re: DROP SUBSCRIPTION with no slot
Previous Message Jonathan S. Katz 2019-09-25 17:28:36 Re: PostgreSQL 12 RC1 Press Release Draft