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


    Cloudron Forum

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

    Safe to delete postgresqldumps?

    Support
    database storage filesystem postgresqldump
    2
    4
    170
    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.
    • ei8fdb
      ei8fdb last edited by ei8fdb

      I'm trying to do some storage cleanup (I've moved some apps from internal disk to external storage, got some what seem like orphan backup files) as I'm a little short on storage atm.

      I've got 5-6 apps with a pretty large (+ 2G) postgresqldump files located in directories as:

      /home/yellowtent/appsdata/app-container-id/postgresqldump

      Am I safe to rm -rf these, since I'm thinking they're dumps?

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

        @ei8fdb safe to delete, but they are part of the "backup" procedure. The backup system takes a dump and uploads the dump. After the dump is uploaded, it's just left around to "reserve" space for future backups. It will get created again though each time a backup runs.

        ei8fdb 1 Reply Last reply Reply Quote 1
        • ei8fdb
          ei8fdb @girish last edited by

          @girish said in Safe to delete postgresqldumps?:

          The backup system takes a dump and uploads the dump. After the dump is uploaded, it's just left around to "reserve" space for future backups.

          Thanks @girish, so to make sure I understand:

          Scenario: backup dated 20220215 with an associated dump file

          • I delete the dump file, then decide to backup from that's date - restore will fail?

          There's only one postgresqldump file in each directory so it's probably safer that I keep them there and look for other stuff I can delete, right?

          Like my cat pictures....

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

            @ei8fdb

            I delete the dump file, then decide to backup from that's date - restore will fail?
            

            No, a copy a the postgresql file is in the backup. The file at /home/yellowtent/platformdata/<appid>/postgresqldump is a temporary file. When we want to backup an app, we create a dump from postgresql and save it to that file. Then we upload that file to wherever the backup is located . After the backup is done, that file has no real use but we just keep it around because in some rare cases where you don't have backups it can help in recovery.

            So, to summarize:

            • Safe to delete /home/yellowtent/appsdata/app-container-id/postgresqldump . But this will be created as part of the backup process, so it's going to be a pain. You have to delete this file everyday.
            • Your final backup location will have a copy of the above file. Under <timestamp>/appid/postgresqldump . This is your backup, don't delete this file!
            1 Reply Last reply Reply Quote 0
            • First post
              Last post
            Powered by NodeBB