Error code
PostgreSQL 28P01
POSTGRESQL28P01
Database Error Code· An error code returned by a database server such as PostgreSQL or MySQL.
What it means
invalid_password — authentication failed due to a wrong password.
How to fix it
- Verify that the correct password is being used and that environment variables or configuration files have not been stale-cached.
- Reset the role password with ALTER ROLE <name> PASSWORD '<new>' if the password has been lost.
- Check pg_hba.conf to confirm the expected authentication method (md5/scram-sha-256) matches what the client sends.
Not affiliated with PostgreSQL. Answer summarized from the manufacturer's manual linked above; consult that source for the authoritative procedure.
More PostgreSQL codes
- 08001sqlclient_unable_to_establish_sqlconnection — initial connection refused
- 08006connection_failure — the connection to the server broke
- 0A000feature_not_supported — the requested feature is not implemented
- 22001string_data_right_truncation — a value is too long for the column
- 22003numeric_value_out_of_range — a number exceeds the column's storage range
- 22P02invalid_text_representation — a string could not be parsed into the target type
- 23502not_null_violation — a required column received no value
- 23503foreign_key_violation — the referenced row does not exist
- 23505unique_violation — a row with this key already exists
- 23514check_violation — a row failed a table check constraint
- 25P02in_failed_sql_transaction — the current transaction has already failed
- 28000invalid_authorization_specification — the role is not permitted to connect