PostgreSQL contrib packages, phpPgAdmin
-
"The postgresql addon whitelists the hstore and pg_trgm extensions to be installable by the database owner." - https://cloudron.io/documentation/custom-apps/addons/#localstorage.
Both hstore and pg_trgm are part of postgresql contrib, why other contrib extensions can't be used (btree_gist and unaccent are two more extension that I need to install )?How a postgresql database can be managed via a GUI (eg in a web browser using phpPgAdmin - or using PgAdmin via a ssh tunnel connection )?
-
@b247_eu The docs are out of date. We enabled the extensions you want in 5.5 - https://blog.cloudron.io/cloudron-5-5-released/ . unaccent was enabled in 5.3 - https://blog.cloudron.io/cloudron-5-3-released/
-
I have updated the docs - https://cloudron.io/documentation/custom-apps/addons/#postgresql
@b247_eu For the postgres access, we have to build a custom app. Something like https://git.cloudron.io/cloudron/php7.3-postgres-app/ . You can learn how to build/install a custom app here - https://cloudron.io/documentation/custom-apps/tutorial/