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


Navigation

    Cloudron Forum

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular

    SOLVED Postgresql

    Support
    addons
    2
    5
    78
    Loading More Posts
    • 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.
    • J
      Jenova last edited by girish

      Hello, I have an issue with postgresql. It wont start back up. I tried using the restart button under System. I talked to Girish about this before and solved it, but I lost the email. Can someone help me? Thanks.

      1 Reply Last reply Reply Quote 0
      • girish
        girish Staff last edited by

        @Jenova Ah! I found your support email. I wonder why this issue has re-surfaced. That too twice with you...

        NOTE: this nukes all postgresql data. Don't use this if any of your apps are using postgresql already.

        docker stop postgresql
        rm -rf /home/yellowtent/platformdata/postgresql/*
        sed -e 's/postgresql:2.0.2/postgresql:2.0.1/' -i /home/yellowtent/platformdata/INFRA_VERSION
        systemctl restart box
        
        J 1 Reply Last reply Reply Quote 1
        • girish
          girish Staff last edited by

          @Jenova If you click the logs button of postgresql what does it say?

          1 Reply Last reply Reply Quote 0
          • J
            Jenova last edited by Jenova

            @girish

            "Detected existing installation"

            I am the person that emailed you the last time, in which the command wouldn't work since I was on my phone. 😕

            1 Reply Last reply Reply Quote 0
            • girish
              girish Staff last edited by

              @Jenova Ah! I found your support email. I wonder why this issue has re-surfaced. That too twice with you...

              NOTE: this nukes all postgresql data. Don't use this if any of your apps are using postgresql already.

              docker stop postgresql
              rm -rf /home/yellowtent/platformdata/postgresql/*
              sed -e 's/postgresql:2.0.2/postgresql:2.0.1/' -i /home/yellowtent/platformdata/INFRA_VERSION
              systemctl restart box
              
              J 1 Reply Last reply Reply Quote 1
              • J
                Jenova @girish last edited by

                @girish

                Because I get impatient with my VPS and run commands while other commands are still running and I break things. This was one of those times where I would run start.sh and systemctl restart docker one too many times and things were not done running. 😕

                1 Reply Last reply Reply Quote 0
                • First post
                  Last post