PostgreSQL on NS7

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:

1 Like