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
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 |