Re: Postgresql - Modelo backup full + incremental - Mailing list pgsql-admin

From Mahesh Shetty
Subject Re: Postgresql - Modelo backup full + incremental
Date
Msg-id CAJPiW+gATezv1xeMuTanpD4DiEwv7+ENDFvHT98YqcJ_a3NivQ@mail.gmail.com
Whole thread Raw
In response to Re: Postgresql - Modelo backup full + incremental  (Ninad Shah <ninad.shah@percona.com>)
Responses Re: Postgresql - Modelo backup full + incremental
List pgsql-admin

pg_probackup currently has the following limitations:

  • The server from which the backup was taken and the restored server must be compatible by the block_size and wal_block_size parameters and have the same major release number.
  • Remote backup via ssh on Windows currently is not supported.
  • When running remote operations via ssh, remote and local pg_probackup versions must be the same.
Check for the benchmark and choose accordingly.

Regards,
Mahesh Shetty
DbaUniversity.com

On Sun, Nov 6, 2022, 1:10 AM Ninad Shah <ninad.shah@percona.com> wrote:
Apart from Pgbackrest pg_probackup is also a considerable option. It has more features than Pgbackrest e.g. merging adjacent backups and faster incremental backups using ptrack extension.


Thanks,

--

Ninad Shah
PostgreSQL DBA I, Managed Services

e: ninad.shah@percona.com

 w: www.percona.com

Databases Run Better with Percona. 




On Sun, Nov 6, 2022 at 12:46 AM Ron <ronljohnsonjr@gmail.com> wrote:
On 11/5/22 12:46, Erik Serrano wrote:
> Hello guys,
>
> Along with saying hello, I would like information to establish a Full +
> incremental postgresql database backup service, since I currently only
> have the full model.

I use PgBackRest.

--
Angular momentum makes the world go 'round.


pgsql-admin by date:

Previous
From: Ninad Shah
Date:
Subject: Re: Postgresql - Modelo backup full + incremental
Next
From: Ron
Date:
Subject: Re: Postgresql - Modelo backup full + incremental