Allow to connect to postgresql from another node

[stephdl]

Actually ns8-postgresql can be used only from the node, you install the webserver and the database on the same node, the idea would be nice if we could have a database in the cluster and a webserver on another node

Proposed solution

I propose to allow in the pod to connect from outside of the node, we need to get a stronger password for the user and also review the way how pgadmin connect to postgresql (linux socket for example)

Alternative solutions

do nothing, the database and the webserver must be on the same node

[stephdl]

QA: help to verify asked to https://community.nethserver.org/t/ns8-postgresql-needs-testers/23918

first install with two nodes

• add-module ghcr.io/nethserver/postgresql:1.0.6-dev.1
• Configure the FQDN, the database is up
• you can connect to pgadmin with admin@nethserver.org/Nethesis,1234 from the FQDN
• Pgadmin version is 8.8
• from the other node you can connect from psql (install it on the node) The port can be found in the advanced section of the settings page, the password : cat /home/postgresql1/.config/state/secrets/passwords.env psql -h 10.5.4.1 -U postgres -d postgres -p 20024

upgrade with two nodes

• add-module ghcr.io/nethserver/postgresql:1.0.5
• Configure the FQDN, the database is up
• you can connect to pgadmin with admin@nethserver.org/Nethesis,1234 from the FQDN
• then upgrade api-cli run update-module --data '{"module_url":"ghcr.io/nethserver/postgresql:1.0.6-dev.1","instances":["postgresql1"],"force":true}' the pgadmin can still continue to login and the access is still allowed with admin@nethserver.org/Nethesis,1234 from the FQDN
• pgAdmin can still continue to manages a databse (create user, create database...)
• from the other node you can connect from psql (install it on the node) The port can be found in the advanced section of the settings page, the password : cat /home/postgresql1/.config/state/secrets/passwords.env psql -h 10.5.4.1 -U postgres -d postgres -p 20024