PGPool2 + RemoteHost IP

Поиск
Список
Период
Сортировка
От Rob Emery
Тема PGPool2 + RemoteHost IP
Дата
Msg-id CAPCETpsKFoShMFhK1+7tU9xK578bQvwQ-hAi=fj5RE6x7P_2uw@mail.gmail.com
обсуждение исходный текст
Список 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




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

      

В списке pgsql-admin по дате отправления:

Предыдущее
От: Evgeniy Losev
Дата:
Сообщение:
Следующее
От: David Osborne
Дата:
Сообщение: Accessing query fingerprinting used by pg_stat_statements