Hacker News new | ask | show | jobs
by mvanbaak 1939 days ago
pgadmin ;-P
2 comments

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.
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...

Perhaps it’s better to only listen to localhost and connect through a SSH proxy connection
Or DataGrip if you already have a JetBrains licence.