Skip to content

Instantly share code, notes, and snippets.

@ststeiger

ststeiger/hmail.sql

Created May 15, 2023 11:54
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save ststeiger/a2a1cd25b5fd600f235d5fdeffc10a32 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save ststeiger/a2a1cd25b5fd600f235d5fdeffc10a32 to your computer and use it in GitHub Desktop.
Download ZIP
Create hmail user on postgresql
Raw
hmail.sql
CREATE ROLE hmail WITH SUPERUSER LOGIN PASSWORD 'TOP_SECRET';
SELECT rolpassword FROM pg_authid WHERE rolname = 'hmail'
SELECT pg_reload_conf();
-- /etc/postgresql/15/main/postgresql.conf
-- #password_encryption = scram-sha-256 # scram-sha-256 or md5
-- #password_encryption = md5
-- password_encryption = scram-sha-256
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment