Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.




<<attachment: smime.p7s>>


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux