- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Postgres windows install and locale FrenchxxCOMMAxxxxSPxxSwitzerland
We're using setup by command line (Postgres setup is include in our application setup):
postgresql-10.4-32bits-windows.exe --unattendedmodeui minimalWithDialogs --mode unattended --create_shortcuts 0 --install_runtimes 1 --prefix "C:\Program Files (x86)\PostgreSQL\10" --datadir "c:\Data_Pg_10" --superpassword POSTGRESQL_PASSWORD --serverport POSTGRESQL_PORT --superaccount postgres --locale "FrenchxxCOMMAxxxxSPxxSwitzerland"
We set --locale value to FrenchxxCOMMAxxxxSPxxSwitzerland
But after install, when I send "Show lc_collate" command, my result is
French_France.1252
instead of French_Switzerland.1252.
If I take a look at locale in postgres install directory, I can see that locale FrenchxxCOMMAxxxxSPxxSwitzerland exist.
How can I do to specify on install (with command line) that lc_collate must be french_switzerland ?
Thanks for your help.
Archived Discussions
Effective March 31st, we will no longer engage on PostgresRocks.
How to engage with us further?
- Thought Leadership: EDB Blogs
- Tips and Tricks: Postgres Tutorials
- Customer Support: Create a Case Please note: Only customers with an active EDB support subscription and support portal authorization can create support ticket
- Engage on Stackoverflow While engaging on Stackoverflow tag the question with EDB or EnterpriseDB.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: Postgres windows install and locale FrenchxxCOMMAxxxxSPxxSwitzerland
Hi @Toine,
We have also tested the installation with graphical as well as unattended mode, it initializes the data directory with lc_collate as "French_France.1252".
We tried workaround by initializing the data directory using the initdb with locale "French_Switzerland.1252" and it is working fine.
Could you please try initializing the data directory after the installation of the postgres using initdb command like below:
"C:\Program Files (x86)\PostgreSQL\10\bin\initdb.exe" -D "c:\Data_Pg_10" -U postgres --locale French_Switzerland.1252
Once, the data directory is initialized start the database cluster and verify the lc_collate value.
Regards,
Sudhir