Add an option to allow remote connections to postgresql

[leonarf]

Hello, I want to transfer some tables from a postgresql server hosted on azure/Micro$oft to a postgresql selfhosted on a VPS with Yunohost. To do so, I can use the CLI pg_dump utilitary to dump some table from azure. And I would like to use the CLI utilitary psql to upload these dump to the Yunohost postgresql. But by default, the postgresql database is not accessible remotely. I installed the app PgAdmin on my Yunohost and it works well, but it access it as localhost and I don't know how to allow remote connection other than modifying some postgresql configuration text file using ssh :-/

I hope the feature seems useful to other people than me :-)

PS : thanks to @Salamandar for the chat, and the advise to write down my feature request here 😸

Edit : I've succeeded allowing remote connection using the following guide : https://tecadmin.net/postgresql-allow-remote-connections/ modifying only two files : /etc/postgresql/13/main/pg_hba.conf and /etc/postgresql/13/main/postgresql.conf

In the first one, it's possible to only allow specific user to specific database. Possibility that I used and would like to include in feature demand. In the second file, it's possible to limit access to not all IP. I didn't use this possibility, hence I don't include it in my feature demand :-)

Being able to restart the postgresql service, and open port 5432 in the firewall using the YunoHost Admin Panel was really convenient. Thank you for making this part already very easy.