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

[Steven De Vriendt]

Frank,

Thanks for answering...I have added 2 lines to my ph_hba.conf file:

host	 all	     all	 80.201.239.208/32	 md5 (external)
host	 all	     all	 192.168.2.2/32	       md5 (internal)

that's it.
I don't see the "missing" table in PgAdmin (localhost:5432)
Yet, when I use Mapserver
using the dyndns-parameters I can see my map popping up...




On 4/24/07, Frank Koormann <frank.koormann at intevation.de> wrote:
> * 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
>