| 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: | Whole Thread | Raw Message | 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? |