[Pgpool-general] pgpool II + postGIS

[David Nugent]

David Nugent wrote:
> Does this combination work?
>
>  From initial testing it seems not. We are running a mapserver 
> application for map tile rendering and looking to load balance postgis 
> queries with pgpool II v1.1 but seeing query errors from mapserver, e.g.
>
>   prepare_database(): Error executing POSTGIS BEGIN statement.
>   

Just a little more on this.

192.168.69.100:5432 is the address:port to which pgpool binds and to 
which clients connect.

192.168.69.1:5432 is the primary server address:port, and the IP to 
which postgresql binds.

Log from PostgreSQL:

2007-06-06 10:04:14 ESTLOG:  00000: connection received: 
host=192.168.69.1 port=54840
2007-06-06 10:04:14 ESTLOCATION:  BackendInitialize, postmaster.c:2752
2007-06-06 10:04:14 ESTLOG:  08006: could not receive data from client: 
Connection reset by peer
2007-06-06 10:04:14 ESTLOCATION:  pq_recvbuf, pqcomm.c:727
2007-06-06 10:04:14 ESTLOG:  08P01: unexpected EOF on client connection
2007-06-06 10:04:14 ESTLOCATION:  SocketBackend, postgres.c:307
2007-06-06 10:04:14 ESTLOG:  00000: disconnection: session time: 
0:00:00.184 user=mapper database=psma0207 host=192.168.69.1 port=54830

A normal connection with "psql -U mapper -h 192.168.69.100 psma0207" 
seems to work ok for normal queries. Am I right in thinking this is 
related to the use of postgis queries?

Still trying to figure this out. :-)


Regards,
David