BTW, 'trust' is a *very* bad idea. 'ident sameuser' checks that your Unix user name and DB user name are identical, which is usually what you want. Thus, to acess the database as superuser, you need to use
sudo -u postgres psql template1 Using 'psql -U postgres template1' will *not* work. -- PostgreSQL doesn't allow local access https://launchpad.net/bugs/81249 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs