pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Jesper Pedersen <jesper.pedersen@redhat.com>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Michael Paquier <michael@paquier.xyz>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: pg_receivewal documentation
Date: Thu, 18 Jul 2019 08:39:48 -0400
Message-ID: <e62fcdf7-556c-d4e1-73cd-fc325f89374d@redhat.com> (raw)
In-Reply-To: <184780f1f90a31c4c8b53f0e6328bf5aaae4f786.camel@cybertec.at>
References: <20190710142421.GA28387@alvherre.pgsql>
	<54779de5-f922-c0cf-629d-b582eded7265@redhat.com>
	<20190716050555.GA1439@paquier.xyz>
	<ebed4b9043b222d486ea3f0e44e7dcd242a80781.camel@cybertec.at>
	<65c3ecdf-8995-34cb-83c4-50068877e632@redhat.com>
	<20190717013835.GA2130@paquier.xyz>
	<44e51f9f60abb872854879c91da0ed3b67a6ba95.camel@cybertec.at>
	<20190717080424.GB20614@paquier.xyz>
	<7eaf748c-3f40-c994-0eb3-7d87709588d0@redhat.com>
	<184780f1f90a31c4c8b53f0e6328bf5aaae4f786.camel@cybertec.at>

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





view thread (37+ messages)  latest in thread

Message-ID: <e62fcdf7-556c-d4e1-73cd-fc325f89374d@redhat.com>
Permalink:  ../e62fcdf7-556c-d4e1-73cd-fc325f89374d@redhat.com/
Also on:    postgresql.org/message-id/e62fcdf7-556c-d4e1-73cd-fc325f89374d@redhat.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: jesper.pedersen@redhat.com, laurenz.albe@cybertec.at, michael@paquier.xyz, alvherre@2ndquadrant.com
  Subject: Re: pg_receivewal documentation
  In-Reply-To: <e62fcdf7-556c-d4e1-73cd-fc325f89374d@redhat.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox