Re: [GENERAL] about pgpool question

From: Charles.Hou <ivan.hou(at)msa.hinet.net>
Date: Thu Sep 20 2007 - 22:04:14 EDT

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.

---------------------------(end of broadcast)---------------------------

TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq Received on Mon Sep 24 18:09:08 2007