Обсуждение: Registering all User Operations

Поиск
Список
Период
Сортировка

Registering all User Operations

От
SAMTEK Consultores
Дата:
Hi:

I need to register all the operations (INSERT/UPDATE/DELETE) that users
does.

Something like an log file for the backbone (like a /var/log/messages,
where all done is registered).


Can any help me?

Thanks.

--

SAMTEK, Consultores Informática y Telecomunicaciones
Calificado como Agente Tecnológico por la Consejería  de Empleo y Desarrollo Tecnológico
RAITEC (Red Andaluza de Innovación y Tecnología)

Adolfo M. Pachón Rodríguez
Director de Sistemas

C/ Salado, Portal 11, Local 8
41010 - Sevilla

tlf: 95 428 6045
fax: 95 427 8500

http://www.samtek.es
mailto://info@samtek.es


Re: Registering all User Operations

От
Bruce Momjian
Дата:
Uh, you can turn on log_statements in postgresql.conf and they will
appear in the server logs.

---------------------------------------------------------------------------

SAMTEK Consultores wrote:
> Hi:
>
> I need to register all the operations (INSERT/UPDATE/DELETE) that users
> does.
>
> Something like an log file for the backbone (like a /var/log/messages,
> where all done is registered).
>
>
> Can any help me?
>
> Thanks.
>
> --
>
> SAMTEK, Consultores Inform?tica y Telecomunicaciones
> Calificado como Agente Tecnol?gico por la Consejer?a  de Empleo y Desarrollo Tecnol?gico
> RAITEC (Red Andaluza de Innovaci?n y Tecnolog?a)
>
> Adolfo M. Pach?n Rodr?guez
> Director de Sistemas
>
> C/ Salado, Portal 11, Local 8
> 41010 - Sevilla
>
> tlf: 95 428 6045
> fax: 95 427 8500
>
> http://www.samtek.es
> mailto://info@samtek.es
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Re: Registering all User Operations

От
Mauri Sahlberg
Дата:
On su, 2003-01-26 at 03:03, Bruce Momjian wrote:
> Uh, you can turn on log_statements in postgresql.conf and they will
> appear in the server logs.
>
> ---------------------------------------------------------------------------
>

Logging options are explained in the Administrator's manual at chapter
3.4.3. Adding the following to postgresql.conf should do the trick:

log_statament=true
syslog=2

I would also recommend using logrotate as your log will grow quite big
quite fast. Or if you are a looking for an audit log, I recommend doing
it in the application rather than trying to do it with the database logs
as quite propably the database user id is different than the application
user id.


> SAMTEK Consultores wrote:
> > Hi:
> >
> > I need to register all the operations (INSERT/UPDATE/DELETE) that users
> > does.
> >
> > Something like an log file for the backbone (like a /var/log/messages,
> > where all done is registered).
> >
> >
> > Can any help me?
> >
> > Thanks.
> >
> > --
> >
> > SAMTEK, Consultores Inform?tica y Telecomunicaciones
> > Calificado como Agente Tecnol?gico por la Consejer?a  de Empleo y Desarrollo Tecnol?gico
> > RAITEC (Red Andaluza de Innovaci?n y Tecnolog?a)
> >
> > Adolfo M. Pach?n Rodr?guez
> > Director de Sistemas
> >
> > C/ Salado, Portal 11, Local 8
> > 41010 - Sevilla
> >
> > tlf: 95 428 6045
> > fax: 95 427 8500
> >
> > http://www.samtek.es
> > mailto://info@samtek.es
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/users-lounge/docs/faq.html
> >
--
GSM: 044 5229238           | This message is probably digitally signed.
www.claymountain.com/~mos/ | Contact me to obtain my public key.
                           | I'm Microsoft incompatible.

Вложения