Re: postgres user
Blake Barnett wrote:
>Call me crazy, but I can't seem to get into the database anymore. The
>postgres user didn't have a password before and it won't accept a blank
>password anymore. The postgres user was the only user and so there's no way
>to get in to modify him. Am I just being dense here? Is there a problem
>with the package? If it's not a package issue I'll post to the Debian
>lists..
Check the README files!
The default access policy is now:
local all password
host all 127.0.0.1 255.0.0.0 ident sameuser
(in /etc/postgresql/pg_hba.conf)
In other words, connections through a Unix socket need a password;
TCP/IP connections through localhost allow you to log on without a
password as the postgresql user whose name is the same as your login.
Set and export PGHOST=localhost to take advantage of this.
The reason for the change is to improve the default security of PostgreSQL.
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"Nay, in all these things we are more than conquerors
through him that loved us." Romans 8:37
Reply to: