Applicable to:
- Plesk Onyx 17.8 for Linux
Symptoms
-
Plesk Onyx 17.8 is installed.
-
phpPgAdmin is not available for installation at the Plesk > Tools & Settings > Updates and Upgrades > Add/Remove Components page.
-
There is no phpPgAdmin button to log into PostgreSQL instance at the Plesk > 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
4 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
Please sign in to leave a comment.