From: Noah <noah-list@enabled.com>
To: pgsql-admin@lists.postgresql.org
Subject: setting up postgres replication FATAL: database system identifier differs between the primary and standby
Date: Sat, 12 Feb 2022 15:37:12 -0800
Message-ID: <2247e5f0-1e40-be50-1ca7-726afacb6d87@enabled.com> (raw)
Ahoy there,
I am attempting to set up postgres12 with replication between two servers.
I followed these instructions.
https://www.digitalocean.com/community/tutorials/how-to-set-up-physical-streaming-replication-with-p...
At step 4 - I restarted the replica database with command "sudo
systemctl restart postgresql@12-main"
I see these messages in the /var/log/postgresql/postgresql-12-main.log file
--- snip ---
2022-02-12 17:39:51.345 UTC [237364] LOG: entering standby mode
2022-02-12 17:39:51.356 UTC [237365] FATAL: database system identifier
differs between the primary and standby
2022-02-12 17:39:51.356 UTC [237365] DETAIL: The primary's identifier
is 7048326921585830819, the standby's identifier is 7063458841707763655.
2022-02-12 17:39:51.367 UTC [237369] FATAL: database system identifier
differs between the primary and standby
2022-02-12 17:39:51.367 UTC [237369] DETAIL: The primary's identifier
is 7048326921585830819, the standby's identifier is 7063458841707763655.
2022-02-12 17:39:56.380 UTC [237371] FATAL: database system identifier
differs between the primary and standby
2022-02-12 17:39:56.380 UTC [237371] DETAIL: The primary's identifier
is 7048326921585830819, the standby's identifier is 7063458841707763655.
--- snip ---
Is there an easy way to solve this problem?
Cheers
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-admin@postgresql.org
Cc: noah-list@enabled.com, pgsql-admin@lists.postgresql.org
Subject: Re: setting up postgres replication FATAL: database system identifier differs between the primary and standby
In-Reply-To: <2247e5f0-1e40-be50-1ca7-726afacb6d87@enabled.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