[Bug 81249] Re: PostgreSQL doesn't allow local access

[Martin Pitt]

I am closing this bug because the default is as intended.

** Changed in: postgresql-8.1 (Ubuntu)
   Status: Needs Info => Rejected

-- 
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

[Bug 81249] Re: PostgreSQL doesn't allow local access

[Martin Pitt]

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

[Bug 81249] Re: PostgreSQL doesn't allow local access

[Martin Pitt]

The default pg_hba entries are:

local   all postgres  ident sameuser
local   all all   ident sameuser
hostall all 127.0.0.1/32  md5
hostall all ::1/128   md5

Thus local access should work just fine. How did you install postgresql
and what did your pg_hba.conf look like?

** Changed in: postgresql-8.1 (Ubuntu)
   Status: Unconfirmed => Needs Info

-- 
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