| Lists: | pgsql-in-general |
|---|
| From: | Emre ÖZTÜRK <emreozturk(at)outlook(dot)com> |
|---|---|
| To: | "pgsql-in-general(at)postgresql(dot)org" <pgsql-in-general(at)postgresql(dot)org> |
| Subject: | Single Line Query Logging |
| Date: | 2013-07-10 09:47:52 |
| Message-ID: | DUB122-W394891055803E2BF925BECCE7A0@phx.gbl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-in-general |
Hello all,
Is there a parameter to log any SQL query as a single line in audit logs? I have some problems in my SIEM application. If a DBA sends the query as a single line I can gather the whole query, but if he enters like
UPDATE x .......
y=Z ......
where ......
I only get the line starts with UPDATE then I can not see what is really changed in my SIEM logs. I have heard that there is a parameter do what I mean. Do you agree?
Regards,
Emre ÖZTÜRK
| From: | Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com> |
|---|---|
| To: | Emre ÖZTÜRK <emreozturk(at)outlook(dot)com> |
| Cc: | "pgsql-in-general(at)postgresql(dot)org" <pgsql-in-general(at)postgresql(dot)org> |
| Subject: | Re: Single Line Query Logging |
| Date: | 2013-07-10 09:54:55 |
| Message-ID: | CABOikdNCqUc-w2jaS+kYvT_jyL=1zJN1qZeVK6UdBDevjmJ6Vg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-in-general |
On Wed, Jul 10, 2013 at 3:17 PM, Emre ÖZTÜRK <emreozturk(at)outlook(dot)com> wrote:
> Hello all,
>
> Is there a parameter to log any SQL query as a single line in audit logs?
> I have some problems in my SIEM application. If a DBA sends the query as a
> single line I can gather the whole query, but if he enters like
>
> UPDATE x .......
> y=Z ......
> where ......
>
> I only get the line starts with UPDATE then I can not see what is really
> changed in my SIEM logs. I have heard that there is a parameter do what I
> mean. Do you agree?
>
>
Try debug_pretty_print = off (though I haven't used that myself). BTW, this
is a India specific list and the chances of you getting a better and timely
answer are better if you post on pgsql-general.
Thanks,
Pavan
--
Pavan Deolasee
http://www.linkedin.com/in/pavandeolasee
| From: | Emre ÖZTÜRK <emreozturk(at)outlook(dot)com> |
|---|---|
| To: | Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com> |
| Cc: | "pgsql-in-general(at)postgresql(dot)org" <pgsql-in-general(at)postgresql(dot)org> |
| Subject: | Re: Single Line Query Logging |
| Date: | 2013-07-10 10:14:22 |
| Message-ID: | DUB122-W5DC9D0549422A97280871CE7A0@phx.gbl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-in-general |
Thanks for the answer. OK I will subscribe the mailing list you mentioned. I will also try your answer.
Emre ÖZTÜRK
From: pavan(dot)deolasee(at)gmail(dot)com
Date: Wed, 10 Jul 2013 15:24:55 +0530
Subject: Re: [pgsql-in-general] Single Line Query Logging
To: emreozturk(at)outlook(dot)com
CC: pgsql-in-general(at)postgresql(dot)org
On Wed, Jul 10, 2013 at 3:17 PM, Emre ÖZTÜRK <emreozturk(at)outlook(dot)com> wrote:
Hello all,
Is there a parameter to log any SQL query as a single line in audit logs? I have some problems in my SIEM application. If a DBA sends the query as a single line I can gather the whole query, but if he enters like
UPDATE x .......
y=Z ......
where ......
I only get the line starts with UPDATE then I can not see what is really changed in my SIEM logs. I have heard that there is a parameter do what I mean. Do you agree?
Try debug_pretty_print = off (though I haven't used that myself). BTW, this is a India specific list and the chances of you getting a better and timely answer are better if you post on pgsql-general.
Thanks,Pavan
--
Pavan Deolasee
http://www.linkedin.com/in/pavandeolasee