Re: [GENERAL] pg_hba.conf and crypt - Mailing list pgsql-general

Kevin Lo wrote:

  >Hi, Oliver,
  >
  >I follow your instructions to do on my local machine, edit the file
  >pg_hba.conf:
  >
  >local        all                                         password
  >host         all   127.0.0.1     255.255.255.255         crypt
  >
  >then I connect with psql, use the -u option, I got the following errors:
  >
  >% psql -u
  >Username: postgres
  >Password:
  >
  >User authentication failed
  >Connection to database 'postgres' failed.
  >User authentication failed

You must set a password for postgres before you change pg_hba.conf, using
`ALTER USER postgres WITH PASSWORD xxxxx'.  It sounds as if you haven't
done this.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
               PGP key from public servers; key ID 32B8FAA1
                 ========================================
     "If it is possible, as much as it depends on you, live
      peaceably with all men."        Romans 12:18