Re: pg_receivewal documentation - Mailing list pgsql-hackers

From Jesper Pedersen
Subject Re: pg_receivewal documentation
Date
Msg-id e62fcdf7-556c-d4e1-73cd-fc325f89374d@redhat.com
Whole thread Raw
In response to Re: pg_receivewal documentation  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: pg_receivewal documentation  (Michael Paquier <michael@paquier.xyz>)
List 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



pgsql-hackers by date:

Previous
From: Konstantin Knizhnik
Date:
Subject: Re: Built-in connection pooler
Next
From: Jesper Pedersen
Date:
Subject: Re: pg_receivewal documentation