Registering all User Operations 
Author Message
 Registering all User Operations

Hi:

I'm using postgresql 7.1 release 1 on RH 7.1.

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/explain me for doing this?

Thanks.

--

SAMTEK, Consultores Informtica y Telecomunicaciones
Calificado como Agente Tecnolgico por la Consejera  de Empleo y Desarrollo Tecnolgico
RAITEC (Red Andaluza de Innovacin y Tecnologa)

Adolfo M. Pachn Rodrguez
Director de Sistemas

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

tlf: 95 428 6045
fax: 95 427 8500

http://www.***.com/

--

SAMTEK, Consultores Informtica y Telecomunicaciones
Calificado como Agente Tecnolgico por la Consejera  de Empleo y Desarrollo Tecnolgico
RAITEC (Red Andaluza de Innovacin y Tecnologa)

Adolfo M. Pachn Rodrguez
Director de Sistemas

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

tlf: 95 428 6045
fax: 95 427 8500

http://www.***.com/

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command



Tue, 05 Jul 2005 18:46:50 GMT
 Registering all User Operations

Look in postgresql.conf for something like debug_print_query or
something like that.  7.1 is pretty old, but I am sure it is there
somewhere.

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

Quote:

> Hi:

> I'm using postgresql 7.1 release 1 on RH 7.1.

> 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/explain me for doing this?

> 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

> --

> 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

> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command


--
  Bruce Momjian                        |  http://candle.pha.pa.us

  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------



Wed, 06 Jul 2005 01:15:15 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Registering all User Operations

2. registering the user defined function in olap manager

3. Operation Cancelled By Associated User

4. Returning control to user while operations are running

5. ERROR : ORA-01013: user requested cancel of current operation

6. single-user mode after backup operation...

7. Preventing users to register a server or reach the objects

8. Error 3059, Operation Cancelled by the user

9. How to show user's operation?

10. register new user

11. Registering user-defined function for calculated member


 
Powered by phpBB® Forum Software