Re: Transactions

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