## Matthias Apitz (g...@unixarea.de):
> > The documentation on pg_authid has the details:
> > "The MD5 hash will be of the user's password concatenated to their user
> > name."
> > https://www.postgresql.org/docs/12/catalog-pg-authid.html
>
> This is still not exactly what I was looking for. But has an interesting
> detail (salting the role password by adding the role name to it). An
> implementation with UNIX crypt(3) for MD5 would need an additional salt
> like '$1$salt' to encrypt 'sisis123sisis'.
It's not crypt(3). It's "the MD5 hash of the user's password concatenated
to their user name".
Try:
perl -MDigest::MD5 -e 'print("md5" . Digest::MD5::md5_hex("sisis123" . "sisis")
. "\n");'
Regards,
Christoph
--
Spare Space.
