pgsql: Disable synchronous commits in pg_rewind. - Mailing list pgsql-committers

From Heikki Linnakangas
Subject pgsql: Disable synchronous commits in pg_rewind.
Date
Msg-id E1bs61v-0003ia-No@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Disable synchronous commits in pg_rewind.

If you point pg_rewind to a server that is using synchronous replication,
with "pg_rewind --source-server=...", and the replication is not working
for some reason, pg_rewind will get stuck because it creates a temporary
table, which needs to be replicated. You could call broken replication a
pilot error, but pg_rewind is often used in special circumstances, when
there are changes to the replication setup.

We don't do any "real" updates, and we don't care about fsyncing or
replicating the operations on the temporary tables, so fix that by
setting synchronous_commit off.

Michael Banck, Michael Paquier. Backpatch to 9.5, where pg_rewind was
introduced.

Discussion: <20161005143938.GA12247@nighthawk.caipicrew.dd-dns.de>

Branch
------
REL9_5_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/69da71254b4293b6f817486eaed2df17f8725743

Modified Files
--------------
src/bin/pg_rewind/libpq_fetch.c | 14 ++++++++++++++
1 file changed, 14 insertions(+)


pgsql-committers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: pgsql: Disable synchronous commits in pg_rewind.
Next
From: Heikki Linnakangas
Date:
Subject: pgsql: Don't share SSL_CTX between libpq connections.