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)
>

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