Quick Links

Extracting SQL from logs in a usable format

From:	Chris Ernst <cernst(at)esoft(dot)com>
To:	pgsql-general(at)postgresql(dot)org
Subject:	Extracting SQL from logs in a usable format
Date:	2009-12-18 21:08:07
Message-ID:	4B2BEF37.7000605@esoft.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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.

Responses

Re: Extracting SQL from logs in a usable format at 2009-12-18 21:48:03 from Rory Campbell-Lange
Re: Extracting SQL from logs in a usable format at 2009-12-19 11:47:59 from Filip Rembiałkowski
Re: Extracting SQL from logs in a usable format at 2009-12-19 22:37:13 from Albe Laurenz
Re: Extracting SQL from logs in a usable format at 2009-12-20 11:59:20 from hubert depesz lubaczewski

Browse pgsql-general by date

	From	Date	Subject
Next Message	Gauthier, Dave	2009-12-18 21:15:29	defining yuor own commands in PG ?
Previous Message	Alex -	2009-12-18 20:38:09	Re: PL/Perl Performance Problems