Re: Re: changing port numbers so pgbouncer can read geoserver and postgres

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.txt
>
>
>> And 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 not
> relevant 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.
>
>