Re: logs de postgres en debian

From: "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com>
To: oscar arocha <arocha(dot)oscar(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: logs de postgres en debian
Date: 2009-12-08 14:19:29
Message-ID: 4B1E6071.2020608@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

oscar arocha a écrit :
> Good morning, i write you because, i need know where is log's postgres
> into debian lenny, i've read
> /var/log/postgresql/postgresql-8.1-main.log, but only could see
>
> 009-12-06 07:36:02 VET LOG: autovacuum: procesando la base de datos
> «postgres»
> 2009-12-06 07:37:02 VET LOG: autovacuum: procesando la base de datos «SIMA»
>
> i'll like see where are, insert, update and drops

Debian defaults to warning log level, if you wanna see anything else,
lower the level into /etc/postgresql/8.1/main/postgresql.conf

--
"Once they go up, who cares where they come down? That's not my department."
-- Werner von Braun

In response to

Browse pgsql-general by date

  From Date Subject
Next Message mrciken 2009-12-08 14:50:40 Postgresql: daily manual tranfer
Previous Message oscar arocha 2009-12-08 14:11:46 logs de postgres en debian