Thread: Re. Backup of postgresql database
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 this could be done?
Happiness Always
BKR Sivaprakash
On 2/4/22 9:14 PM, sivapostgres@yahoo.com wrote:
How are you currently backing up the databases?
Hello,Got few (currently 3 will increase as days go) database in A2 hosting unmanaged vps server, running Ubuntu server 18 ltsPlanning 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.
Pg_dump or do a wal archive.
Thanks,
Ben
On Fri, Feb 4, 2022, 10:49 PM Ron <ronljohnsonjr@gmail.com> wrote:
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 ltsPlanning 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.
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<ronljohnsonjr@gmail.com> wrote: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 ltsPlanning 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.
Should manually do pg_dump and then copy the resultant one to the destination?
On Sat, Feb 5, 2022 at 10:32 AM, Benedict Holland<benedict.m.holland@gmail.com> wrote:Pg_dump or do a wal archive.Thanks,BenOn Fri, Feb 4, 2022, 10:49 PM Ron <ronljohnsonjr@gmail.com> wrote: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 ltsPlanning 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.
Fire your DBA!!
After that, I'd install "pgbackrest", and use it to write backups to an S3 bucket.
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<ronljohnsonjr@gmail.com> wrote: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 ltsPlanning 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.
Angular momentum makes the world go 'round.