Thread: Transaction-log

Transaction-log

From
Stefan Holzheu
Date:
Hallo,

we just started to replace some oracle applications with postgresql. In
Principle it works fine.
There is just one thing I haven't found in the documentation:
It is possible to write a log of all insert, update and delete querys? I
would like to have this to restore - starting from a nightly dump - a
certain  state of the database after a user might have done something
imprudent.

regards

    Stefan
--
-----------------------------
Dr. Stefan Holzheu
Tel.: 0921/55-5720
Fax.: 0921/55-5799
BITOeK Wiss. Sekretariat
Universitaet Bayreuth
D-95440 Bayreuth
-----------------------------