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)
Looks like dns error. The postgresql server is on the same host with pgbouncer?How you specify the postgresql server host in pgbouncer.ini? as IP address or hostname?
show the [databases] section in the pgbouncer.ini
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. -- 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>>
