Re: Postgresql - Modelo backup full + incremental

PgBackRest has those same restrictions.

On 11/5/22 15:37, Mahesh Shetty wrote:
>
> |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 ShahPostgreSQL DBA I, Managed Servicese:ninad(dot)shah(at)percona(dot)com
>
> w:www.percona.com <http://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.
>
>

--
Angular momentum makes the world go 'round.