Content-Type: multipart/alternative;
 boundary="------------KXPDOpouj003MSNMtc3ZX302"
Message-ID: <62a7e90e-b92a-ba91-0e79-af7ce4358d49@pangburngroup.com>
Date: Tue, 28 May 2024 10:30:00 -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 <scott_ribe@elevated-dev.com>
Cc: pgsql-admin@postgresql.org
References: <06ab2de0-86d6-426e-4a18-17e0b25553ef@pangburngroup.com>
 <566DFBB0-A057-4069-A1F0-1AEFB38281F5@elevated-dev.com>
 <b289a9c5-8e0c-09af-8aa9-7b8394e4dba5@pangburngroup.com>
 <0B15DA7E-E26C-4B2A-B389-2011C8216007@elevated-dev.com>
From: Prasanth <dbadmin@pangburngroup.com>
In-Reply-To: <0B15DA7E-E26C-4B2A-B389-2011C8216007@elevated-dev.com>
Archived-At: 
 <https://www.postgresql.org/message-id/62a7e90e-b92a-ba91-0e79-af7ce4358d49%40pangburngroup.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------KXPDOpouj003MSNMtc3ZX302
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

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.

Thanks,
Prasanth

On 5/28/24 10:23 AM, Scott Ribe wrote:
>> On May 28, 2024, at 9:00 AM, Prasanth<dbadmin@pangburngroup.com>  wrote:
>>
>> I ran few queries and the recent data seems to be there. Would this cause differences in sorting or are there bigger issues with this difference in glibc libraries?
> A "difference" in sorting will literally mean some queries not finding the matching data--because indexes were created under one set of sorting rules, then traversed under a different set of sorting rules.

--------------KXPDOpouj003MSNMtc3ZX302
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <font face="Verdana">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. <br>
      <br>
      Thanks,<br>
      Prasanth<br>
    </font><br>
    <div class="moz-cite-prefix">On 5/28/24 10:23 AM, Scott Ribe wrote:<br>
    </div>
    <blockquote type="cite"
      cite="mid:0B15DA7E-E26C-4B2A-B389-2011C8216007@elevated-dev.com">
      <blockquote type="cite">
        <pre class="moz-quote-pre" wrap="">On May 28, 2024, at 9:00 AM, Prasanth <a class="moz-txt-link-rfc2396E" href="mailto:dbadmin@pangburngroup.com">&lt;dbadmin@pangburngroup.com&gt;</a> wrote:

I ran few queries and the recent data seems to be there. Would this cause differences in sorting or are there bigger issues with this difference in glibc libraries?
</pre>
      </blockquote>
      <pre class="moz-quote-pre" wrap="">
A "difference" in sorting will literally mean some queries not finding the matching data--because indexes were created under one set of sorting rules, then traversed under a different set of sorting rules.
</pre>
    </blockquote>
    <br>
  </body>
</html>

--------------KXPDOpouj003MSNMtc3ZX302--