Postgres Pro
Downloads
Home   >   mailing lists

Thread: date in european style

date in european style

From
Salvador Mainé
Date:
Hello:

I'm using postgresql v7.0.2, from RedHat 7.0 installation. How can I
configure it to use dates in european format? I used to put -o-e in the
execution of postmaster in /etc/rc.d/rc.init/postgresql, but now they
use a different program to start (pg_ctl):

su -l postgres -c "/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster
start >/dev/null 2>&1" < /dev/null

Thanks in advance

--
Salvador Mainé

Re: date in european style

From
"Oliver Elphick"
Date:
Salvador =?iso-8859-1?Q?Main=E9?= wrote:
  >Hello:
  >
  >I'm using postgresql v7.0.2, from RedHat 7.0 installation. How can I
  >configure it to use dates in european format? I used to put -o-e in the
  >execution of postmaster in /etc/rc.d/rc.init/postgresql, but now they
  >use a different program to start (pg_ctl):
  >
  >su -l postgres -c "/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster
  >start >/dev/null 2>&1" < /dev/null


pg_ctl has a -o option to send options to the postmaster, so you should
be able to do

  pg_ctl -o "-o -e"


--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47  6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "Lift up your heads, O ye gates; and be ye lift up, ye
      everlasting doors; and the King of glory shall come
      in. Who is this King of glory? The LORD strong and
      mighty, the LORD mighty in battle."
                                   Psalms 24:7,8

Re: date in european style

From
"Michel M. dos Santos"
Date:

    I'm using Conectiva Linux 6.0, Postgresql 7.0.2.

    In my scrypt, I start with default mode. But I think it is util
for you:

      daemon --check postmaster --user postgres "export
PGDATESTYLE='Postgres'; /usr/bin/postmaster -o -e -i -S -D/var/lib/pgsql"



On Mon, 5 Feb 2001, Salvador Mainé wrote:

-->Hello:
-->
-->I'm using postgresql v7.0.2, from RedHat 7.0 installation. How can I
-->configure it to use dates in european format? I used to put -o-e in the
-->execution of postmaster in /etc/rc.d/rc.init/postgresql, but now they
-->use a different program to start (pg_ctl):
-->
-->su -l postgres -c "/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster
-->start >/dev/null 2>&1" < /dev/null
-->
-->Thanks in advance
-->
-->--
-->Salvador Mainé
-->

    []'s

    Michel M. dos Santos

Re: date in european style

From
Terence Chan
Date:
Try:-

su -l postgres -c "/usr/bin/pg_ctl -o "-o-e" -D $PGDATA -p
/usr/bin/postmaster start >/dev/null 2>&1" < /dev/null


Salvador Mainé wrote:

> Hello:
>
> I'm using postgresql v7.0.2, from RedHat 7.0 installation. How can I
> configure it to use dates in european format? I used to put -o-e in the
> execution of postmaster in /etc/rc.d/rc.init/postgresql, but now they
> use a different program to start (pg_ctl):
>
> su -l postgres -c "/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster
> start >/dev/null 2>&1" < /dev/null
>
> Thanks in advance