Question about postgres replication construction

From: MARIANE K <mskiesewetter(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Question about postgres replication construction
Date: 2021-10-29 08:37:16
Message-ID: CANBd27Lmq-h=XBCxpBp3YFz8Bf8TrHJOUbg+=GEOB9_9qZmjhw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi everyone,

I need some advice.

I need to set up a 3 node postgres 12 cluster.

The primary postgres server with a streaming replication hot standby which
is managed with repmgr.

Besides these 2 servers I need to create another standby server which will
be synced with wal files that are copied to the server.

This third node does not have any connection with the other two nodes and
will only be updated through the wal files.

The third node will be created by taking a base backup of the primary node
and restoring it to the PGDATA directory.

repmgr is not configured for node 3 because it has no connection with the
other two nodes.

The primary connection parameter is uncommented in the postgresql.conf.

This construction works until I perform a switchover from node 1 to node 2
with repmgr, making node 2 the new primary and node 1 the new standby.

The standby on node 3 does not pick up the switch.

My question is: Does anyone have an idea in how to approach this? Is this a
valid construction?

I know I'm missing something essential but at this moment I can't seem to
see it.

Thanks in advance.

Regards

Marian

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Vijaykumar Jain 2021-10-29 10:06:05 Re: Question about postgres replication construction
Previous Message Vijaykumar Jain 2021-10-28 09:50:40 Re: Activate a standby database and then revert to standby