Re: Postgresql - Modelo backup full + incremental

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
<https://postgrespro.com/docs/postgresql/current/runtime-config-preset#GUC-BLOCK-SIZE>
and wal_block_size
<https://postgrespro.com/docs/postgresql/current/runtime-config-preset#GUC-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(dot)shah(at)percona(dot)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(dot)shah(at)percona(dot)com
>
> w: www.percona.com
>
> Databases Run Better with Percona.
>
>
>
> On Sun, Nov 6, 2022 at 12:46 AM Ron <ronljohnsonjr(at)gmail(dot)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.
>>
>>
>>