Synology NAS's provide a multimedia server backed by a PostgreSQL database. You can connect to that database from an SSH session:
sudo su - su - postgres psql mediaserver postgres
Now, I'd love to be able to connect to the database from any computer on my home network, e.g. using pgAdmin, rather than through an SSH terminal. My NAS is not exposed to the Internet and is behind my router's firewall, so I only need to open this to computers on my home network.
Can anyone guide me on how to get there? I have no knowledge whatsoever on PostgreSQL, as I'm more experienced with MySQL.