PGPool2 + RemoteHost IP

From: Rob Emery <re-pgsql(at)codeweavers(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: PGPool2 + RemoteHost IP
Date: 2015-10-15 11:12:41
Message-ID: CAPCETpsKFoShMFhK1+7tU9xK578bQvwQ-hAi=fj5RE6x7P_2uw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

I'm testing slotting PGPool2 between our developers and our development PG
9.1 instance, it seems to work as expected and I have control over the
lifetime of connections etc which is excellent.

However, I've noticed that there doesn't appear to be any way to track the
client IP address of a query once PGPool is used. pg_stat_activity shows
the pgpool IP (as expected) however PGPool itself doesn't have any way of
linking the remote IP to the pooled connection.

Have I missed something in pcp or the SHOW pool_ commands somewhere?

pgpool2 3.3.4-1
postgresql-9.1 9.1.12-0ubuntu0.12.04

Many Thanks,
Rob

--
Codeweavers October Newsletter
<http://us6.campaign-archive1.com/?u=db934935d4174e46e9063c8c4&id=1cc5b7aebd>
l New features and further enhancements in Showroom
<https://www.codeweavers.net/company-blog/new-features-and-updates>

<https://www.codeweavers.net>

*Phone:* 0800 021 0888 * Email: *contactus(at)codeweavers(dot)net
*Codeweavers Ltd* | Barn 4 | Dunston Business Village | Dunston | ST18 9AB
Registered in England and Wales No. 04092394 | VAT registration no. 974
9705 63

<https://www.linkedin.com/company/codeweavers-limited>
<https://vimeo.com/codeweaversltd>
<https://plus.google.com/b/105942302039373248738/+CodeweaversNet/posts>
<https://twitter.com/CodeweaversTeam?lang=en-gb>

Browse pgsql-admin by date

  From Date Subject
Next Message David Osborne 2015-10-15 11:25:59 Accessing query fingerprinting used by pg_stat_statements
Previous Message Evgeniy Losev 2015-10-13 12:21:39