setting up postgres replication FATAL: database system identifier differs between the primary and standby

From: Noah <noah-list(at)enabled(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: setting up postgres replication FATAL: database system identifier differs between the primary and standby
Date: 2022-02-12 23:37:12
Message-ID: 2247e5f0-1e40-be50-1ca7-726afacb6d87@enabled.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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-postgresql-12-on-ubuntu-20-04

At step 4 - I restarted the replica database with command "sudo
systemctl restart postgresql(at)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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ian Lawrence Barwick 2022-02-13 00:35:38 Re: setting up postgres replication FATAL: database system identifier differs between the primary and standby
Previous Message Scott Ribe 2022-02-11 17:21:50 Re: PG_Base Backup take 8 to 9Hrs