Re: pg_receivewal documentation
| От | Jesper Pedersen |
|---|---|
| Тема | Re: pg_receivewal documentation |
| Дата | |
| Msg-id | e62fcdf7-556c-d4e1-73cd-fc325f89374d@redhat.com обсуждение исходный текст |
| Ответ на | Re: pg_receivewal documentation (Laurenz Albe <laurenz.albe@cybertec.at>) |
| Ответы |
Re: pg_receivewal documentation
|
| Список | 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 по дате отправления: