[pgpool-general: 4542] pgpool_adm extension

[Avi Weinberg]

Hi All,

I'm using pgpool 3.5 and I have two postgres machines and two pgpool machines - total 4 servers.

I would like to know if pgpool_adm is installed on the postgres machines or the pgpool machine.  I assume that if it is installed on the pgpool machine I will have to install postgres on those machines as well right?
Currently I get an error "server localhost does not exist" when installing it on the postgres machine.

   CREATE SCHEMA pgpool;
   CREATE EXTENSION pgpool_adm WITH SCHEMA pgpool ;
   SELECT * FROM pgpool.pcp_node_info(0, 'localhost');

Thanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160313/99ac8bc1/attachment.html>