Обсуждение: Re: about pgpool question

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 Dorbath
>
> it'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