Re: Postgresql streaming replication

From: Prasanth <dbadmin(at)pangburngroup(dot)com>
To: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Postgresql streaming replication
Date: 2024-05-28 15:30:00
Message-ID: 62a7e90e-b92a-ba91-0e79-af7ce4358d49@pangburngroup.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)pangburngroup(dot)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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Ribe 2024-05-28 15:37:19 Re: Postgresql streaming replication
Previous Message Sathish Reddy 2024-05-28 15:26:01 Pg_squeze