[PostgreSQL]
dbname=web
No user name?
2001-06-19 14:05:24 [22300] DEBUG: connection: host=[local] user=www-data database=web 2001-06-19 14:05:43 [22300] ERROR: testtable: Permission denied.
With PostgreSQL, operating system users don't get access automatically. You must create a PostgreSQL user to connect as (defaults to OS user) and grant privileges. According to messages in the PostgreSQL list archive "www-data" is a special case, since PostgreSQL doesn't allow "-" in user names. I'm not sure if this still applies, since you mention a database user "web-data". Just search the list on http://fts.postgresql.org/db/mw/ with "permission denied". E.g.: http://fts.postgresql.org/db/mw/msg.html?mid=53327 http://fts.postgresql.org/db/mw/msg.html?mid=30785 And this of course (URL of local mirror): http://postgresql.demunnikservices.nl/users-lounge/docs/7.1/admin/user-manag .html http://postgresql.demunnikservices.nl/users-lounge/docs/7.1/admin/privileges .html Regards, René Pijlman