Re: pg_receivewal documentation
Jesper Pedersen <jesper.pedersen@redhat.com>
From: Jesper Pedersen <jesper.pedersen@redhat.com>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Michael Paquier <michael@paquier.xyz>,
Alvaro Herrera <alvherre@2ndquadrant.com>,
PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2019-07-18T12:39:48Z
Lists: pgsql-hackers
Hi Laurenz,
On 7/17/19 5:21 PM, Laurenz Albe wrote:
> That's factually wrong. "on" (wait for WAL flush) works fine with
> pg_receivewal, only "remote_apply" doesn't.
>
Please, try
mkdir /tmp/wal
initdb /tmp/pgsql
pg_ctl -D /tmp/pgsql -l /tmp/logfile start
psql postgres
SELECT pg_create_physical_replication_slot('replica1');
CREATE ROLE repluser WITH LOGIN REPLICATION PASSWORD 'replpass';
\q
synchronous_commit = on
synchronous_standby_names = 'replica1'
pg_ctl -D /tmp/pgsql -l /tmp/logfile restart
pg_receivewal -D /tmp/wal -S replica1 --synchronous -h localhost -p 5432
-U repluser -W
psql -c 'SELECT * FROM pg_stat_replication;' postgres
psql -c 'SELECT * FROM pg_replication_slots;' postgres
psql -c 'CREATE DATABASE test' postgres
In what scenarios do you see 'on' working ?
Best regards,
Jesper
Commits
-
Doc: Clarify interactions of pg_receivexlog with remote_apply
- 4a25ed16400c 9.6.15 landed
-
Doc: Clarify interactions of pg_receivewal with remote_apply
- 1c423463e4b9 10.10 landed
- 059e22693b23 11.5 landed
- a15a40aaaedf 12.0 landed
- fd7d387e0548 13.0 landed