Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nJ1xA-0001xu-69 for pgsql-admin@arkaria.postgresql.org; Sat, 12 Feb 2022 23:37:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nJ1x8-0005rM-19 for pgsql-admin@arkaria.postgresql.org; Sat, 12 Feb 2022 23:37:18 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nJ1x7-0005rD-Mj for pgsql-admin@lists.postgresql.org; Sat, 12 Feb 2022 23:37:17 +0000 Received: from www-virt.enabled.com ([45.56.68.196]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nJ1x4-0004vp-Mx for pgsql-admin@lists.postgresql.org; Sat, 12 Feb 2022 23:37:16 +0000 Received: from localhost (localhost [127.0.0.1]) by www-virt.enabled.com (Postfix) with ESMTP id 783C22E8F2 for ; Sat, 12 Feb 2022 23:37:13 +0000 (UTC) Received: from www-virt.enabled.com ([127.0.0.1]) by localhost (localhost [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id vUpFQZDsieH3 for ; Sat, 12 Feb 2022 23:37:13 +0000 (UTC) Received: from [192.168.1.101] (157-131-171-72.fiber.dynamic.sonic.net [157.131.171.72]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by www-virt.enabled.com (Postfix) with ESMTPSA id 544482E6C3 for ; Sat, 12 Feb 2022 23:37:13 +0000 (UTC) Message-ID: <2247e5f0-1e40-be50-1ca7-726afacb6d87@enabled.com> Date: Sat, 12 Feb 2022 15:37:12 -0800 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:91.0) Gecko/20100101 Thunderbird/91.6.0 From: Noah Subject: setting up postgres replication FATAL: database system identifier differs between the primary and standby To: pgsql-admin@lists.postgresql.org Content-Language: en-US Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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@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