[tinus_hn]

It would be great if there was some management GUI for these tasks so you don’t have to look up the syntax for these things that in many deployments you only do once.

[rektide]

both kubernetes operators have some ok user management built in

[mvanbaak]

pgadmin ;-P

[tinus_hn]

This actually looks pretty reasonable, I am going to look into it. First I need to figure out how to open up the server for connections but still limit it, though.

[jhauris]

Look at the pg_hba.conf file (probably something like /etc/postgresql/<version>/main/pg_hba.conf).

https://www.postgresql.org/docs/current/auth-pg-hba-conf.htm...

[tinus_hn]

Perhaps it’s better to only listen to localhost and connect through a SSH proxy connection

[rleigh]

Or DataGrip if you already have a JetBrains licence.