[postgis-users] Connecting to postgis: localhost <-> dyndns: strange thing

[Frank Koormann]

* Steven De Vriendt <gisaalter at gmail.com> [070424 11:25]:
> I'm running a database on localhost. This database is reachable via a
> dyndns-account.
> I have a strange problem when I connect to my database via these parameters
> 
> host: localhost
> port: 5432
> 
> I get 4 tables, yet when I try to connect with my dyndns:
> 
> host: xxxxx.dyndns.org
> port: 5432
> 
> I get 5 tables ?
> 
> How is this possible, I'm running the database on the exact same pc ??

The PopstgreSQL file pg_hba.conf controls this behavior. PostgreSQL
differentiates between socket connections, local connections via TCP/IP
and external connections via TCP/IP. Seems as if your external sections 
is less restrictive than the local ones.

Regards,

        Frank
 
-- 
Frank Koormann    |   ++49-541-335 08 30    |   http://www.intevation.net/
Intevation GmbH, Osnabrück, DE | Commercial Register Osnabrück, HR B 18998
Managing Directors: Frank Koormann, Bernhard Reiter, Dr. Jan-Oliver Wagner