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 1nJ3Iw-00006Q-0m for pgsql-admin@arkaria.postgresql.org; Sun, 13 Feb 2022 01:03:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nJ3It-0000NB-Pm for pgsql-admin@arkaria.postgresql.org; Sun, 13 Feb 2022 01:03:51 +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 1nJ3It-0000N2-DE for pgsql-admin@lists.postgresql.org; Sun, 13 Feb 2022 01:03:51 +0000 Received: from mail-oi1-x233.google.com ([2607:f8b0:4864:20::233]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nJ3Iq-0005ed-4e for pgsql-admin@lists.postgresql.org; Sun, 13 Feb 2022 01:03:50 +0000 Received: by mail-oi1-x233.google.com with SMTP id x4so3508035oic.9 for ; Sat, 12 Feb 2022 17:03:48 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-transfer-encoding:content-language; bh=7BCJvfP0SGLWvPLGNO4I0NysECeHm99lwXvNI3+hEDE=; b=WvPN+YqODunlKxIUZ1tTiML/bvF2ysvxpy+zQe15t1K9/U4gsUTdfOLvCB6qgwwEkI s8Akkd3sXrz5ziVL72+x/qlb7yFbRadIocikkWjSqJPuwgsqXU9B0ZR5IrtHnIgKFef9 cJXsYosGN54QegOu5m4oH2ALXAl29bQfvAhtp2dlGkE0fOEDXp14I0/BQXTzL9O5zonk T8tw5MybAejinn7rAJ0cbhwPp2FlnR+GBTlD/STy+ITML2H5fWpAwIPqv1cv2XBR8uJm yGyUvafveYNNvGnyYueQTXPwJT0MmJAWig43mZ6OmWCL5FtkiR0YGIya9IZU8ODm8Xq8 7PVw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=7BCJvfP0SGLWvPLGNO4I0NysECeHm99lwXvNI3+hEDE=; b=7lCySBB3gI7T+6d18ZaHJV3x7sT9X3MH/xUHn8kVxcVI3D0NlihgnSznIlCFO1V6Vp 0UdCyyx2I5AJjuIzc1ooUS12iWktS5vOM6ipOitmyD1C0SonESvPUSYr7H7tWm/7jkPm eNWdst+Gn0BujfUGNApQmM8VjHa6niX+jycAmgAeGtbErhFo2i+JOT4iTUP2ZWHfchse nbUhQLu0OAONAbDlUModHHN4tQGpiRQNu4LyLmX//0gFgpcUi0cgCbXt1ZofMqvYpSz5 1SuVhroSVwOYhf3e0+w5tkzQEz+Vck58A51ZiNuc1DjNIa/CyePOOqSeDCnMDvJEk6dL v6Iw== X-Gm-Message-State: AOAM5315g5jY1I1YiVYBI8ncwGbzHWOpcVl3VWHM1t288hj2vmJVpATx HsOlXGly32MeK0i9UyKcfnsFmDt4iow= X-Google-Smtp-Source: ABdhPJxURU5s6N8+4lSU3z/e7RbRKslt7iszQsq8Mt+f2qCggwgHdsq0FRRbzILR/d3D4lKWUphtoQ== X-Received: by 2002:a05:6808:9a7:: with SMTP id e7mr3037701oig.247.1644714226760; Sat, 12 Feb 2022 17:03:46 -0800 (PST) Received: from [192.168.88.10] (ip68-11-68-85.no.no.cox.net. [68.11.68.85]) by smtp.googlemail.com with ESMTPSA id z4sm10512149otu.24.2022.02.12.17.03.46 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sat, 12 Feb 2022 17:03:46 -0800 (PST) Subject: Re: setting up postgres replication FATAL: database system identifier differs between the primary and standby To: pgsql-admin@lists.postgresql.org References: <2247e5f0-1e40-be50-1ca7-726afacb6d87@enabled.com> From: Ron Message-ID: Date: Sat, 12 Feb 2022 19:03:45 -0600 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.14.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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.