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

From: Igor Neyman <ineyman(at)perceptron(dot)com>
To: Birta Levente <blevi(dot)linux(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Re: changing port numbers so pgbouncer can read geoserver and postgres
Date: 2013-11-01 14:14:59
Message-ID: A76B25F2823E954C9E45E32FA49D70EC4283B6D8@mail.corp.perceptron.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
> owner(at)postgresql(dot)org] On Behalf Of Birta Levente
> Sent: Friday, November 01, 2013 9:50 AM
> To: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] 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.
> >

Obviously, your PgBouncer is not connecting to your Postgres.

I assume, you run them both on the same machine.
So, do you you have localhost mapped to 127.0.0.1 in your hosts file under windows\system32\drivers\ets directory?
If not, change your pgbouncer.ini config file to use IP address 127.0.0.1 instead of localhost in [database] section.

Regards,
Igor Neyman

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Igor Neyman 2013-11-01 14:34:04 Re: Explanantion on pgbouncer please
Previous Message Birta Levente 2013-11-01 14:00:18 Re: Re: changing port numbers so pgbouncer can read geoserver and postgres