On 01/11/2013 15:39, si24 wrote:
have you specified in your pgbouncer.ini auth_type and auth_file ?my auth_type is md5 and my auth_file is D:\Program Files\PostgreSQL\etc\userlist.txtAnd I think you really need to check pgbouncer log !!!I get a lot of this im my pgbouncer log 2013-11-01 12:17:49.228 2860 LOG Stats: 0 req/s, in 0 b/s, out 0 b/s,query 0 us 2013-11-01 14:38:38.490 2860 WARNING lookup failed: localhost: result=11001 2013-11-01 14:38:38.491 2860 LOG S-0188d930: manifold/postgrest@(bad-af):0 closing because: server dns lookup failed (age=5)I don't know what is this geoserver, but this port 8080 I think it's notrelevant in this. geoserver is my map webpage that uses the postgres database to make the map in away.
From pgbouncer README: Building for WIN32 ------------------ At the moment only build env tested is MINGW32 / MSYS. Cygwin and Visual $ANYTHING are untested. Libevent 2.x is required for DNS hostname lookup.I don't know how building works on windows and don't know how you get pgbouncer ... but seems you need Libevent 2.x too
Maybe try with IP addresses.
-- View this message in context: http://postgresql.1045698.n5.nabble.com/changing-port-numbers-so-pgbouncer-can-read-geoserver-and-postgres-tp5776631p5776634.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
<<attachment: smime.p7s>>
