Changes between Version 10 and Version 11 of UsersWikiMakeCheckConsiderations

Timestamp:

Jul 18, 2009, 8:21:31 PM (15 years ago)

Author:

robe

Comment:

—

UsersWikiMakeCheckConsiderations

@@ -20 +20 @@
 export PGUSER=postgres 
 
+
 b. Depending on how you did your make install of geos and proj, they might not be located in a place accessible by the PostgreSQL install.  For windows users, you want the libgeos-3-1-1.dll, libgeos_c-1.dll,libiconv-2.dll and libproj.dlls to be located in the bin folder of your PostgreSQL install.
 
@@ -25 +26 @@
 
 dropdb postgis_reg
+
+
+2. '''Security Obstacles '''
+
+a. Verify that your pg_hba.conf in the data folder of your test PostgreSQL install and that it allows trust local.  So should look something like below (and should be the top most rule).  This will save you many hassles and is perfectly secure if you trust everyone logging into the box.  If not then you might want to make trust ident (and then do a su postgres for testing)
+
+host    all         all         127.0.0.1/32          trust
+
+b. su postgres is allowed for Linux/Unix users, but if you prefer that more secure route, then your above should look like below which is the default for Ubuntu.
+
+host    all         all         127.0.0.1/32          ident
+
+c. To test using postgres account -- make sure you are logged in as a super user e.g. root and do a  but before this will work, you need to make sure the regress test folder you have allows postgres access.  so
+chmod 777 regress  (you may need to specify the full path if you are not in the postgis source root)
+su postgres
+