Re: Default settings

Actually, I think this is an environment variable, so you'd want to set it
up so the postgres user gets it before starting the postmaster.
(PGDATESTYLE=)

If you are running the Debian Linux package, it can be set in
postmaster.conf, but AFAIK, that file doesn't exist in other distributions
or the source.

Details here:
http://www.postgresql.org/idocs/index.php?libpq-envars.html

-Nick

--------------------------------------------------------------------------
Nick Fankhauser nickf(at)ontko(dot)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(at)postgresql(dot)org
> [mailto:pgsql-admin-owner(at)postgresql(dot)org]On Behalf Of Stephan Szabo
> Sent: Monday, August 05, 2002 9:24 AM
> To: Martins Zarins
> Cc: pgsql-admin(at)postgresql(dot)org
> Subject: Re: [ADMIN] Default settings
>
>
>
> On Mon, 5 Aug 2002, Martins Zarins wrote:
>
> > Hello all!
> >
> > HOWTO save (is this posible at all?) subj?
> > everytime I run psql I must write "set datestyle to german;"
> > Where I can set this variable for all databases on my server forever?
>
> I believe datestyle has an entry in postgresql.conf.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>