[Pgpool-general] Problems connecting to PGPool

[Tatsuo Ishii]

>  That was my thought at first as well. Unfortunately, as far as I can tell from the log entries on startup (http://dpaste.org/KJ5g/), it does seem to be loading the proper configuration file.

Oh, ok.

> Is it possible that there's something off about my configuration values which force pgpool to ignore them and use defaults?

No idea. Is it possible for you to attch gdb to one of pgpool process
and print the contens of "pool_config" value? It is a global variable
and has all the configuration values. You want to type "p
*pool_config" from gdb prompt.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> -- 
> Sean O'Connor
> Developer / Saaspire
> 
> On Thursday, December 9, 2010 at 7:16 PM, Tatsuo Ishii wrote:
> 
>> 
>> >  I'm having some trouble getting a connection through pgpool working and any suggestions on what I am doing wrong would be tremendously helpful. Below are my configuration file, relevant chunk of log file, and a terminal session of me successfully connecting to each backend directly and failing when hitting pgpool:
>> > 
>> > 
>> 
>> Your DB servers are '10.124.51.89' and '10.98.182.126' but pgpool
>> tries to connect to UNIX domain socket and raises an ERROR. It seems
>> your pgpool is looking at different configuration file what you are
>> prodiving. To find what pgpool is looking at, you might want to turn
>> on -d (debug) option or you could use strace or some such to find what
>> pgpool opens for pgpool.conf.
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese: http://www.sraoss.co.jp