Re: Re. Backup of postgresql database

From: "sivapostgres(at)yahoo(dot)com" <sivapostgres(at)yahoo(dot)com>
To: benedict(dot)m(dot)holland(at)gmail(dot)com, Ron <ronljohnsonjr(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Re. Backup of postgresql database
Date: 2022-02-05 08:38:49
Message-ID: 518780479.100176.1644050329689@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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<benedict(dot)m(dot)holland(at)gmail(dot)com> wrote: Pg_dump or do a wal archive.
Thanks,Ben
On Fri, Feb 4, 2022, 10:49 PM Ron <ronljohnsonjr(at)gmail(dot)com> wrote:

On 2/4/22 9:14 PM, sivapostgres(at)yahoo(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2022-02-05 15:14:02 Re: Re. Backup of postgresql database
Previous Message sivapostgres@yahoo.com 2022-02-05 08:37:22 Re: Re. Backup of postgresql database