Today I upgraded to Postgresql 9.0 and web2py 1.98.2 (on Mac OS X Snow Leopard). To test the environment I created a Login Role and Database in pgAdmin III and entered the following connection string in db.py:
db = DAL('postgres://myusername:mypassword@localhost:5432/mydatabase') Now, when I start up web2py from the terminal I get the following error: Traceback (most recent call last): File "/Library/Python/2.5/site-packages/web2py/gluon/restricted.py", line 192, in restricted exec ccode in environment File "/Library/Python/2.5/site-packages/web2py/applications/init/ models/db.py", line 17, in <module> db = DAL('postgres://myusername:mypassword@localhost:5432/ mydatabase') # if not, use SQLite or other DB File "/Library/Python/2.5/site-packages/web2py/gluon/dal.py", line 3969, in __init__ self._adapter = ADAPTERS[self._dbname](*args) File "/Library/Python/2.5/site-packages/web2py/gluon/dal.py", line 1735, in __init__ raise SyntaxError, "Invalid URI string in DAL" SyntaxError: Invalid URI string in DAL I hope one of you knows how to solve this problem. Kind regards, Annet.