[Pgpool-general] Using pgpool to replicate queries on a dev server

[ioguix at free.fr]

Hi,

I am working on a project to upgrade a PostgreSQL 8.1 database (then some 
7.2 !) and I need to create a SQL test scenario based on production 
activity.

However, all SQL queries are prepared and 8.1 doesn't show the parameters 
values in its log file (even in debug5).

That's where pgpool might be useful. Is it possible to make pgpool 
relaying queries on both production and dev servers, but only consider the 
answer from production and
ignore the one from the dev ? I didn't found a way to do it with the 
current version of pgpool.

How hard would it be to actualy implement it ? do you have some advice and 
starting points to give where I should look first ?

Thanks,

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