Re: changing port numbers so pgbouncer can read geoserver and postgres - Mailing list pgsql-general

From BladeOfLight16
Subject Re: changing port numbers so pgbouncer can read geoserver and postgres
Date
Msg-id CA+=1U=VPJd48gtjxRBcSVTOELKqgR7nep4cG84KJrA-X1A3jow@mail.gmail.com
Whole thread Raw
In response to Re: changing port numbers so pgbouncer can read geoserver and postgres  (Birta Levente <blevi.linux@gmail.com>)
List pgsql-general
On Fri, Nov 1, 2013 at 9:29 AM, Birta Levente <blevi.linux@gmail.com> wrote:
I don't know what is this geoserver, but this port 8080 I think it's not relevant in this.

I might be able to help: http://geoserver.org/display/GEOS/Welcome. GeoServer is a Java web application that retrieves GIS data (as in PostGIS in the realm of PostgreSQL) and servers it up in standard formats. This allows for greater interoperability than would be possible with only the PostgreSQL/PostGIS database since many clients cannot communicate with PostgreSQL directly.

So the desired request chain is most likely something like this:

Client (E.g., ArcMap, a web page with OpenLayers or Leaflet, another web application that processes the data somehow) --> GeoServer (running on port 8080) --> pgBouncer --> PostgreSQL (with PostGIS extension)

It looks like GeoServer is having a problem connecting to PostgreSQL, so I think you're right. It's either between GeoServer and pgBouncer or pgBouncer and PostgreSQL.

Hopefully, that clears up some points of confusion.

pgsql-general by date:

Previous
From: David Johnston
Date:
Subject: Re: Odd behavior in functions w/ anyarray & anyelement
Next
From: Jeffrey Walton
Date:
Subject: Clang 3.3 Analyzer Results