Re: Postgresql - Modelo backup full + incremental

[Ron <ronljohnsonjr@xxxxxxxxx>]

    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 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@xxxxxxxxxxx> 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@xxxxxxxxxxx  w: www.percona.com
Databases Run Better with Percona.

On Sun, Nov 6, 2022 at 12:46 AM Ron <ronljohnsonjr@xxxxxxxxx> 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.