Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Search
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Brand Logo

Cloudron Forum

Apps | Demo | Docs | Install
  1. Cloudron Forum
  2. Support
  3. PostgreSQL contrib packages, phpPgAdmin

PostgreSQL contrib packages, phpPgAdmin

Scheduled Pinned Locked Moved Support
3 Posts 2 Posters 682 Views 2 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • B Offline
    B Offline
    b247_eu
    wrote on last edited by
    #1

    "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 )?

    1 Reply Last reply
    0
    • girishG Offline
      girishG Offline
      girish
      Staff
      wrote on last edited by
      #2

      @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/

      1 Reply Last reply
      0
      • girishG Offline
        girishG Offline
        girish
        Staff
        wrote on last edited by
        #3

        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/

        1 Reply Last reply
        0
        Reply
        • Reply as topic
        Log in to reply
        • Oldest to Newest
        • Newest to Oldest
        • Most Votes


        • Login

        • Don't have an account? Register

        • Login or register to search.
        • First post
          Last post
        0
        • Categories
        • Recent
        • Tags
        • Popular
        • Bookmarks
        • Search