Re: How to create database with default system locale is set to et_EE.UTF-8

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: Bèrto ëd Sèra <berto(dot)d(dot)sera(at)gmail(dot)com>, <adrian(dot)klaver(at)gmail(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to create database with default system locale is set to et_EE.UTF-8
Date: 2011-12-22 16:29:11
Message-ID: 586CFE8D4282438E8AFD5C9C4E377FC6@dell2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Adrian and Bèrto,

Thank you very much for quick and excellent replies. Locale names are
different in every Linux distro.
Postgresql does not provide any way to retrieve them (ssh access is reqired
to retireve them using locale -a)

Thus suggection using hard coded locale names is not possible.

How to force server to use et_EE.UTF-8 as default locale without hard coding
it into application?

How to force command

CREATE DATABASE <yourdbname> TEMPLATE = template0

to use et_EE.UTF-8 locale by default ?

Andrus.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jacques Lamothe 2011-12-22 16:32:33 Cannot connect to 2nd cluster database remotely
Previous Message Tom Lane 2011-12-22 15:29:16 Re: Trying to understand postgres crash