[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.