On Tue, 2025-07-01 at 23:10 +0000, PG Bug reporting form wrote:
> PostgreSQL version: 17.5
> Operating system: LInux / Wiondows
> Description:
>
> We have next configuration - master server on Linux Ubuntu and physical
> replica on Windows 10 machine. Some kind of simple SELECT SQL request
> returns none called on replica - and work correctly on server itself or
> Linux physical replica. If we inspect data in windows replica tables - we
> see, that all data needed presented.
That's very likely because the collations differ on both machines, so
the indexes on the standby are corrupted. You cannot do streaming
replication between Windows and Linux. Consider using logical replication.
This is unpleasant, but not a bug.
Yours,
Laurenz Albe
