Is there any way to find out the password of a user in Postgres?

Question

PostgreSQL

Good day.
I inherited a server with a bunch of databases, and I only have a password from the postgres OS user.
Is there any way to find out the user's password in Postgres?
Don't give up, just find out.
I know that you can just create another one with full privileges, but here it's just curiosity at play :)

Answer 1

Passwords are most likely saved as md5. The scram-sha-256 method appeared only in 10 and including the 12 release is not yet used by default (there are no problems with the database, the community gives time to implement this protocol in client libraries so that it doesn’t work out like with mysql 8.0).
The md5 password hashes can be found in the pg_authid system catalog table, counted as
That is, it is impossible to recover the original password. You can try to find a collision for the hash.