On Sun, Nov 20, 2011 at 2:39 AM, Phoenix Kiula <phoenix.kiula@xxxxxxxxx> wrote: > On Sun, Nov 20, 2011 at 2:13 AM, Adrian Klaver <adrian.klaver@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
