PostgreSQL on NS7

[des (Dominik)]

NethServer Version: 7.4.1708
Module: nethserver-postgresql

Hello Nethserver tribe. I need to install PostgreSQL server but can anyone tell me which version would be installed via nethserver-postgresql module ?
yum info nethserver-postgresql doesn’t tell much… but yum info postgresql tells me version 9.2
I know how to install i.e 9.4-9.6 but will it work in our environment ? Or i should tweak it somehow?

i have allready read this

Postgresql on Nethserver

Hello, I installed postgresql-9.4 and phpPgAdmin from the epel repo, and both work fine. But the services list in the web gui always states that postgres is stopped. Presumably there is a mismatch between the nethserver-postgresql package which refers to the old version 8.4 and the actually installed version 9.4. Can anybody tell where in the system the status information of services is taken from or what has to be adjusted so that postgesql is correctly shown as enabled? Thanks.

[alefattorini (Alessio Fattorini)]

@giacomo did something with Mattermost, take a look at:

gsanchietti/nethserver-mattermost

[des (Dominik)]

Ok, i finally manage to install PostgreSQL in default 9.2 version, but i cannot connect to that server from the phpPgAdmin page

What i have done:

1. install nethserver-postgresql

2. install nethserver-phppgadmin from @stephdl repository

3. enabled PostgreSQL on firewall

4. added in pg_hba.conf
   #IPv4 local connection
   host all all 0.0.0.0/0 trust

5. changed in postgresql.conf
   listen_addresses = ‘localhost’ →listen_addresses = ‘*’

6. in config.inc.php changed
   $conf[‘servers’][0][‘host’] = ‘localhost’ →$conf[‘servers’][0][‘host’] = ‘IP ADDRESS’
   $conf[‘extra_login_security’] = true →$conf[‘extra_login_security’] = false

And finally i was able to connect via phpPgAdmin

[stephdl (Stéphane de Labrusse)]

Don’t understand, just tried and it works out of the box, the user is admin and the password is in /var/lib/nethserver/secrets/pgadmin

why did you need to fully open phppgadmin and PostgreSQL ?

From a point of view of security, I’m not sure it is good

[des (Dominik)]

i was trying to connect with user “postgres” - default user - maybe this was my mistake…

[des (Dominik)]

I was blind somehow - i did not see at your manual the user name : “admin”

… damn I am tired … need another holidays

[des (Dominik)]

Thank you @stephdl and @mrmarkuz for guiding me in setting up PostgreSQL on NS7.

Now I will try to revert those settings that I have made and I will see how it works.

[alefattorini (Alessio Fattorini)]

You should write a new #howto it would be very helpful

[des (Dominik)]

Good idea … I will get all my notes and write it down here …