[Pgpool-general] problem with pg_connect and pid_file_name

Gerd König koenig at transporeon.com
Mon Mar 9 08:14:36 UTC 2009


Hello,

starting a new week with problems isn't that fine ;-) , but I got stuck
at this point and wanted to ask for help....
Wwhile playing with pgpool I ran into a problem (obviously) at calling
"@pg_connect"-function.
If I click "Node status" in the menu there's only "please wait..."
displayed in the innerHtml and nothing happens.
If I comment the line "$conn = @pg_connect($conStr);" in common.php and
print the connectionstring I can see that the parameters are fine.
To validate it, I put this connectionstring in a test script like the
following one, and it worked, called at the same server pgpool is
running at..!?!?!=>
<?php
  $connection = @pg_connect("host=dbhost01 port=5432 dbname=template1
user=postgres")
      or die ("error connecting to PostgreSQL --> " . pg_last_error($conn));
  $result = pg_exec("SELECT * FROM pg_stat_activity ");
  $arr = pg_fetch_all_columns($result, 1);
  var_dump($arr);
  pg_close($connection);
?>

There's no error in the apache errorlog and no entry in the
postgresql.log. Where can I have a look at what's going on, is it
possible to enable some debug output..?!?!

BTW: there's an additional mysterious thing ;-)
In pgpool.log I got the message
"
Undefined index:  pid_file_name in
/srv/www/htdocs/pgpoolAdmin/common.php on line 274
"

.....I'm working with pgpool 2.1 and pgpoolAdmin2.1Beta, yes, probably I
should update to latest 2.2, but I think these are basic functions
independant from pgpool version.


thanks in advance...GERD...


More information about the Pgpool-general mailing list