Re: Re: Log files, how to rotate properly

Martin Marques <martin@bugs.unl.edu.ar>

From: Martín Marqués <martin@bugs.unl.edu.ar>
To: Vivek Khera <khera@kcilink.com>
Cc: pgsql-general@postgresql.org
Date: 2001-06-15T16:09:16Z
Lists: pgsql-general
On Vie 15 Jun 2001 21:08, you wrote:
> >>>>> "LO" == Lamar Owen <lamar.owen@wgcr.org> writes:
>
> LO> Then whose fault is that?  Is it our syslog calling, or the
> LO> receiving syslog not hearing?  (Yes, I know that by default syslog
> LO> uses UDP)....
>
> Not on FreeBSD (probably most other BSD's as well), the default is to
> use a named pipe.
>
> Anyhow what is the best way to make postgres stop stderr logging when
> syslog logging is turned on?  Right now I use "-l /dev/null" to pg_ctl
> when starting the server.  This seems to me that the server will still
> waste cycles doing the stderr printing.

Talking aout sql.log rotate, my rotates are quite strange, or give strange 
results. After a rotate I have an sql file that has a binary part at the 
begining, and after quite a few pages of ^@s the logs, properly, starts.

I'm using this script to rotate syslog, maillog, etc. but I'm having trble 
with sql.log.

Saludos.... ;-)

It's rotating, but the file that is left to have he output of postgres has a 
bunch of bianry data first, and then the log.

-- 
Cualquiera administra un NT.
Ese es el problema, que cualquiera administre.
-----------------------------------------------------------------
Martin Marques                  |        mmarques@unl.edu.ar
Programador, Administrador      |       Centro de Telematica
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------