Thread: rotate sql.log

rotate sql.log

From
Martín Marqués
Date:
I have a log rotator (script in ksh) and want to rotate postgres log file.
How does Postgres log? Through syslog? Or independently?

Saludos... :-)

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

Re: rotate sql.log

From
Laurent Duperval
Date:
On 17 May, Martín Marqués wrote:
> I have a log rotator (script in ksh) and want to rotate postgres log file.
> How does Postgres log? Through syslog? Or independently?
>
> Saludos... :-)
>

Depends on how you built it and how it's configured at run time. If it was
built with syslog facilities *and* you started it with the syslog option,
it'll log to syslog. If in your invocation of pg_ctl you said to log into a
file, it'll logg into that file. Otherwise, it logs to stdout (stderr?).

L

--
Laurent Duperval <mailto:lduperval@microcelli5.com>

Bref. L'affreuse déception pour mes auditeurs. Les malheureux. Sevrés du
suc de ma pensée. Soyons brave.
                                             -Achille Talon