Seeking PyGreSQL help - Mailing list pgsql-interfaces

From Alastair G. Hogge
Subject Seeking PyGreSQL help
Date
Msg-id 200308051816.06256.agh@tpg.com.au
Whole thread Raw
Responses Re: Seeking PyGreSQL help  ("D'Arcy J.M. Cain" <darcy@PyGreSQL.org>)
List pgsql-interfaces
Hello,

I'm running PostgreSQL-7.3.3_1 on FreeBSD 5.0-CURRENT. I'm trying to use 
python to interface with my database. I'm using Python-2.3 and 
py23-PyGreSQL-7.3.3_1 from the FreeBSD ports tree.

My problem is when I try to connect to the database.
Following is how the problem occurs:
<error>
#python
>>>import _pg
>>>db = _pg.connect("mydb", "myhost")
Traceback (most recent call last): File "<stdin>", line 1, in ?
_pg.error: could not connect to server: Connection refused       Is the server running on host myhost and accepting
 TCP/IP connections on port 5432?
 
</erro>

I know my database is working because when I load it up with psql all appears 
ok. I can even add and retrive information.

I'm only just starting out in Python and PostgreSQL so any help would be much 
appreciated.

Thanks in advance
-Al



pgsql-interfaces by date:

Previous
From: Frank van Vugt
Date:
Subject: Fwd: Re: Multi-threaded user app segfaults when using libpq with separate connections
Next
From: "Alastair G. Hogge"
Date:
Subject: Re: Seeking PyGreSQL help