On 03/17/11 2:29 PM, Joseph Doench wrote:
I have setup a pg database server formy organizationon a cloud
serverusing PG 8.2;
I am trying to provide connections to the db for somemembers using MS
Access. I developed a small MS Access application using Windows
ODBC–it works fine from myhouse.
I havethisline in pg_hba.conf:
Host all mydbuserID 0.0.0.0/0 password
BUT…I cannot re-create the ODBC connection in our organization’s offices!
I have de-bugged by taking my laptop to the office–it will not
connectto the db there–but is ok at my house.
(I have also checked 2 other locations with public wi-fi; could not
connect from either of them)
This seems to berelated to the ISP blockingdata–I have ruled out the
router in the office.
is your home behind a home internet sharing router ? (this might be
built into whatever 'modem' your ISP provided). is the Postgres port
forwarded from the outside world to your server?
in general if your home server is on a private local network address
like 192.168.x.y or 10.x.y.z, then it can't be directly reached from the
internet unless the internet gateway is configured to forward the
service port in question from real.ip.addr:port to local.ip.addr:port
(Postgres uses port 5432/tcp by default)
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
