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

[Birta Levente]

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?



show the [databases] section in the pgbouncer.ini

How you specify the postgresql server host in pgbouncer.ini? as IP address or hostname?

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.

smime.p7s
Description: S/MIME Cryptographic Signature