I am trying to connect to my PostGIS database with some success.
One hiccup is that OGR will not connect to my server from a remote machine, though QGIS can connect to it just fine from that same machine.
Here is the connection string I'm using:
ogrinfo -ro PG:"host='machineName' port='5432' user='userName' dbname='postgisDB'"
This connection works in the following scenarios:
- Connect using 'localhost' from PostGIS server machine
- Connect using 'machineName' from PostGIS Server machine
- (as stated) Connect using 'machineName' through QGIS from remote machine
I've tried adding a fully qualified domain name, as well as a password, to no avail.