can't connect to postgresql using pygresql

Lee Harr missive at frontiernet.net
Tue Sep 11 23:38:02 CEST 2001


On 11 Sep 2001 13:24:26 -0700, rdack <rdacker at pacbell.net> wrote:
> rdacker at pacbell.net (rdack) wrote in message news:<644f6688.0109110958.284cc26d at posting.google.com>...
>> using pygresql-3.2, postgresql-7.1.3, mac os x 10.0?, g4
>> 
>> i can import _pg, but get error on connect:
>> >>>db=_pg.connect('tt1', 'localhost')
>> _pg.error: PQconnectPoll() -- connect() failed: Connection refused
>>         Is the postmaster running (with -i) at 'localhost'
>>         and accepting connections on TCP/IP port 5432?
>> 
>> port# problem? how do i determine what port postgresql is waiting on?
>> could it be a path problem? i can run psql and see my db from the
>> directory python is running from.
>> 
>> anything else i could check?
> 
> that is the default port for postgresql. 
> i tried:
>>>>db=_pg.connect('tt1')
> 
> and that worked. whew!
> it didn't like 'localhost'?


By including the 'localhost' you would be trying to connect over
a TCP/IP socket rather than a unix domain socket.

To make that work, you would need to restart the postmaster and
use the -i flag.

Be aware of the security implications of doing that.




More information about the Python-list mailing list