From: | Jim Nasby <jim(at)nasby(dot)net> |
---|---|
To: | Fabi Avilés <fabiavmz(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Problems with date configuration |
Date: | 2006-09-22 03:28:46 |
Message-ID: | EC8667CA-96C2-4D63-8C20-6622C9E074AF@nasby.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sep 13, 2006, at 10:39 AM, Fabi Avilés wrote:
> Hi, I had an application in which I used postgres 7.4, and then
> only thing refering to date was:
>
> datestyle = 'ISO,European'
>
> everything else was commented. Now I have had to change the OS and
> I've installed postgres 8.1.3, but this configuration is different,
> it's something like:
>
> lc_monetary = 'en_US.UTF-8'
> lc_numeric = 'en_US.UTF-8'
> lc_time = 'en_US.UTF-8'
>
>
> and evrything else is commented, including the line which
> references the datestyle. But in the comment it says #datestyle =
> 'iso, mdy'. Someone can help me to make it works in the same way?
initdb will pick up a number of locale settings from the environment
when it's run. If you want to go back to the behavior you had, you
should be able to just change all the config options to what you want
and restart the database.
--
Jim Nasby jimn(at)enterprisedb(dot)com
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
From | Date | Subject | |
---|---|---|---|
Next Message | Jim Nasby | 2006-09-22 03:29:46 | Re: Garbage data sent by Windows 98 client |
Previous Message | Michael Nolan | 2006-09-22 03:06:31 | Re: Backup Large Tables |