pgsql: Rework internal command generation of pg_rewind - Mailing list pgsql-committers

From Michael Paquier
Subject pgsql: Rework internal command generation of pg_rewind
Date
Msg-id E1nOtZE-000NzJ-Fk@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Rework internal command generation of pg_rewind

pg_rewind generates and executes internally up to two commands to work
on the target cluster, depending on the options given by its caller:
- postgres -C to retrieve the value of restore_command, when using
-c/--restore-target-wal.
- postgres --single to enforce recovery once and get the target cluster
in a clean shutdown state.

Both commands have been applying incorrect quoting rules, which could
lead to failures when for example using a target data directory with
unexpected characters like CRLFs.  Those commands are now generated with
PQExpBuffer, making use of string_utils.h to quote those commands as
they should.  We may extend those commands in the future with more
options, so this makes any upcoming additions easier.

This is arguably a bug fix, but nobody has complained about the existing
code being a problem either, so no backpatch is done.

Extracted from a larger patch by the same author.

Author: Gunnar "Nick" Bluth
Discussion: https://postgr.es/m/7c59265d-ac50-b0aa-ca1e-65e8bd27642a@pro-open.de

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/a33e17f210547226ada52d2b8af851c3553bb4fa

Modified Files
--------------
src/bin/pg_rewind/pg_rewind.c | 43 +++++++++++++++++++++++++++++++++----------
1 file changed, 33 insertions(+), 10 deletions(-)


pgsql-committers by date:

Previous
From: Amit Kapila
Date:
Subject: pgsql: Reconsider pg_stat_subscription_workers view.
Next
From: Peter Eisentraut
Date:
Subject: pgsql: psql: Additional tests