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

Reply via email to