From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: setting up postgres replication FATAL: database system identifier differs between the primary and standby
Date: Sat, 12 Feb 2022 19:03:45 -0600
Message-ID: <dd83b495-616f-1e03-585d-e76930c6cdd5@gmail.com> (raw)
In-Reply-To: <CAB8KJ=ixY6H1TDuWKSvcCdE9uU-jT7E4-aWD7ZKXtVDKLRT3jg@mail.gmail.com>
References: <2247e5f0-1e40-be50-1ca7-726afacb6d87@enabled.com>
<CAB8KJ=ixY6H1TDuWKSvcCdE9uU-jT7E4-aWD7ZKXtVDKLRT3jg@mail.gmail.com>
On 2/12/22 6:35 PM, Ian Lawrence Barwick wrote:
[snip]
> You appear to be starting a database which is not a copy of the primary node it
binary copy
> is trying to connect to. It's impossible to tell from the provided information
> how that happened. Possibly you have more than one instance on the standby
> (replica) and are somehow starting the wrong one. If not you'll need to make
> a backup of the primary and make sure that's what is being started.
Binary copy using pg_basebackup (or something like pgbackrest).
--
Angular momentum makes the world go 'round.
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: ronljohnsonjr@gmail.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: <dd83b495-616f-1e03-585d-e76930c6cdd5@gmail.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