Re: Streaming Replication, can't select row in backup without specifying collation

2022-07-25 Thread Adrian Klaver
On 7/25/22 15:36, Kelly Burkhart wrote: I have a primary and backup database running 12.10 and synced with streaming replication.  I have a simple table that is returning different results for the same query in the primary vs backup database. On the primary DB: > select tag::bytea, * from se

Streaming Replication, can't select row in backup without specifying collation

2022-07-25 Thread Kelly Burkhart
I have a primary and backup database running 12.10 and synced with streaming replication. I have a simple table that is returning different results for the same query in the primary vs backup database. On the primary DB: > select tag::bytea, * from sentinel where tag = 'quote_merge_locs_mnj_NSX_