I want to set up some pretty traditional permissions: each user can access his own db, and superuser can access all the dbs.
So far I got the first part right (I think). I edited pg_hba.conf, and changed this:
local all all host all all host all all
local sameuser all host sameuser all host sameuser all
But now I can't access any db with my superuser. I tried adding "localhost all myuser" but doesn't seem to work.