Re: Postgresql streaming replication - Mailing list pgsql-admin

From Prasanth
Subject Re: Postgresql streaming replication
Date
Msg-id 62a7e90e-b92a-ba91-0e79-af7ce4358d49@pangburngroup.com
Whole thread Raw
In response to Re: Postgresql streaming replication  (Scott Ribe <scott_ribe@elevated-dev.com>)
Responses Re: Postgresql streaming replication
List 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@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.

pgsql-admin by date:

Previous
From: Sathish Reddy
Date:
Subject: Pg_squeze
Next
From: Scott Ribe
Date:
Subject: Re: Postgresql streaming replication