Home > mailing lists

postgres connection problem via python pg DBI - Mailing list pgsql-general

From	Dan Joo
Subject	postgres connection problem via python pg DBI
Date	June 5, 2008 23:19:06
Msg-id	4676DF8318F32F4AB7E98BCD9BC90628F3E153@agq-ex01.agraquest.int Whole thread Raw
Responses	Re: postgres connection problem via python pg DBI ("Dan Joo" <djoo@agraquest.com>) Re: postgres connection problem via python pg DBI (Colin Wetherbee <cww@denterprises.org>)
List	pgsql-general

Hi all,

I have a problem connecting to postgres via the python pg module ONLY from the cgi-scripts.

The command is:

db=pg.connect('aqdev','localhost',5432,None,None,'postgres',None)

From the commandline the connection works great, but from a cgi-script it barfs with the following message:

InternalError: could not create socket: Permission denied

Does anyone have any idea how I can get around this issue?

Thanks a bunch!

From: Jason Long
Date: 05 June 2008, 22:57:15
Subject: Re: full vacuum really slows down query

From: "Dan Joo"
Date: 05 June 2008, 23:35:04
Subject: Re: postgres connection problem via python pg DBI