<font size="4"><font face="courier new,monospace"><i>Hi Wolf, thanks for getting back to me so quickly.<br><br><font size="4"><font size="4">F<font size="4">or <font size="4">me, pg_top also shows the localhos<font size="4">t 127.0.0.<font size="4">1 of<br>
<font size="4">all connections managed by pg_pool:<br><br><font size="4"> PID USERNAME PRI NICE SIZE RES STATE TIME WCPU CPU COMMAND<br> 6171 postgres 16 0 2685M 1041M run 12:52 63.14% 67.78% postgres: mavmail mavmail 127.0.0.1(54941) SELECT <br>
9756 postgres 15 0 2691M 332M sleep 0:00 1.50% 14.15% postgres: mavmail mavmail 127.0.0.1(40242) idle <br> 3870 postgres 15 0 2687M 2590M sleep 88:52 4.63% 10.17% postgres: prime prime_production 127.0.0.1(35780) idle <br>
7103 postgres 15 0 2692M 779M sleep 0:06 2.24% 8.77% postgres: mavmail mavmail 127.0.0.1(39860) idle <br> 7419 postgres 15 0 2705M 500M sleep 0:27 0.50% 5.98% postgres: mavmail mavmail 127.0.0.1(39984) idle <br>
<br><br></font></font></font></font></font></font></font></font></i></font></font><br><div class="gmail_quote">On Mon, Oct 22, 2012 at 9:04 AM, Wolf Schwurack <span dir="ltr"><<a href="mailto:wolf@uen.org" target="_blank">wolf@uen.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Have you tried using pg_top? It shows the ip connects of each process.
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Wolf<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> <a href="mailto:pgpool-general-bounces@pgpool.net" target="_blank">pgpool-general-bounces@pgpool.net</a> [mailto:<a href="mailto:pgpool-general-bounces@pgpool.net" target="_blank">pgpool-general-bounces@pgpool.net</a>]
<b>On Behalf Of </b>Mark Steben<br>
<b>Sent:</b> Monday, October 22, 2012 6:47 AM<br>
<b>To:</b> <a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
<b>Subject:</b> [pgpool-general: 1096] Just installed pgpool in production<u></u><u></u></span></p><div><div class="h5">
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><i><span style="font-size:13.5pt;font-family:"Courier New"">Good morning,<br>
<br>
We are running with pgpool for our second business day today.<br>
I was wondering if there is a way to capture the i/p connection of the<br>
originating server, as pgpool now manages most of our connections and<br>
emits a local (127.0.0.1) I/P address. We would prefer to trace back to<br>
the originating server(s) for debug purposes.<br>
</span></i><i><span style="font-size:13.5pt"><br>
We are currently running postgres 8.3.15 and pgpool 3.2.0.<br>
<br>
thank you,<br clear="all">
</span></i><br>
-- <u></u><u></u></p>
<div>
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#333333">Mark Steben</span></b><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#888888">
</span><span style="color:#888888"><br>
Database Administrator</span><span style="font-size:8.0pt;font-family:"Century Gothic","sans-serif";color:#888888"><br>
<a href="http://www.autorevenue.com/" target="_blank"><b><span style="color:#4f81bd;text-decoration:none">@utoRevenue</span></b></a> </span><span style="font-size:10.0pt;font-family:"Century Gothic","sans-serif";color:#4f81bd">|</span><span style="font-size:8.0pt;font-family:"Century Gothic","sans-serif";color:#888888"> <a href="http://www.autobase.net/" target="_blank"><b><span style="color:#4f81bd;text-decoration:none">Autobase</span></b></a>
<br>
</span><b><span style="font-size:8.0pt;font-family:"Century Gothic","sans-serif";color:#4f81bd">CRM division of Dominion Dealer Solutions</span></b><span style="font-size:8.0pt;font-family:"Century Gothic","sans-serif";color:#888888"> <br>
</span><span style="font-size:8.0pt;font-family:"Century Gothic","sans-serif";color:gray">95D Ashley Ave.<br>
West Springfield, MA 01089</span><span style="font-size:8.0pt;font-family:"Century Gothic","sans-serif";color:#888888">
<br>
</span><span style="font-size:8.0pt;font-family:"Century Gothic","sans-serif";color:gray">t: <a href="tel:413.327-3045" value="+14133273045" target="_blank">413.327-3045</a></span><span style="font-size:8.0pt;font-family:"Century Gothic","sans-serif";color:#888888">
<br>
</span><span style="font-size:8.0pt;font-family:"Century Gothic","sans-serif";color:gray">f: <a href="tel:413.383-9567" value="+14133839567" target="_blank">413.383-9567</a></span><span style="font-size:8.0pt;font-family:"Century Gothic","sans-serif";color:#888888">
</span><u></u><u></u></p>
</div>
<p style="margin-bottom:12.0pt"><span style="font-size:8.0pt;font-family:"Century Gothic","sans-serif";color:#888888"><a href="http://www.fb.com/DominionDealerSolutions" target="_blank">www.fb.com/DominionDealerSolutions</a><br>
<a href="http://www.twitter.com/DominionDealer" target="_blank">www.twitter.com/DominionDealer</a><br>
</span><span style="font-size:8.0pt;font-family:"Century Gothic","sans-serif";color:gray"> <a href="http://www.autorevenue.com/" target="_blank">www.drivedominion.com</a><br>
<br>
<br>
<br>
<br>
</span><u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
</div></div></div>
</div>
</blockquote></div><br><br clear="all"><br>-- <br><div><span><font color="#888888"><span style="font-family:Calibri;font-size:11pt"><span style="color:rgb(51,51,51)"><b>Mark Steben</b></span> </span><br> Database Administrator<span style="font-family:"Century Gothic";font-size:8pt"><span style="color:rgb(51,51,51)"></span><br>
<a style="color:rgb(79,129,189);font-size:8pt;font-weight:bold;text-decoration:none" href="http://www.autorevenue.com/" target="_blank">@utoRevenue</a> <span style="color:rgb(79,129,189);font-size:10pt">|</span> <a style="color:rgb(79,129,189);font-size:8pt;font-weight:bold;text-decoration:none" href="http://www.autobase.net/" target="_blank">Autobase</a> <span style="color:rgb(79,129,189);font-size:10pt"></span> <br>
<span style="color:rgb(79,129,189);font-size:8pt;font-weight:bold;text-decoration:none">CRM division of Dominion Dealer Solutions</span> <br><span style="color:gray;font-size:8pt">95D Ashley Ave.<br>West Springfield, MA 01089</span> <br>
<span style="color:gray;font-size:8pt">t: <a value="+14132434800">413.327-3045</a></span> <br><span style="color:gray;font-size:8pt">f: <a value="+14132434800">413.383-9567</a></span> </span></font></span></div><p><span><font color="#888888"><span style="font-family:"Century Gothic";font-size:8pt"><a href="http://www.fb.com/DominionDealerSolutions" target="_blank">www.fb.com/DominionDealerSolutions</a><br>
<a href="http://www.twitter.com/DominionDealer" target="_blank">www.twitter.com/DominionDealer</a><br><span style="color:gray;font-size:8pt"> <a href="http://www.autorevenue.com/" target="_blank">www.drivedominion.com</a><br>
<br><a href="http://autobasedigital.net/marketing/DD12_sig.jpg" target="_blank"></a><br><br></span></span></font></span><br><span><font color="#888888"><span style="font-family:"Century Gothic";font-size:8pt"><span style="color:gray;font-size:8pt"><br>
</span></span></font></span></p><font color="#888888"></font><br>