Well, I don't know if you're gonna believe this, but:<br><br>[root@niceguy cgi-bin]# python<br>Python 2.3.4 (#1, Jan 9 2007, 16:40:09) <br>[GCC 3.4.6 20060404 (Red Hat 3.4.6-3)] on linux2<br>Type "help", "copyright", "credits" or "license" for more information.
<br>>>> import psycopg2<br>>>> db = psycopg2.connect("dbname=test user=postgres")<br>>>> print db.status<br>1<br><br>Bam, connected as root. So, I go into PostGIS.py, and edit the connect line to:
<br><br>def begin (self):<br> self.db = psycopg2.connect("dbname=test user=postgres")<br><br><br>and....I still get permission denied<br>I checked my pg_hba.conf:<br># TYPE DATABASE USER CIDR-ADDRESS METHOD
<br># "local" is for Unix domain socket connections only<br>local all all trust<br># IPv4 local connections:<br>host all all <a href="http://127.0.0.1/32">
127.0.0.1/32</a> trust<br># IPv6 local connections:<br>host all all ::1/128 trust <br><br>local was set to all/all/trust. I created a user, granted permissions, and then specified user=ed in the dsn. I'm not sure if this is much different than user=postgres, but they both still gave me permission denied.
<br><br>So, I guess I'll start looking into reinstalling postgres with hopefully some looser permissioning.<br><br>Thanks again.<br>-Ed<br>