Re: about pgpool question - Mailing list pgsql-general

From Charles.Hou
Subject Re: about pgpool question
Date
Msg-id 1190340659.272419.166820@e9g2000prf.googlegroups.com
Whole thread Raw
In response to Re: about pgpool question  ("Charles.Hou" <ivan.hou@msa.hinet.net>)
List pgsql-general
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


pgsql-general by date:

Previous
From: "Charles.Hou"
Date:
Subject: Re: about pgpool question
Next
From: Alban Hertroys
Date:
Subject: Re: "not in" clause too slow?