Re: Postgresql streaming replication

[Prasanth <dbadmin@xxxxxxxxxxxxxxxxx>]

    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@xxxxxxxxxxxxxxxxx> 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.
>