[pgpool-general: 1097] Re: Just installed pgpool in production

[Wolf Schwurack]

Have you tried using pg_top? It shows the ip connects of each process.

Wolf

From: pgpool-general-bounces at pgpool.net [mailto:pgpool-general-bounces at pgpool.net] On Behalf Of Mark Steben
Sent: Monday, October 22, 2012 6:47 AM
To: pgpool-general at pgpool.net
Subject: [pgpool-general: 1096] Just installed pgpool in production

Good morning,

We are running with pgpool for our second business day today.
I was wondering if there is a way to capture the i/p connection of the
originating server, as pgpool now manages most of our connections and
emits a local (127.0.0.1) I/P address.  We would prefer to trace back to
the originating server(s) for debug purposes.

We are currently running postgres 8.3.15 and pgpool 3.2.0.

thank you,

--
Mark Steben
 Database Administrator
@utoRevenue<http://www.autorevenue.com/> | Autobase<http://www.autobase.net/>
  CRM division of Dominion Dealer Solutions
95D Ashley Ave.
West Springfield, MA 01089
t: 413.327-3045
f: 413.383-9567

www.fb.com/DominionDealerSolutions<http://www.fb.com/DominionDealerSolutions>
www.twitter.com/DominionDealer<http://www.twitter.com/DominionDealer>
 www.drivedominion.com<http://www.autorevenue.com/>





-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20121022/2f7656b3/attachment-0001.html>