The following bug has been logged online:
Bug reference: 1978
Logged by: mouse
Email address: mousedrx@gmail.com
PostgreSQL version: 8.0.3
Operating system: Gentoo Linux 2.6.11-r9
Description: connection sinks
Details:
I have: (2) user X which can create databases and (2) database Y created by
X. Y contains some tables, sequences, etc -- data CAN be accessed via psql.
Also: have googled a lot for a proper configuration, thus postgresql.conf
has listen_addresses listening everything ('*') and in pg_hba.conf there is
an entry for my intranet IP address: 192.168.1.0/24 (for any eventuality).
Problem: when using Quantum GIS (http://qgis.org) to connect postgis
database Y, it reports that connection is successful. But, data are not
loaded!
Guide: Same thing (user X, db Y, same data) are on the online www.xyz.com
postgres database running) -- in this case I CAN see layers (tables) in the
qGIS app and load them. Remote configuration is the same adding some
additinal hosts in pg_hba...
Question: what could that be?