Re: Log to syslog in one line

From: Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>
To: Roberto De Oliveira <rcdeoliveira(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, Eva Duque <eve(dot)tito(at)gmail(dot)com>, Francel Ramirez <francelramirez(at)gmail(dot)com>
Subject: Re: Log to syslog in one line
Date: 2012-04-19 05:27:23
Message-ID: CAL_0b1uNygWPH_zpSfD7wH1En-HH4mbDRPfi6SoXDAfoMZmThw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Apr 18, 2012 at 8:55 AM, Roberto De Oliveira
<rcdeoliveira(at)gmail(dot)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(at)postgresql(dot)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(dot)ru(at)gmail(dot)com Skype: gray-hemp

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris 2012-04-19 06:35:26 Performance degrades until dump/restore
Previous Message Ondrej Ivanič 2012-04-19 04:26:49 remove some rows from resultset