From: | Peter Adlersburg <peter(dot)adlersburg(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | message log merge (streaming replication) |
Date: | 2022-06-08 07:59:06 |
Message-ID: | CAD1Uk1rrDN+Wr9u4Xy6u0PbLdjSCqK4xupiOUQsFveuBD9fdQA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
Dear fellow DBA's,
While troubleshooting one of our production replication clusters (phys.
streaming replication using the patroni framework)
I stumbled over a - at least for me - strange phenomenon in the postgres
logs of the two cluster members:
*** node-01 ***
[postgres(at)db-node-01 main]$ grep 'LOG: database' postgresql-2022-06-05.log
time=2022-06-05 18:25:26 CEST, pid=1720 LOG: database system is shut down
time=2022-06-05 18:25:29 CEST, pid=3252374 LOG: database system was shut
down at 2022-06-05 18:25:23 CEST
time=2022-06-05 18:25:31 CEST, pid=3252371 LOG: database system is ready
to accept read only connections
time=2022-06-05 18:29:11 CEST, pid=3252371 LOG: database system is ready
to accept connections
time=2022-06-05 18:32:01 CEST, pid=1816 LOG: database system was
interrupted while in recovery at log time 2022-06-05 18:29:11 CEST
time=2022-06-05 18:32:03 CEST, pid=1813 LOG: database system is ready to
accept read only connections
time=2022-06-05 19:00:26 CEST, pid=1813 LOG: database system is ready to
accept connections
*** node-02 ***
[postgres(at)db-node-02 main]$ grep 'LOG: database' postgresql-2022-06-05.log
time=2022-06-05 18:25:26 CEST, pid=1720 LOG: database system is shut down
time=2022-06-05 18:25:29 CEST, pid=3252374 LOG: database system was shut
down at 2022-06-05 18:25:23 CEST
time=2022-06-05 18:25:31 CEST, pid=3252371 LOG: database system is ready
to accept read only connections
time=2022-06-05 18:29:11 CEST, pid=3252371 LOG: database system is ready
to accept connections
time=2022-06-05 18:32:01 CEST, pid=1816 LOG: database system was
interrupted while in recovery at log time 2022-06-05 18:29:11 CEST
time=2022-06-05 18:32:03 CEST, pid=1813 LOG: database system is ready to
accept read only connections
time=2022-06-05 19:00:26 CEST, pid=1813 LOG: database system is ready to
accept connections
The output is by no means complete - I only kept the duplicate entries.
My question:
How is it possible that the error logs are 'merged' across the two database
nodes? Is this the intended behaviour or am I missing something?
Thank you in advance for shedding light on this.
KR p.
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Janes | 2022-06-08 23:49:52 | Re: Streaming replication breakdown |
Previous Message | Ninad Shah | 2022-06-06 17:17:44 | Re: Streaming replication breakdown |
From | Date | Subject | |
---|---|---|---|
Next Message | Fabien COELHO | 2022-06-08 10:16:22 | Re: psql 15beta1 does not print notices on the console until transaction completes |
Previous Message | Kyotaro Horiguchi | 2022-06-08 01:12:59 | Re: SQL state: 42601. Execption handling. |