Postgres password authentication fails

by

As shown in the latest edit, the password is valid until 1970, which means it’s currently invalid.
This explains the error message which is the same as if the password was incorrect.

Reset the validity with:

ALTER USER postgres VALID UNTIL 'infinity';

In a recent question, another user had the same problem with user accounts and PG-9.2:

PostgreSQL – Password authentication fail after adding group roles

So apparently there is a way to unintentionally set a bogus password validity to the Unix epoch (1st Jan, 1970, the minimum possible value for the abstime type). Possibly, there’s a bug in PG itself or in some client tool that would create this situation.

EDIT: it turns out to be a pgadmin bug. See https://dba.stackexchange.com/questions/36137/

More Related Contents:

  1. Why the “Group BY” by month didn’t work? [closed]
  2. What to do with null values when modeling and normalizing?
  3. Postgres: INSERT if does not exist already
  4. Truncating all tables in a Postgres database
  5. How can I drop all the tables in a PostgreSQL database?
  6. postgres default timezone
  7. How to change PostgreSQL user password?
  8. quick random row selection in Postgres
  9. Running PostgreSQL in memory only
  10. Copy a table from one database to another in Postgres
  11. Can I automatically create a table in PostgreSQL from a csv file with headers?
  12. User defined variables in PostgreSQL
  13. How to add an auto-incrementing primary key to an existing table, in PostgreSQL?
  14. Postgres query optimization (forcing an index scan)
  15. psql: FATAL: database “” does not exist
  16. Difference between timestamps with/without time zone in PostgreSQL
  17. Postgres FOR LOOP
  18. Omitting the double quote to do query on PostgreSQL
  19. Strange behaviour in Postgresql
  20. Postgres: Distinct but only for one column
  21. In PostgreSQL, how to insert data with COPY command?
  22. Cursor based records in PostgreSQL
  23. How to add column if not exists on PostgreSQL?
  24. Docker – Postgres and pgAdmin 4 : Connection refused
  25. Configuration parameter work_mem in PostgreSQL on Linux
  26. How to work with PGpoint for Geolocation using PostgreSQL?
  27. How to delete an enum type value in postgres?
  28. Why unsigned integer is not available in PostgreSQL?
  29. now() default values are all showing same timestamp
  30. What’s the difference between pg_table_size, pg_relation_size & pg_total_relation_size? (PostgreSQL)

Leave a Comment