Re: Postgres logs w/ Logrotate

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: Renê Salomão <rene(at)ibiz(dot)com(dot)br>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Postgres logs w/ Logrotate
Date: 2003-04-02 14:23:57
Message-ID: 1049293437.1374.3.camel@linda.lfix.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Wed, 2003-04-02 at 15:05, Renê Salomão wrote:
> Oliver,
>
> Thank u very much... Copytruncate was exactly what my scripts was
> missing.. Just had to replace copytruncate with create...

I suspect your English is failing you here: you need to replace create
with copytruncate!

> I lacked the knowledge that postmaster does not close the
> file...
>
> By the way is there any environment variable to log path? I know that
> there is for data (PGDATA) and port (PGPORT)... What about log (PGLOG)?

Not that I know of.

> Would help a lot if such variable exists!!! The reason is that anyone
> here can start/stop/reload our testing database, most of the time
> people forget about setting log file...

I should set up a script for them to use, to ensure that it gets done
right every time.

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"If the Son therefore shall make you free, ye shall be
free indeed." John 8:36

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Doug Silver 2003-04-02 19:10:31 Timestamp with time zone change (error) in 7.3.2?
Previous Message Renê Salomão 2003-04-02 14:05:41 Re: Postgres logs w/ Logrotate