Re: Extracting SQL from logs in a usable format

From: Chris Ernst <cernst(at)esoft(dot)com>
To: Filip Rembiałkowski <plk(dot)zuber(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Extracting SQL from logs in a usable format
Date: 2009-12-19 15:20:33
Message-ID: 4B2CEF41.2080508@esoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hmm.. That does look very interesting. The only thing that concerns me
is where it says it supports "Basic Queries (Extended queries not yet
supported)". I'm not sure what is meant by "Extended queries". Any idea?

Thank you for the pointer, Filip. I'll check it out.

- Chris

Filip Rembiałkowski wrote:
>
> Tsung [http://tsung.erlang-projects.org/] has a nice pg proxy module. It
> records your "query stream" and is able to replay it later.
>
>
>
> 2009/12/18 Chris Ernst <cernst(at)esoft(dot)com <mailto:cernst(at)esoft(dot)com>>
>
> Hi all,
>
> I have a project where I need to be able to capture every query from a
> production system into a file such that I can "replay" them on a staging
> system. Does such a thing already exist or should I start writing my
> own log parser?
>
> Thank you for your help.
>
> Chris Ernst
> eSoft, Inc.
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org
> <mailto:pgsql-general(at)postgresql(dot)org>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>
>
>
> --
> Filip Rembiałkowski
> JID,mailto:filip(dot)rembialkowski(at)gmail(dot)com
> <mailto:filip(dot)rembialkowski(at)gmail(dot)com>
> http://filip.rembialkowski.net/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John DeSoi 2009-12-19 15:32:02 Re: Extended Query, flush or sync ?
Previous Message Merlin Moncure 2009-12-19 14:56:05 Re: Selecting from table into an array var