[postgis-users] PostGIS/PostGres Configuration

Steffan Chmuryk schmuryk at icisociety.ca
Mon Mar 15 11:50:45 PDT 2010


Hello,

This is my first post, so please go easy ;) 

I have built a PostGIS/PostGres spatial database, and have successfully
imported a shapefile. Now when I try to connect to the database via
Udig, OpenJump, or Qgis, I the following error:

Fatal: no pg_hba.conf entry for host "192.168.x.xxx", user "postgres",
database "postgis1', SSL off (PSQL Exception)

Now I have tried every combination of the following:

* Edit pg_hba.conf so that the default 127.0.0.1/32 is replaced by the
192... ip
* Add another access configuration to the file, so that the 192... ip,
the postgres user, and the database are all included
* Enable the SSL off configuration in the postgres.conf file, and
restart the machine
* I have even explored the JDBC stuff... argh!

The error message in the application (Udig, OpenJump, or Qgis) does not
change. But upon changing the files to reflect any of the above
configurations, I am then unable to connect to the db within pgadminIII,
due to an error in loading the pg_hba.conf file.


Regarding the environment:
* Server used to host MSSQL and SDE;
* Server is Windows Server 2003 (not R2);


Steffan Chmuryk
Technical Services Coordinator, ICIS
www.icisociety.ca
 
Office:   (250) 381-9295
Cell:     (250) 516-2481



More information about the postgis-users mailing list