On Sun, Nov 20, 2011 at 2:39 AM, Phoenix Kiula <phoenix.ki...@gmail.com> wrote:
> On Sun, Nov 20, 2011 at 2:13 AM, Adrian Klaver <adrian.kla...@gmail.com> 
> wrote:
>>
>> http://pgbouncer.projects.postgresql.org/doc/config.html
>>
>> I have never used pgbouncer, but from above it would seem you need to set up 
>> a
>> [databases] section to tie pgbouncer to the Postgres server.
>> See:
>> SECTION [databases]
>
>
>
> Thanks Adrian. All this is done.
>
> The config file link just describes what each option means. There's
> zero information about how to actually tweak or wisely set the stuff!
> :(
>
> Anyway, with half a day of googling or so, and looking at sundry blogs
> and such, I have pgbouncer running on port 6432. PG runs on the usual
> 5432.
>
> I still keep seeing the "Sorry, too many clients already" error.
>
> From my PHP code, what line should I use? This does NOT work:
>
>  $link   = pg_connect("host=localhost dbname=$db user=$user password=$pass");
>
> If I remove the port number, it works. Is it then connecting straight
> to the DB? What am I missing? Pgbouncer is working, but not accepting
> PHP pg_connect() call. The username and password are correct for sure.
>
> Any thoughts?


I mean this does not work:

   $link   = pg_connect("host=localhost port=6432 dbname=$db
user=$user password=$pass");

When I remove that port number, it works. I suppose it connects
directly to PG. And this is still leading to too many connections.

Also, this does NOT work:

   psql snipurl -E "snipurl_snipurl" -p 6543

Shows me this error:

   psql: ERROR:  no working server connection

How come? The pgbouncer is on!

   > ps aux | grep pgbouncer
   postgres  5567  0.0  0.0  16880   508 ?        R    13:50   0:00
pgbouncer -d /etc/pgbouncer.ini
   root      5583  0.0  0.0  61188   764 pts/2    R+   13:50   0:00
grep pgbouncer


Any thoughts? How can I make my PHP connect to the pgbouncer?

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to