Thread: logging transactions

logging transactions

From
Lorenzo Huerta
Date:
Does anyone know a good way to create a log file of any transaction
done on a postgres 6.3 database. By transaction i mean an
update,delete,insert,vacuum,rename, etc. I have expierence in php2,
little in php3.1 and expierence in perl programming.


-Lorenzo Huerta

  lorhuerta@yahoo.com,
   lorenzo@nmsu.edu


_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com


Re: [PHP3] logging transactions

From
Colin Viebrock
Date:
Also sprach Lorenzo Huerta (at 05:20 PM 7/26/98 -0700) ...
>Does anyone know a good way to create a log file of any transaction
>done on a postgres 6.3 database. By transaction i mean an
>update,delete,insert,vacuum,rename, etc. I have expierence in php2,
>little in php3.1 and expierence in perl programming.

Well, for MySQL, you start the daemon with a --logging switch.

I'll assume there is something similar for Postgres, probably documented
nicely in the manual.


.........................................................................
Colin Viebrock           Creative Director - Private World Communciations
cmv@privateworld.com                          http://www.privateworld.com
ICQ: 11386088

                           Give a man a fish, and you feed him for a day.
             Teach him to use the Net, and he won't bother you for weeks.