From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Postgresql - Modelo backup full + incremental
Date: Sat, 5 Nov 2022 15:42:37 -0500
Message-ID: <d78df712-fd80-260b-b398-30e7d248bd8b@gmail.com> (raw)
In-Reply-To: <CAJPiW+gATezv1xeMuTanpD4DiEwv7+ENDFvHT98YqcJ_a3NivQ@mail.gmail.com>
References: <CA+dvXXsOJRM84DDV5AnVZqBzTy7CV_ZOPqU4P8ro-+95vnz3kA@mail.gmail.com>
<478ece0a-1160-d833-db0e-04875497dd03@gmail.com>
<CAMtEjOYzCbWzd1S=6o4hHSshQuncBE7=qYx1+2b1pyPQf3hZ+w@mail.gmail.com>
<CAJPiW+gATezv1xeMuTanpD4DiEwv7+ENDFvHT98YqcJ_a3NivQ@mail.gmail.com>
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> paramet...
> 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 ShahPostgreSQL DBA I, Managed Servicese:ninad.shah@percona.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@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.
>
>
--
Angular momentum makes the world go 'round.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Postgresql - Modelo backup full + incremental
In-Reply-To: <d78df712-fd80-260b-b398-30e7d248bd8b@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox