Re: Re. Backup of postgresql database

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

Re: Re. Backup of postgresql database

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

Re: Re. Backup of postgresql database

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 un

Re: Re. Backup of postgresql database

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 ad

Re: Re. Backup of postgresql database

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

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 pe