On Mon, Nov 26, 2012 at 9:00 AM, Daniel J. Luke <[email protected]> wrote: > On Nov 25, 2012, at 5:12 PM, Stephen Rasku <[email protected]> wrote: >> >> I did "sudo psql90" and it still asked me for a password: >> >> $ sudo psql90 >> Password: >> psql90: FATAL: password authentication failed for user "root" >> $ sudo psql90 -U postgres >> Password for user postgres: >> psql90: FATAL: password authentication failed for user "postgres" > > ... probably because you told it to (hint: check your pg_hba.conf file). You > can also set up a ~/.pgpass file if you want to be able to psql (as any > postgres user) without typing the password. I believe the default pg_hba.conf > file is set up to allow access without any password.
I edited pg_hba.conf to "trust" local connections. After I did that, I was able to set the password to something I knew and I could configure remote connections to use the password. Thanks, Stephen _______________________________________________ macports-users mailing list [email protected] http://lists.macosforge.org/mailman/listinfo/macports-users
