Re: Python, MacOSX & PostgreSQL

From: Nathan Wilson <velosa(at)cinenet(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Python, MacOSX & PostgreSQL
Date: 2002-01-05 01:03:44
Message-ID: Pine.GSO.3.95.1020104170221.7844E-100000@hollywood.cinenet.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)cinenet(dot)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
>

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Daniel Cer 2002-01-05 18:34:55 Bytea
Previous Message Tom Lane 2002-01-05 00:47:55 Re: Python, MacOSX & PostgreSQL