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

[Mark Steben]

*Hi Wolf,  thanks for getting back to me so quickly.

For me, pg_top also shows the localhost 127.0.0.1 of
all connections managed by pg_pool:

   PID USERNAME PRI NICE  SIZE   RES STATE   TIME   WCPU    CPU COMMAND
 6171 postgres  16    0 2685M 1041M run    12:52 63.14% 67.78% postgres:
mavmail mavmail 127.0.0.1(54941) SELECT
 9756 postgres  15    0 2691M  332M sleep   0:00  1.50% 14.15% postgres:
mavmail mavmail 127.0.0.1(40242) idle
 3870 postgres  15    0 2687M 2590M sleep  88:52  4.63% 10.17% postgres:
prime prime_production 127.0.0.1(35780) idle
 7103 postgres  15    0 2692M  779M sleep   0:06  2.24%  8.77% postgres:
mavmail mavmail 127.0.0.1(39860) idle
 7419 postgres  15    0 2705M  500M sleep   0:27  0.50%  5.98% postgres:
mavmail mavmail 127.0.0.1(39984) idle


*
On Mon, Oct 22, 2012 at 9:04 AM, Wolf Schwurack <wolf at uen.org> wrote:

>  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
> www.twitter.com/DominionDealer
>  www.drivedominion.com <http://www.autorevenue.com/>
>
>
>
>
> ****
>
> ** **
>



-- 
*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
www.twitter.com/DominionDealer
 www.drivedominion.com <http://www.autorevenue.com/>

<http://autobasedigital.net/marketing/DD12_sig.jpg>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20121022/145bc812/attachment.html>