Re: Log to syslog in one line - Mailing list pgsql-general

From Sergey Konoplev
Subject Re: Log to syslog in one line
Date
Msg-id CAL_0b1uNygWPH_zpSfD7wH1En-HH4mbDRPfi6SoXDAfoMZmThw@mail.gmail.com
Whole thread Raw
In response to Log to syslog in one line  (Roberto De Oliveira <rcdeoliveira@gmail.com>)
Responses Re: Log to syslog in one line
List pgsql-general
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

pgsql-general by date:

Previous
From: Ondrej Ivanič
Date:
Subject: remove some rows from resultset
Next
From: Chris
Date:
Subject: Performance degrades until dump/restore