pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #18975: PostgreSQL server doesn't process SQL request correctly over Windows replica of Linux server
2+ messages / 2 participants
[nested] [flat]
* BUG #18975: PostgreSQL server doesn't process SQL request correctly over Windows replica of Linux server
@ 2025-07-01 23:10 PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 2+ messages in thread
From: PG Bug reporting form @ 2025-07-01 23:10 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: iqcook@gmail.com
The following bug has been logged on the website:
Bug reference: 18975
Logged by: Egor Chashchin
Email address: iqcook@gmail.com
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.
we captured example of this behavior on this video
https://www.dropbox.com/scl/fi/c8msver0gm78turk3wfsv/2025-07-02_00-14-31.mp4?rlkey=24rhvs9ytroznxyt8...
Linux - 17.5.1
Windows - 17.5.2
We have this problem with 16.8.x too.
It occurs not with all requests of such kind even on same table, but not
randomly - running same code fails in same place everytime.
Additional attempts were captured too
https://www.dropbox.com/scl/fi/g9h3r7v3gu59j5max9r7k/2025-07-02_00-59-02.mp4?rlkey=0yygbv62hloay32sg...
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #18975: PostgreSQL server doesn't process SQL request correctly over Windows replica of Linux server
@ 2025-07-02 13:49 Laurenz Albe <laurenz.albe@cybertec.at>
parent: PG Bug reporting form <noreply@postgresql.org>
0 siblings, 0 replies; 2+ messages in thread
From: Laurenz Albe @ 2025-07-02 13:49 UTC (permalink / raw)
To: iqcook@gmail.com; pgsql-bugs@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-07-02 13:49 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-07-01 23:10 BUG #18975: PostgreSQL server doesn't process SQL request correctly over Windows replica of Linux server PG Bug reporting form <noreply@postgresql.org>
2025-07-02 13:49 ` Laurenz Albe <laurenz.albe@cybertec.at>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox