Postgres SQL Statements #postgres

Postgres Auth Commands

SHOW password_encryption;

SELECT rolpassword from pg_authid where rolname = '{your-db-user-name}';

ALTER USER "{your-db-user-name}" with password '{your-new-db-password}';

SET password_encryption  = 'scram-sha-256';
SET password_encryption  = 'md6';

SHOW password_encryption;
SELECT * FROM pg_hba_file_rules();

SELECT pg_reload_conf();

-- to verify the settings are like you want:

SHOW password_encryption;
SELECT * FROM pg_hba_file_rules();

-- change the password

\password myuser