Issue Posgresql pgadmin from admin.

[keff]

PostgreSQL installed from Plesk Installer. System is Debian 8.7. Using pgadmin from Tools&Settings -> Databases Servers causing error on left column.
"Error loading all_db.php?action=tree&subject=server&server=%3A5432%3Aallow (200: OK)

Using pgadmin from user account with access only user databases work as expected.

Aditional Info: after install PostgreSQL, I need to comment out one line in /etc/postgresql/9.6/main/pg_hba.conf such as:
#local samegroup all password #Added by Plesk
Only when I comment out this line postgresql start normally. With this line active postgresql start cause problems like this:

Connection match to line 2 pg_hba.conf: "local samegroup all password #Added by Plesk"
2017-01-30 21:19:24 CET [11334-1] postgres@postgres KATASTROFALNY: autoryzacja hasłem nie powiodła się dla użytkownika "postgres" (wrong password authorization for user postgres)
2017-01-30 21:19:24 CET [11334-2] postgres@postgres SZCZEGÓŁY: Nie zgadza się hasło użytkownika "postgres". (wrong postgres user password)

I try to change postgres password and register again password in Plesk, with no luck. Pgadmin still no show list of databases.

How to repair this?

 

[IgorG]

I see this thread in Plesk 12.x subforum, therefore I suppose that you are talking about Plesk 12.5 and PostgreSQL 9.6, right?
But according to software requirements, only PostgreSQL 9.4 is supported in Plesk 12.5 - http://docs.plesk.com/release-notes/12.5/software-requirements/#s4-2-1
Anyway, try to reinstall it with

# plesk installer --select-release-current --remove-component postgresql
# plesk installer --select-release-current --install-component postgresql

 

[keff]

Installer installing Postgresql-9.6

Getting bootstrapper packages to installation list:
[2017-01-31 08:36:10.696844]   skip package 'pp12.5.30-bootstrapper-12.5.30-debian8.0.build1205160608.09.amd64' from component panel - there is same or newer version of this package is installed (in system pp12.5.30-bootstrapper-12.5.30-debian8.0.build1205160608.09.amd64)
[2017-01-31 08:36:10.696887]   skip package 'sw-engine-cli-2.16-2.16.2-debian80.201510051442.amd64' from component panel - there is same or newer version of this package is installed (in system sw-engine-cli-2.16-2.16.2-debian80.201510051442.amd64)
[2017-01-31 08:36:10.696920] Following bootstrapper packages will be installed: (empty)
[2017-01-31 08:36:10.696935]  ----------------
[2017-01-31 08:36:10.696947] Getting packages to installation list:
[2017-01-31 08:36:10.696986] Following packages will be installed: postgresql-9.4+165+deb8u2   
[2017-01-31 08:36:10.697002]  ----------------
[2017-01-31 08:36:10.697030] Sprawdzanie, czy zależności pakietu są rozwiązane.
[2017-01-31 08:36:10.697095] autoinstaller: read output of DEBIAN_FRONTEND=noninteractive LANG=C apt-get --assume-yes --show-upgraded --purge --no-reinstall -o APT::Get::List-Cleanup=true -o Dpkg::options::=--force-confdef -o Dpkg::options::=--force-confold  -o APT::Get::AllowUnauthenticated=false -o Acquire::Retries=3  -t 'jessie*'  --just-print install postgresql
[2017-01-31 08:36:11.518860]   add to install list postgresql-client-common-178~bpo8+1
[2017-01-31 08:36:11.528301]   add to install list postgresql-client-9.6-9.6.1-2~bpo8+1
[2017-01-31 08:36:11.537541]   add to install list postgresql-common-178~bpo8+1
[2017-01-31 08:36:11.546765]   add to install list postgresql-9.6-9.6.1-2~bpo8+1
[2017-01-31 08:36:11.565081]   add to install list postgresql-contrib-9.6-9.6.1-2~bpo8+1
[2017-01-31 08:36:11.698403] (regen obsoletes cache)
[2017-01-31 08:36:11.698576] Check package set before installation 
[2017-01-31 08:36:11.698855] The following packages from not selected components will be installed because they are required by other components' packages you selected for installation:
[2017-01-31 08:36:11.698925] The following components should be removed due to packages dependencies: ~empty
[2017-01-31 08:36:11.708731] Instalowanie pakietów
[2017-01-31 08:36:11.712317] Bootstrapper has finished action (exec time: 0 sec.): parent_name='PLESK_12_5_30', sequence='prep', stage='execute', sequence_order='-1', operation='install', exec_cmd='touch /tmp/pp-bootstrapper-mode.flag; touch /var/lock/parallels-panel-maintenance-mode.flag; rm -f /var/lock/parallels-panel-upgrade-failure.flag; :'', m_arch='', output: ~empty

 

[IgorG]

Do you have enabled any third-party repositories?

 

[keff]

That is default PLESK from OVH installation. Repositories:

#deb http://debian.mirrors.ovh.net/debian/ jessie main
#deb-src http://debian.mirrors.ovh.net/debian/ jessie main

deb http://security.debian.org/ jessie/updates main
deb-src http://security.debian.org/ jessie/updates main

# jessie-updates, previously known as 'volatile'
deb http://debian.mirrors.ovh.net/debian/ jessie-updates main
deb-src http://debian.mirrors.ovh.net/debian/ jessie-updates main

# jessie-backports, previously on backports.debian.org
deb http://debian.mirrors.ovh.net/debian/ jessie-backports main
deb-src http://debian.mirrors.ovh.net/debian/ jessie-backports main

deb http://debian.mirrors.ovh.net/debian/ jessie main contrib non-free
deb-src http://debian.mirrors.ovh.net/debian/ jessie main contrib non-free
deb http://updates.atomicorp.com/channels/tortix-common/debian jessie main