Applicable to:
- Plesk Onyx 17.8 for Linux
Symptoms
-
Plesk Onyx 17.8 is installed.
-
phpPgAdmin is not available for installation in Tools & Settings > Updates and Upgrades > Add/Remove Components page.
-
There is no phpPgAdmin button to log into PostgreSQL instance at the Tools & Settings > Database Servers page.
Cause
phpPgAdmin is deprecated in Plesk 17.8: it is removed from existing installations during the upgrade to Plesk 17.8 and not available for installation via Plesk anymore.
This has been done due to security reasons: phpPgAdmin project has been inactive for the past 3 years, which lead to phpPgAdmin becoming an insecure and unstable application.
Resolution
This feature is not yet implemented in Plesk, vote for this feature request by the following link: Include pgadmin for Postgres management in Plesk.
The top-ranked suggestions are likely to be included in the next versions of Plesk.
As for now, customers who need to edit their database using a web interface can install a stand-alone phpPgAdmin on their websites.
Warning: manual installation of phpPgAdmin is not be supported by Plesk and performed at your own risk.
Comments
6 comments
About the elimination of pgadmin in plesk, we suggest to the plesk team to reconsider the inclusion of pgadmin again, since the latest version of this software (2018-09-06 - pgAdmin 4 v3.3 Released) has just been released, with adequate security. Please consider that to develop large projects, mysql is not an option and remote access to postgree with a remote pgadmin, is complicated (firewall rules, etc). Thanks.
@Arturo Diehl
I would like to draw your attention that phpPgAdmin and pgAdmin are different software.
The latest version of phpPgAdmin was released in 2013 thus it is not shipped with Plesk anymore.
As for pgAdmin inclusion in Plesk installation, I recommend you vote for this on Plesk UserVoice portal:
https://plesk.uservoice.com/forums/184549-feature-suggestions/suggestions/35537077-include-pgadmin-for-postgres-management-in-plesk
phpPgAdmin has had a new release in Dec 2018. They have added official support for PGSQL 9.6, 10, 11, and 12.
Hello @Sysadmin,
The corresponding request about such feature implementation already exists on our User Voice portal:
Include pgadmin for Postgres management in Plesk
Leave your voice as top-ranked suggestions are most probably will be implemented to future product updates
I also updated the article and added the link to the user voice request
Hi, does Plesk Obsidian include support fro either phpPgAdmin or pgAdmin (or other web tool)? I checked the Obsidian docs but could not find a clear answer.
I am thinking if by installing it I can solve a problem with some clients who need a management tool for Postgresql similar to phpmyadmin
Txs
@Paolo Dominoni
Hi,
Plesk Obsidian does not contain phpPgAdmin or pgAdmin. I recommend you to vote for this feature at https://plesk.uservoice.com/forums/184549-feature-suggestions/suggestions/35537077-include-pgadmin-for-postgres-management-in-plesk and follow the Change Log of Plesk Obisidan to be aware of changes in it.
Even though, this feature is not implemented in Plesk, you can install it on your own, the guide is available here:
https://raw.githubusercontent.com/phppgadmin/phppgadmin/master/INSTALL
Please sign in to leave a comment.