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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.





[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux