0

Using standard UBUNTU 16 LTS env. and used enterprisedb.com/downloads PostgreSQL Setup Wizard to install, an "official suggestion" here... So supposing it is plug-and-play.

But the basic (for a "plug and play") not runs (!), psql -h localhost -U postgres

psql: FATAL: password authentication failed for user "postgres" FATAL: password authentication failed for user "postgres"

The user postgres exist, and even after sudo passwd postgres to "postgres", the same error.

Peter Krauss
  • 13,174
  • 24
  • 167
  • 304
  • `sudo passwd postgres` changes OS user password, not db... `alter user postgres password'blah'` is for db – Vao Tsun Mar 27 '17 at 19:57
  • what you see after `sudo su - postgres` and then `psql` with no arguments?.. – Vao Tsun Mar 27 '17 at 19:59
  • Thanks @VaoTsun. Yes... But during installation I say "postgres postgres" ... To do "all by terminal again" is not a plug-in-play... it is ugly. I am looking for what is wrong in my concept of plug-in-play... I think it is a bug to be reported in case there are no real solution. – Peter Krauss Mar 27 '17 at 20:11

0 Answers0