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. LAMP stack with Postgres

LAMP stack with Postgres

Scheduled Pinned Locked Moved Solved Support
lamppostgresql
7 Posts 4 Posters 1.9k Views 4 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.
  • M Offline
    M Offline
    makemrproper
    wrote on last edited by girish
    #1

    Hi

    Any plans to create a LAMP stack with Postgres?

    It would make hosting all my favorite Postgres enabled applications possible.

    I guess it would make it LAPP or something.

    Thanks!

    Cloudron fan
    Paying Customer

    mehdiM 1 Reply Last reply
    1
    • M makemrproper

      Hi

      Any plans to create a LAMP stack with Postgres?

      It would make hosting all my favorite Postgres enabled applications possible.

      I guess it would make it LAPP or something.

      Thanks!

      mehdiM Offline
      mehdiM Offline
      mehdi
      App Dev
      wrote on last edited by
      #2

      @makemrproper You really should try packaging them as proper Cloudron apps! It's really easy to do, and would allow other people to use them too 🙂

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

        @makemrproper You have to make a custom app as @mehdi suggested. Try a guide like this one - https://cloudron.io/documentation/guides/multiple-databases-lamp/ . In the addons, instead of "mysql", put in "postgresql" and you will get CLOUDRON_POSTGRESQL_* environment variables to connect to.

        A 1 Reply Last reply
        1
        • M Offline
          M Offline
          makemrproper
          wrote on last edited by makemrproper
          #4

          Hey. Thank you for responding. Okay challenge accepted.

          If I ever package something generic I'll make sure to upstream the code / publish it.

          Cloudron fan
          Paying Customer

          1 Reply Last reply
          1
          • girishG girish

            @makemrproper You have to make a custom app as @mehdi suggested. Try a guide like this one - https://cloudron.io/documentation/guides/multiple-databases-lamp/ . In the addons, instead of "mysql", put in "postgresql" and you will get CLOUDRON_POSTGRESQL_* environment variables to connect to.

            A Offline
            A Offline
            andirahmat
            wrote on last edited by andirahmat
            #5

            @girish Hi. I've tried this as you and @mehdi suggested. But when i run "cloudron install" the result shown below :

            => Wait for health check ...................................................................................................................................................................................................................................................................................................................................................................................................................................................................

            App installation error: getaddrinfo ENOTFOUND my.domain.com

            In the control panel the app status "Not responding"

            i've also tried "cloudron install --no-wait"
            the result are the same.

            In the control panel the app status "Starting"

            Am I missing something?

            This happened only when i use postgresql. With mysql it running normal.

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

              @andirahmat I think there are two separate errors:

              • the ENOTFOUND is because some DNS resolution did not work on your PC/laptop where you are using the CLI tool. This is probably some temporary error. Can you try cloudron list to see if it works? If it does, you can ignore the temporary ENOTFOUND error.

              • The other issue is that app is saying "Starting..." This is because the app you deployed is not responding to health checks. Is it return 200 status code for the health check route listed in the CloudronManifest.json ? You can see the logs (App -> Console -> Logs) to see what it is returning for the healthcheck route.

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

                I put a package at https://git.cloudron.io/cloudron/php7.3-postgres-app/ . This is a PHP 7.3 app that has postgres.

                1 Reply Last reply
                2
                • E eddowding referenced this topic on
                • jan.reinhardtJ jan.reinhardt referenced this topic on
                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