can't connect to postgresql using pygresql
rdack
rdacker at pacbell.net
Tue Sep 11 16:24:26 EDT 2001
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'?
More information about the Python-list
mailing list