Re: Issue related to audit trigger after upgrade to Postgresql9.6

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Have you tried to create an issue on this github project ? 
Maybe this solution was abandoned and you should take a look on a new auditory solution like: https://github.com/pgaudit/pgaudit


2017-01-19 14:24 GMT+01:00 Vikash Pandey <vikash.kumar.pandey@xxxxxxxxx>:
Hi,

Does anyone has any idea?
We are stuck.

Regards
Vikash Kumar Pandey


On Mon, Jan 2, 2017 at 1:25 PM, Vikash Pandey <vikash.kumar.pandey@xxxxxxxxx> wrote:
Hi,

We have upgraded database from 9.2 to 9.6.
In 9.2 we were using auditing of tables through audit trigger.
https://wiki.postgresql.org/wiki/Audit_trigger_91plus

In this trigger function there is transaction_id which is generated by txid_current()
After upgradation this transaction_id some how reset itself which was unexpected.
Our applications depend on this transaction_id which is misbehaving currently.
How we can handle this situation.


Thanks in advance.


Regards
Vikash Kumar Pandey.




[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux