Thread: Log to syslog in one line

Hi everybody,
I am interesting on do some kind of audit on a web system through his
postgres database. For this purpose , I configured postgres to send
all query to syslog-ng to parser them and store them in another
database, but I have a issue: all query splits into diferents lines
making imposible work with them. There is a way to configure postgres
to send every query in just one line?
I do not want to use cvslog for his system overhead.

Thank you in advanced.

P.D:
- Somebody tries this approach before
http://www.syslog.org/forum/index.php?topic=1150.0
- My english is not good, sorry.

--
Saludos,
Roberto De Oliveira

On Wed, Apr 18, 2012 at 8:55 AM, Roberto De Oliveira
<rcdeoliveira@gmail.com> wrote:
> postgres database. For this purpose , I configured postgres to send
> all query to syslog-ng to parser them and store them in another
> database, but I have a issue: all query splits into diferents lines
> making imposible work with them. There is a way to configure postgres
> to send every query in just one line?

If I understand it correct you need a statement playback solution.
Here is some info about it
http://wiki.postgresql.org/wiki/Statement_Playback.

> I do not want to use cvslog for his system overhead.
>
> Thank you in advanced.
>
> P.D:
> - Somebody tries this approach before
> http://www.syslog.org/forum/index.php?topic=1150.0
> - My english is not good, sorry.
>
> --
> Saludos,
> Roberto De Oliveira
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general



--
Sergey Konoplev

LinkedIn: http://ru.linkedin.com/in/grayhemp
GTalk: gray.ru@gmail.com Skype: gray-hemp

>
> If I understand it correct you need a statement playback solution.
> Here is some info about it
> http://wiki.postgresql.org/wiki/Statement_Playback.
>

Thanks Sergey,

I was reading and a I realized that maybe this can be useful.

--
Saludos,
Roberto De Oliveira