Re: Re. Backup of postgresql database - Mailing list pgsql-general

From Ron
Subject Re: Re. Backup of postgresql database
Date
Msg-id 666e308f-fdce-f975-f172-370f96d60673@gmail.com
Whole thread Raw
In response to Re: Re. Backup of postgresql database  ("sivapostgres@yahoo.com" <sivapostgres@yahoo.com>)
List pgsql-general
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@yahoo.com wrote:
Not done so far. Started using A2 for production just a couple of months back. 



On Sat, Feb 5, 2022 at 9:19 AM, Ron
On 2/4/22 9:14 PM, sivapostgres@yahoo.com 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.

pgsql-general by date:

Previous
From: "sivapostgres@yahoo.com"
Date:
Subject: Re: Re. Backup of postgresql database
Next
From: Tom Lane
Date:
Subject: Re: Undetected Deadlock