Re: Extracting SQL from logs in a usable format

From: "JGuillaume (ioguix) de Rorthais" <ioguix(at)free(dot)fr>
To: Shoaib Mir <shoaibmir(at)gmail(dot)com>
Cc: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>, Chris Ernst *EXTERN* <cernst(at)esoft(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Extracting SQL from logs in a usable format
Date: 2009-12-20 10:18:08
Message-ID: 4B2DF9E0.2050305@free.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Shoaib Mir a écrit :
> On Sun, Dec 20, 2009 at 9:37 AM, Albe Laurenz
> <laurenz(dot)albe(at)wien(dot)gv(dot)at <mailto:laurenz(dot)albe(at)wien(dot)gv(dot)at>> wrote:
>
> Chris Ernst wrote:
>> 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?
>
>
> I am not sure if its still available but there used to a nice tool
> for doing the same, I guess it was named as "Playr" by myyearbook.

AFAIK, it's a dead project and its home at myyearbook is unavailable.
However, you can still access their download page:
https://area51.myyearbook.com/downloads/

I did find the svn repo with some googling some time ago...

I did some quick investigation on it, it seems it doesn't work with
extended queries neither.

> Regards, -- Shoaib Mir http://shoaibmir.wordpress.com/

- --
Jehan-Guillaume (ioguix) de Rorthais
www.dalibo.com

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkst+d8ACgkQxWGfaAgowiKA8gCcDhiCPC6pZCghVIuVePd0s3lo
GtMAoKFV5YldPH8QjdYGMRZ+Mq0Io/Dk
=+ANY
-----END PGP SIGNATURE-----

In response to

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2009-12-20 11:59:20 Re: Extracting SQL from logs in a usable format
Previous Message JGuillaume (ioguix) de Rorthais 2009-12-20 10:09:54 Re: Extracting SQL from logs in a usable format