about pgpool question
i have installed the pgpool in the server and start it. but how can i
know it's working? i means that the clients connected to the database
by the pgpool.
On 20.09.2007 04:34, Charles.Hou wrote:
i have installed the pgpool in the server and start it. but how can i
know it's working? i means that the clients connected to the database
by the pgpool.
Well, read the documentation, configure pgpool to listen on 5432 - or
whatever your PG instance was listening on. Then configure PG to listen
on some other port and tell pgpool about it. Limit connections to PG to
localhost in pg_hba.conf, restart. If in doubt, strace it.
--
Regards,
Hannes Dorbath
On 9 20 , 3 11 , Hannes Dorbath <li...@theendofthetunnel.de> wrote:
On 20.09.2007 04:34, Charles.Hou wrote:
i have installed thepgpoolin the server and start it. but how can i
know it's working? i means that the clients connected to the database
by thepgpool.Well, read the documentation, configurepgpoolto listen on 5432 - or
whatever your PG instance was listening on. Then configure PG to listen
on some other port and tellpgpoolabout it. Limit connections to PG to
localhost in pg_hba.conf, restart. If in doubt, strace it.--
Regards,
Hannes Dorbath
it's ok. i have setup it successful.
another question, when i stop the pgpool, it will not stop all the
client connections automatically. it's the reason of the pgpool.conf
value,or the pgpool can't force stop all connections.
On 9 21 , 10 04 , "Charles.Hou" <ivan....@msa.hinet.net> wrote:
On 9 20 , 3 11 , Hannes Dorbath <li...@theendofthetunnel.de> wrote:
On 20.09.2007 04:34, Charles.Hou wrote:
i have installed thepgpoolin the server and start it. but how can i
know it's working? i means that the clients connected to the database
by thepgpool.Well, read the documentation, configurepgpoolto listen on 5432 - or
whatever your PG instance was listening on. Then configure PG to listen
on some other port and tellpgpoolabout it. Limit connections to PG to
localhost in pg_hba.conf, restart. If in doubt, strace it.--
Regards,
Hannes Dorbathit's ok. i have setup it successful.
another question, when i stop thepgpool, it will not stop all the
client connections automatically. it's the reason of thepgpool.conf
value,or thepgpoolcan't force stop all connections.
sorry, i have found the answer.
$ pgpool -m i[mmediate] stop
Thanks, Hannes
i have installed the pgpool in the server and start it. but how can i
know it's working? i means that the clients connected to the database
by the pgpool.
Enable log_connections on your PostgreSQL server(s)'s configuration
and see if incoming connections come from pgpool.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
i have installed the pgpool in the server and start it. but how can i
know it's working? i means that the clients connected to the database
by the pgpool.
Enable log_connections on your PostgreSQL server(s)'s configuration
and see if incoming connections come from pgpool.
--
Tatsuo Ishii
SRA OSS, Inc. Japan