On Tuesday, 05 August 2003 19:10, D'Arcy J.M. Cain wrote:
myhost' from the command line? I suspect that your problem will reverse.
Bt default PostgreSQL does not run on a TCP/IP port. You have to turn that
on from the config file. Don't forget pg_hba.conf if you change that.
On Tuesday 05 August 2003 04:16, Alastair G. Hogge wrote:
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
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?
What happens if you do 'db = _pg.connect("mydb")' from python or 'psql -hI'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")
db = _pg.connect("mydb", "myhost")
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?
myhost' from the command line? I suspect that your problem will reverse.
Bt default PostgreSQL does not run on a TCP/IP port. You have to turn that
on from the config file. Don't forget pg_hba.conf if you change that.
Thanks for help. The problem was in pgsql/data/postgresql.conf. I needed to
change "#tcpip_socket = false" to "tcpip_socket = true"
I know am able to access my database from within Python, hwover when I try the
python an cgi script I get an internet server error. Is there more options I
should know about?
