Thread: set permanent date style

set permanent date style

From
"Martin Teoh"
Date:
hi,

I just install postgres 7.2.1 and start the server using the start up script
provided in contrib/start-scripts/linux.  Now I want my date style to
automatically change to European every time the postgres server is started.
How can I do it?

Thanks,
Martin

_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com


Re: set permanent date style

From
Ragnar Kjørstad
Date:
On Sat, Jun 15, 2002 at 03:42:00AM +0000, Martin Teoh wrote:
> I just install postgres 7.2.1 and start the server using the start up script
> provided in contrib/start-scripts/linux.  Now I want my date style to
> automatically change to European every time the postgres server is started.
> How can I do it?

add -o \"-o -e\" to the arguments of pg_ctl in the inits-cript.
(at least with the RH init-script).

Alternatively you can set an enviroment-variable before starting the
deamon.


--
Ragnar Kjørstad
Big Storage

Re: set permanent date style

From
"Nick Fankhauser"
Date:
Martin-

in postmaster.conf, add a line that looks something like this:

PGDATESTYLE=ISO,European

(or SQL,European or POSTGRES,European or GERMAN,European)

Regards,

-Nick

--------------------------------------------------------------------------
Nick Fankhauser  nickf@ontko.com  Phone 1.765.935.4283  Fax 1.765.962.9788
Ray Ontko & Co.     Software Consulting Services     http://www.ontko.com/

> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Martin Teoh
> Sent: Friday, June 14, 2002 10:42 PM
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] set permanent date style
>
>
> hi,
>
> I just install postgres 7.2.1 and start the server using the
> start up script
> provided in contrib/start-scripts/linux.  Now I want my date style to
> automatically change to European every time the postgres server
> is started.
> How can I do it?
>
> Thanks,
> Martin
>
> _________________________________________________________________
> Chat with friends online, try MSN Messenger: http://messenger.msn.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>

Re: set permanent date style

From
Tom Lane
Date:
"Nick Fankhauser" <nickf@ontko.com> writes:
> in postmaster.conf, add a line that looks something like this:
> PGDATESTYLE=ISO,European

I do not believe that will work in any released version.  It will work
to set PGDATESTYLE as an environment variable in the postmaster's
environment, however.

As of 7.3 it will be possible to set DateStyle in postgresql.conf,
but up through 7.2 DateStyle is specially handled and isn't in the
set of variables that postgresql.conf knows about :-(

For the particular problem at hand, adding -e to the postmaster's
command line switches might have been enough ...

            regards, tom lane

Re: set permanent date style

From
"Nick Fankhauser"
Date:
Hmmm... I'm confused. It works for us. When I make this change in
postmaster.conf for our v7.2 install, it has the desired effect. Perhaps
this file is specific to the Debian package. Is postmaster.conf generally
used in all distributions?

Here is the documentation I found in that file:

# How (by default) to present dates to the frontend; the user can override
# this setting for his own session. The choices are:
#   Style      Date            Datetime
#   ----------------------------------------------------------------
#   ISO        1999-07-17      1999-07-17 07:09:18+01
#   SQL        17/07/1999      17/07/1999 07:09:19.00 BST
#   POSTGRES   17-07-1999      Sat 17 Jul 07:09:19 1999 BST
#   GERMAN     17.07.1999      17.07.1999 07:09:19.00 BST
#
# It is also possible to specify month-day or day-month ordering in date
# input and output.  Americans tend to use month-day; Europeans use
# day-month.  Specify European or nonEuropean. Separate the two parameters
# by a comma with no spaces
PGDATESTYLE=SQL,nonEuropean


-Nick

> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: Tuesday, June 18, 2002 8:39 AM
> To: nickf@ontko.com
> Cc: Martin Teoh; pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] set permanent date style
>
>
> "Nick Fankhauser" <nickf@ontko.com> writes:
> > in postmaster.conf, add a line that looks something like this:
> > PGDATESTYLE=ISO,European
>
> I do not believe that will work in any released version.  It will work
> to set PGDATESTYLE as an environment variable in the postmaster's
> environment, however.
>
> As of 7.3 it will be possible to set DateStyle in postgresql.conf,
> but up through 7.2 DateStyle is specially handled and isn't in the
> set of variables that postgresql.conf knows about :-(
>
> For the particular problem at hand, adding -e to the postmaster's
> command line switches might have been enough ...
>
>             regards, tom lane
>


Re: set permanent date style

From
Tom Lane
Date:
"Nick Fankhauser" <nickf@ontko.com> writes:
> Hmmm... I'm confused. It works for us. When I make this change in
> postmaster.conf for our v7.2 install, it has the desired effect.

I'm sorry, I thought that was a thinko for postgresql.conf.  Evidently
not --- it must be a file that sets up environment variables for the
postmaster.

> Perhaps this file is specific to the Debian package.

It's certainly not part of the standard source distribution, but it
might be in the standard RPM package.

            regards, tom lane

Re: set permanent date style

From
Oliver Elphick
Date:
On Tue, 2002-06-18 at 15:26, Tom Lane wrote:
> "Nick Fankhauser" <nickf@ontko.com> writes:
> > Hmmm... I'm confused. It works for us. When I make this change in
> > postmaster.conf for our v7.2 install, it has the desired effect.
>
> I'm sorry, I thought that was a thinko for postgresql.conf.  Evidently
> not --- it must be a file that sets up environment variables for the
> postmaster.

That is correct; it sets PGDATESTYLE, PGDATA (indirectly), the logfile,
and offers the chance to send any special options to pg_ctl.

> > Perhaps this file is specific to the Debian package.

Probably.
--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C

     "Jesus said unto her, I am the resurrection, and the
      life; he that believeth in me, though he were dead,
      yet shall he live."                 John 11:25

Attachment