Re: Transactions - Mailing list pgsql-general

From Achilleas Mantzios
Subject Re: Transactions
Date
Msg-id 9e40b84f-1130-a0b1-06da-1868347a5df7@matrix.gatewaynet.com
Whole thread Raw
In response to Transactions  (Karl Martin Skoldebrand <KS0C77263@TechMahindra.com>)
Responses Re: Transactions  (Melvin Davidson <melvin6925@gmail.com>)
List pgsql-general
On 9/4/19 12:26 μ.μ., Karl Martin Skoldebrand wrote:

Hi,

 

Is there a way to track “transactions” by default (i.e. without anyone having set up anything specific). The problem I am facing is that users are claiming that settings are disappearing with them doing anything to affect them. It would be good to be able to see what postgresql thinks is going on.

*Subscriber adds Severity/BU/Service by ticking the corresponding box in subscriber configuration in WEBAPP. This works for some time.

*Subscriber stops receiving selected [tickets].

*Upon checking settings the selected Severity/BU/Service has been unselected.


If what you need is business-like trail to specific relations (tables) (most probably what you need) then you may find pgaudit very useful. Its author dwsteele also wrote pgbackrest, as a tool it works wonders and the support is superb.

 

/M.

 

============================================================================================================================

Disclaimer:  This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at http://www.techmahindra.com/Disclaimer.html externally http://tim.techmahindra.com/tim/disclaimer.html internally within TechMahindra.

============================================================================================================================



-- 
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt

pgsql-general by date:

Previous
From: Andreas Joseph Krogh
Date:
Subject: Sv: RE: Transactions
Next
From: Pavel Suderevsky
Date:
Subject: Re: 9.6.11- could not truncate directory "pg_serial": apparent wraparound