Query returns no rows in pg_basebackup cluster
От | Andrus |
---|---|
Тема | Query returns no rows in pg_basebackup cluster |
Дата | |
Msg-id | 2B1267647FD14565B73801AF12CA1A88@dell2 обсуждение исходный текст |
Ответы |
Re: Query returns no rows in pg_basebackup cluster
|
Список | 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.
В списке pgsql-general по дате отправления: