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 [EMAIL PROTECTED] 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