Re: [ADMIN] Logging just SQL commands in an SQL script format

2007-01-25 Thread Campbell, Lance
PROTECTED] On Behalf Of Rigmor Ukuhe Sent: Thursday, January 25, 2007 7:21 AM To: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Logging just SQL commands in an SQL script format Campbell, Lance wrote: > I want to log all SQL commands as an executable script file for use in > performance t

Re: [ADMIN] Logging just SQL commands in an SQL script format

2007-01-25 Thread Daniel Cristian Cruz
Look at pgfouine. It can extract SQL commands from log, and build a xml file to be used with tsung to generate some load testing. Kind regards... On 1/24/07, Campbell, Lance <[EMAIL PROTECTED]> wrote: I want to log all SQL commands as an executable script file for use in performance testin

Re: [ADMIN] Logging just SQL commands in an SQL script format

2007-01-25 Thread Rigmor Ukuhe
Campbell, Lance wrote: I want to log all SQL commands as an executable script file for use in performance testing. Currently there is a lot of information in the log that is generated that would not be executable. Below is an example of what I would want to see; which is just the SQL. E