Public bug reported: Binary package hint: postgresql-8.1
After the installation I cannot access locally to the server. For example $ psql template1 postgres will say I have no persmissions. I have created a user with "createuser" program but also this one was not allowed to access the server. I think the problem is in /etc/postgres/8.1/main/pg_hba.conf. I fixed the problem by replacing in that file the line saying: local all postgres ident sameuser with one saying: local all all trust I'd default for a default configuration allowing at least local user postgres. ** Affects: postgresql-8.1 (Ubuntu) Importance: Undecided Status: Unconfirmed -- 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