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:[EMAIL PROTECTED] > > > > > > ---------------------------(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.
signature.asc
Description: This is a digitally signed message part
