A question regarding streaming replication

From: Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com>
To: pgsql-performance(at)lists(dot)postgresql(dot)org, pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: A question regarding streaming replication
Date: 2019-07-31 09:28:44
Message-ID: CA+t6e1=Qj3U6+79C17Se5OPQ5DW1cgwfi71+f_eOgtSEv8UuXQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-performance

Hey all,
I have a questions regarding streaming replication that I would like to
ask in order to understand the feature better :
I have 2 nodes configured with replication (primary + secondary).
In my primary I configured streaming replcation + archiving. My archive
command :
gzip < %p > /var/lib/pgsql/archive/%f ; echo "archiving wal %f"

Correct me if I'm wrong but my archive_command will be run when the
archive_timeout is reached or when the wal is full (16MB). The wal file is
created with default size of 16MB and it will be archived only after 16MB
of wal records will be created.

In my secondary I have the following settings :
restore_command = 'rsync -avzhe ssh postgres(at)my_primary
:/var/lib/pgsql/archive/%f /var/lib/pgsql/archive/%f ; gunzip <
/var/lib/pgsql/archive/%f > %p; echo "restore command was launched"'
archive_cleanup_command = '/usr/pgsql-9.6/bin/pg_archivecleanup
/var/lib/pgsql/archive %r; "archive_cleanupup for %r was launched"'

Which means, that the restore command on the secondary connects to the
primary, copies the wal file from the archive dir , unzip it and saves it
in the pg_xlog dir of the database.

my question :
When exactly the restore_command will be used ? I use streaming replication
therefore wal records are passed through wal_sender and wal receiver. I
dont see in my logs in the secondary that the restore_command is used but I
see that the same wal files as in the primary are exists on the pg_xlog in
the secondary. Does the streaming replication generates wals on the
secondary from the wals records that it receives from the primary ?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Fabio Pardi 2019-07-31 09:41:55 Re: A question regarding streaming replication
Previous Message Mariel Cherkassky 2019-07-28 15:16:43 upgrading cluster with 2 nodes to new major version

Browse pgsql-performance by date

  From Date Subject
Next Message Fabio Pardi 2019-07-31 09:41:55 Re: A question regarding streaming replication
Previous Message Jean Baro 2019-07-30 01:23:36 Re: High concurrency same row (inventory)