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.
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? |