Questions tagged [locales]
The locales tag has no summary.
17 questions
1
vote
1
answer
135
views
How to avoid an "invalid locale" error when restoring a dump from Windows to Debian Linux?
Postgres 17 cluster is in Windows server in Estonian locale. Databases are defined like
CREATE DATABASE mydb
WITH
OWNER = mydb_owner
ENCODING = 'UTF8'
LC_COLLATE = 'et-EE'
LC_CTYPE ...
- 143
4
votes
1
answer
126
views
What specifically do locale settings do, and is there a way for me to test the effects of different locales?
I might need to change the locales settings of lc_messages, lc_monetary, lc_numeric, lc_time in my postgresql config. However, I need to know what specifically they affect before I do that. The ...
1
vote
0
answers
123
views
Unable to change Locale settings on Postgres@16 on Mac
I've installed PostgreSQL 16 via homebrew, which result installed at /opt/homebrew/var/postgresql@16.
The default database was initialised via homebrew, so I had no chance to setup the locale which - ...
- 255
1
vote
2
answers
578
views
Why is the default collation not applied in PostgreSQL queries?
OS: Windows 10
Docker OS: Alpine Linux 3.18.3
DB: PostgreSQL 15
I created a new PostgreSQL database named test1 with zh-x-icu as the default collation using the following command:
postgres=> ...
- 111
1
vote
1
answer
266
views
pg_trgm not working on non-Latin and macOS
Trigrams don't work for non-Latin languages on the Mac.
On the Mac, I'm getting the following behavior:
select show_trgm('peace') -> {" p"," pe",ace,"ce ",eac,pea}
...
- 111
5
votes
2
answers
8k
views
How can I get a list of locales in PostgreSQL?
I want to change number and currency format using something like:
SET lc_numeric='en_AU.UTF-8'
SET lc_money='en_AU.UTF-8'
I tried a number of formats for, say, Dutch, but nothing works. It appears ...
- 3,207
0
votes
1
answer
669
views
'lc_time_names' can't be set to the value of 'de_DE'
Works:
SET lc_time_names='en_US';
Fails with "Variable 'lc_time_names' can't be set to the value of 'de_DE'":
SET lc_time_names='de_DE';
This seemed simple to me. I guess, I have to ...
- 105
2
votes
1
answer
533
views
postgres: do I really need to use Collate and Ctype when restoring database?
Need to import in Linux a Windows postgres exported database.
In windows it's listed as follows:
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----...
- 123
2
votes
0
answers
270
views
Problem with decimal point setting in Windows
I am using bcp.exe from a SQL Server 2017 installation on Windows 10 (build 19041). The OS language is English (US) but I use scandinavian settings for date, time, currency and decimal delimiter - the ...
4
votes
2
answers
999
views
Specific changes to glibc 2.28 that affect PostgreSQL
I am preparing for upgrading a PostgreSQL server to Debian 10 (Buster) with the warning from Debian release notes about changes to gclibc affecting PostgreSQL in mind. The PostgreSQL wiki provides two ...
- 388
1
vote
0
answers
430
views
Difference between LC_COLLATE='C' and LC_COLLATE='C.UTF-8' in PostgreSQL [duplicate]
I need guidance on the exact distinction, if any, between LC_COLLATE='C' and LC_COLLATE='C.UTF-8' in PostgreSQL. It seems to me that they behave exactly the same and that the codeset (with bearing on ...
- 388
0
votes
1
answer
628
views
Default value format of a stored procedure parameter(of datatype : money)
With my query:
SELECT (CAST(0.00 AS MONEY))
I am expecting a result : 0.00
But it shows me the result: 0,00(with comma)
I checked this query ,when i found that,the CREATE PROCEDURE script ...
- 11
1
vote
1
answer
3k
views
Change locale of Postgres server
I have a big Postgres server with 2 Tb of data that has been created with the wrong locale.
How can I correct it, without recreating the whole server with pg_dump and pg_restore. It would take a ...
- 275
0
votes
2
answers
694
views
How to know the locale that has been used to initialize a Postgres server?
I need it in order to create a new database with initdb with the same locale, otherwise pg_upgrade will fail.
- 275
3
votes
5
answers
8k
views
Locale is incompatible error in Postgresql 10 when replicating from Ubunu to Win 10
The locale available in my Ubuntu PG-10 DB is en_US.UTF-8. When doing PG_Basebackup to a PG-10 DB in Win-10, Psql failed to connect with error
psql: FATAL: database locale is incompatible with ...
- 31