Re: about pgpool question

From: "Charles(dot)Hou" <ivan(dot)hou(at)msa(dot)hinet(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: about pgpool question
Date: 2007-09-21 02:10:59
Message-ID: 1190340659.272419.166820@e9g2000prf.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 9 21 , 10 04 , "Charles.Hou" <ivan(dot)(dot)(dot)(dot)(at)msa(dot)hinet(dot)net> wrote:
> On 9 20 , 3 11 , Hannes Dorbath <li(dot)(dot)(dot)(at)theendofthetunnel(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message D. Dante Lorenso 2007-09-21 05:12:22 Using RETURNING with INTO inside pgsql
Previous Message Charles.Hou 2007-09-21 02:04:14 Re: about pgpool question