I have a table with about 6,000 records. Each record includes a column named user_name whose value is a crypt generated hash.
When I run this sql:
select entity_id from mytable where user_name = crypt('tdriver', user_name) and last_name = 'Test';
I get this result: entity_id = 33, which is correct.
When I run this sql:
select entity_id from mytable where user_name = crypt('tdriver', user_name);
I get this result
ERROR: invalid salt
I am using Postgresql 13. My guess is that Postgresql is corrupted and I will need to reinstall it.