Re: Re. Backup of postgresql database

Ron <ronljohnsonjr@xxxxxxxxx> · Sat, 5 Feb 2022 09:14:02 -0600



    Fire your DBA!!

    
    After that, I'd install "pgbackrest", and use it to write backups to
    an S3 bucket.

    
    On 2/5/22 2:37 AM,
      sivapostgres@xxxxxxxxx wrote:

    
      Not done so far. Started using A2 for production just a couple of
      months back. 
      

        Sent from Yahoo Mail on Android
        

            On Sat, Feb 5, 2022 at 9:19 AM, Ron
            <ronljohnsonjr@xxxxxxxxx> wrote:
          
          
               On 2/4/22 9:14 PM, sivapostgres@xxxxxxxxx
                wrote:

                 
               Hello,
                Got
                  few (currently 3 will increase as days go) database in
                  A2 hosting unmanaged vps server, running Ubuntu server
                  18 lts
                

                Planning
                  to have an additional backup of all files, including
                  pg database, to another cloud provider like Amazon S3
                  (any other suggestions?)
                

                Size
                  won't be crossing 5GB per database for the next few
                  years.
                

                How are you currently backing up the databases?

                
                -- 

                  Angular momentum makes the world go 'round.
                 
              
    -- 

      Angular momentum makes the world go 'round.