Query returns no rows in pg_basebackup cluster

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Query returns no rows in pg_basebackup cluster
Date: 2020-05-21 20:20:15
Message-ID: 2B1267647FD14565B73801AF12CA1A88@dell2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

In windows pg_basebackup was used to create base backup from Linux server.
baas column data type is character(8)

In Linux server query

select * from firma1.desktop where baas='_LOGIFAI'

returns 16 rows.

Windows server this query returns 0 rows.

In Windows server same query using like

select * from firma1.desktop where baas like '_LOGIFAI'

returns properly 16 rows.

Maybe this is because database locale is not known in windows:

CREATE DATABASE sba
WITH
OWNER = sba_owner
ENCODING = 'UTF8'
LC_COLLATE = 'et_EE.UTF-8'
LC_CTYPE = 'et_EE.UTF-8'
TABLESPACE = pg_default
CONNECTION LIMIT = -1;

Correct encoding for windows should be

LC_COLLATE = 'Estonian_Estonia.1257'
LC_CTYPE = 'Estonian_Estonia.1257'

IF so how to to fix windows cluster so that query returns proper result in windows also?
Database in Windows is in read-only (recovery) mode so it cannot changed.
Postgres 12 is used.

Andrus.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Israel Brewster 2020-05-21 20:23:17 Re: Table partitioning for cloud service?
Previous Message Sándor Daku 2020-05-21 20:12:46 Re: Table partitioning for cloud service?