| From: | Andreas Joseph Krogh <andreas(at)visena(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Sv: Transactions |
| Date: | 2019-04-09 09:41:04 |
| Message-ID: | VisenaEmail.4.163e6ee42df1ee1f.16a017693c6@tc7-visena |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
På tirsdag 09. april 2019 kl. 11:26:29, skrev Karl Martin Skoldebrand <
KS0C77263(at)TechMahindra(dot)com <mailto:KS0C77263(at)TechMahindra(dot)com>>:
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.
Not "without anyone having set up anything specific", but you can change the
setting in postgresql.conf to: log_statement = 'all' and reload the settings.
You can now see all SQL executed in the log and can debug what's going on. --
Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963
andreas(at)visena(dot)com <mailto:andreas(at)visena(dot)com> www.visena.com
<https://www.visena.com> <https://www.visena.com>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fabio Pardi | 2019-04-09 09:44:57 | Re: Transactions |
| Previous Message | Karl Martin Skoldebrand | 2019-04-09 09:26:29 | Transactions |