[postgis-users] PostGIS/PostGres Configuration

Paul Ramsey pramsey at cleverelephant.ca
Mon Mar 15 12:14:57 PDT 2010


Steffan,
Leave your localhost entry in place, it's useful. Make a copy of the
line and edit the copy.
Change localhost to 192.168.0.0 and change 32 to 16.
Ensure that listen_addresses = '*' in your postgresql.conf file.
Restart the database
Try again.
P

On Mon, Mar 15, 2010 at 11:50 AM, Steffan Chmuryk
<schmuryk at icisociety.ca> wrote:
> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



More information about the postgis-users mailing list