[Zope] ZPyGreSQLDA connection string

Oleg Broytmann phd@phd.russ.ru
Tue, 4 Apr 2000 14:38:18 +0000 (GMT)


On Tue, 4 Apr 2000, Brad Crittenden wrote:
> could someone describe the format for the connection string for
> ZPyGreSQLDA?  i've looked everywhere but cannot find it documented.

   Many database adapters use the followin scheme:
database@host:port user password
   @host and :port and password may be omitted, but I think user must be
included.

> i have a database called 'test' which i can connect to using psql.
> it is running on the default port 5432.  i have also successfully
> connected using the python module.
> 
> the "obvious" connection strings ("test@localhost:5432", etc) don't

   For default settings (localhost and 5432) you may omit these parts, so
just use "test", but add user part:

test www

   (and allow user "www" to access the DB "test" withou password; or
better; use password)

> work.  everything i try when establishing the database gives an
> "Invalid connection string" error.

Oleg.            (All opinions are mine and not of my employer)
---- 
    Oleg Broytmann      Foundation for Effective Policies      phd@phd.russ.ru
           Programmers don't die, they just GOSUB without RETURN.