[Zope-DB] Postgresql PoPy 'Invalid Connection String' Error

[santi at zetadb.com]

Try to add the host clause:

user=tim dbname=timsdatabase password=timspassword host=localhost

And, the most important thing, ensure that your pg_hba.conf accepts
connections from localhost using authentication method password:

host    all         all         127.0.0.1         255.255.255.255   password
host    all         all         your.ip           255.255.255.255   password

I'm assuming you have Zope and Postgresql in the same machine.  Otherwise,
just replace localhost and ips for correct values

Cheers

Santi Camps


> I have a Red Hat 9 system running Zope 2.6.1 and have just installed
> PoPy 2.0.7.
> This all works fine, until I try to connect to the database. Then I get
> an 'invalid connection string' error.
> I have searched online and found many people have had the same problem.
> In most cases Postgresql
> was not started with the -i option, thus not accepting outside
> connections.
> But I have started postgresql with this option and I still cannot
> connect.
> My Connection string is as follows:
>
> user=tim dbname=timsdatabase password=timspassword
>
> Any help would be much appreciated.
>
> Thanks
>>From Tim Zegir
>