Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sBz2L-002RCY-KX for pgsql-admin@arkaria.postgresql.org; Tue, 28 May 2024 15:46:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sBz2L-00AT9s-Mg for pgsql-admin@arkaria.postgresql.org; Tue, 28 May 2024 15:46:53 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sBz2L-00AT9k-B3 for pgsql-admin@lists.postgresql.org; Tue, 28 May 2024 15:46:53 +0000 Received: from mail.nqadmin.com ([12.230.133.169]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sBz2I-002O3s-Nn for pgsql-admin@postgresql.org; Tue, 28 May 2024 15:46:52 +0000 Received: from mail.nqadmin.com (localhost [127.0.0.1]) by mail.nqadmin.com (8.14.7/8.14.7) with ESMTP id 44SFkmqG011410 (version=TLSv1/SSLv3 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NO); Tue, 28 May 2024 10:46:48 -0500 Received: (from root@localhost) by mail.nqadmin.com (8.14.7/8.14.7/Submit) id 44SFkm3N011409; Tue, 28 May 2024 10:46:48 -0500 Received: from [192.168.0.234] (ppasala.nqadmin.com [192.168.0.234]) (TLSv1/SSLv3 AES128-GCM-SHA256 128/128) by mail.nqadmin.com with SMTP id watyqfz8i8ecnbczmh5vpvje8n; Tue, 28 May 2024 10:46:48 -0500 (CDT) (envelope-from dbadmin@pangburngroup.com) Content-Type: multipart/alternative; boundary="------------1OQVrQvCK6hUvx0EaxXOf8YA" Message-ID: <707fbe72-39c9-5179-fbcd-78b9cd4c5e94@pangburngroup.com> Date: Tue, 28 May 2024 10:46:48 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.15.1 Reply-To: dbadmin@pangburngroup.com Subject: Re: Postgresql streaming replication Content-Language: en-US To: Scott Ribe Cc: pgsql-admin@postgresql.org References: <06ab2de0-86d6-426e-4a18-17e0b25553ef@pangburngroup.com> <566DFBB0-A057-4069-A1F0-1AEFB38281F5@elevated-dev.com> <0B15DA7E-E26C-4B2A-B389-2011C8216007@elevated-dev.com> <62a7e90e-b92a-ba91-0e79-af7ce4358d49@pangburngroup.com> From: Prasanth X-Secure-Client-Email: No In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------1OQVrQvCK6hUvx0EaxXOf8YA Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Thank you. On 5/28/24 10:37 AM, Scott Ribe wrote: >> On May 28, 2024, at 9:30 AM, Prasanth wrote: >> >> Does this mean that a postgresql installed on Debian vs one installed on Alma will give different results even if the data is the same? Assuming they are independent databases but with same data. > yes:https://www.joeconway.com/presentations/glibc_issues-PGCon-2023.pdf --------------1OQVrQvCK6hUvx0EaxXOf8YA Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit Thank you.

On 5/28/24 10:37 AM, Scott Ribe wrote:
On May 28, 2024, at 9:30 AM, Prasanth <dbadmin@pangburngroup.com> wrote:

Does this mean that a postgresql installed on Debian vs one installed on Alma will give different results even if the data is the same? Assuming they are independent databases but with same data.

yes: https://www.joeconway.com/presentations/glibc_issues-PGCon-2023.pdf

--------------1OQVrQvCK6hUvx0EaxXOf8YA--