Re: Python, MacOSX & PostgreSQL - Mailing list pgsql-novice

From Nathan Wilson
Subject Re: Python, MacOSX & PostgreSQL
Date
Msg-id Pine.GSO.3.95.1020104170221.7844E-100000@hollywood.cinenet.net
Whole thread Raw
In response to Re: Python, MacOSX & PostgreSQL  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Thanks for the reply.  The problem was that I wasn't giving postmaster
the '-i' flag.  Thanks to Aarni for suggesting this solution.

Enjoy!
-Nathan

On Fri, 4 Jan 2002, Tom Lane wrote:

> Nathan Wilson <velosa@cinenet.net> writes:
> > I got all the pieces compiled (Python 2.2b3, MacOSX 10.1, PostgreSQL
> > 7.2b3, mx.DateTime 2.0.2).  Python and PostgreSQL are both working, but
> > when I try to connect to the DB from Python I get 'Connection refused' and
> > it asks if the server is accepting TCP/IP connections on port 5432.  If I
> > give psql that as the explicit port it does just fine.
>
> Is it possible that in the Python case, PG sees the connection as coming
> from your actual IP address and not from 127.0.0.1?  You might try
> adding an entry to pg_hba.conf for your machine's IP address.
> (Don't forget that 7.2 requires you to SIGHUP the postmaster to get it
> to notice pg_hba.conf changes.)
>
>             regards, tom lane
>



pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Python, MacOSX & PostgreSQL
Next
From: "Daniel Cer"
Date:
Subject: Bytea