Re: Re. Backup of postgresql database

[sivapostg...@yahoo.com]

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 wrote:On 
2/4/22 9:14 PM, sivapostg...@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.   

Re: Re. Backup of postgresql database

[sivapostg...@yahoo.com]

Should manually do pg_dump and then copy the resultant one to the destination?

Sent from Yahoo Mail on Android 
 
  On Sat, Feb 5, 2022 at 10:32 AM, Benedict 
Holland wrote:   Pg_dump or do a wal archive.
Thanks,Ben
On Fri, Feb 4, 2022, 10:49 PM Ron  wrote:

  On 2/4/22 9:14 PM, sivapostg...@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. 
  

Re: Re. Backup of postgresql database

[Ron]

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, sivapostg...@yahoo.com 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
 wrote:
On 2/4/22 9:14 PM, sivapostg...@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.