Question How to manage a PostgreSQL database in Plesk GUI?

[andiBrandy]

Server operating system version

Ubuntu 22.04.5 LTS

Plesk version and microupdate number

Version 18.0.63 Update #4

I'm quite new to PostgreSQL.
MariaDB can be simply managed in plesk out of the box with phpMyAdmin.
I have now installed a PostgreSQL database and I cannot see buttons to import or export the database, and also nothing for administration.


Is there a quick solution like an extension or some functionality I need to activate in Plesk?

Thank you for your Support

 

[AYamshanov]

https://support.plesk.com/hc/en-us/articles/12377170988567-phpPgAdmin-is-not-available-for-installation-in-Plesk

As an option,

[...]
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.

 

[Maarten]

There is a feature request by the following link to include pgAdmin for Postgres management in Plesk:

Include pgadmin for Postgres management in Plesk

phpPgAdmin support was dropped starting from Plesk Onyx 17.8 This means that Plesk does not have any management tool for Postgres databases shipped with it. I suggest to include pgadmin in Plesk installation since the latest ve rsion of this software (2018-09-06 - pgAdmin 4 v3.3 Released) has...

plesk.uservoice.com

 

[hschneider]

The simplest and most secure method is to install pgAdmin as a docker container.
I made a short HowTo for this (german, pls use Google Translate):

Plesk: PgAdmin als Docker Container installieren

Postgres lässt sich bei Plesk sehr einfach als Systemdienst einrichten, jedoch fehlt ein integriertes Verwaltungstool wie PgAdmin. Dieser Beitrag zeigt, wie du

marketmix.com