PostgreSQL on NS7

postgresql
v7

(Dominik) #1

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


Howto install Odoo 10
(Alessio Fattorini) #2

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


(Dominik) #3

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 :smiley:


So, what are you working on? - 28 Nov 17
(Stéphane de Labrusse) #4

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 :stuck_out_tongue:


(Dominik) #5

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


(Dominik) #6

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

… damn I am tired … need another holidays :wink:


(Dominik) #7

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.


(Alessio Fattorini) #8

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


(Dominik) #9

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