Re: Postgresql - Modelo backup full + incremental

Поиск
Список
Период
Сортировка
От Mahesh Shetty
Тема Re: Postgresql - Modelo backup full + incremental
Дата
Msg-id CAJPiW+gATezv1xeMuTanpD4DiEwv7+ENDFvHT98YqcJ_a3NivQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Postgresql - Modelo backup full + incremental  (Ninad Shah <ninad.shah@percona.com>)
Ответы Re: Postgresql - Modelo backup full + incremental  (Ron <ronljohnsonjr@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Ninad Shah
Дата:
Сообщение: Re: Postgresql - Modelo backup full + incremental
Следующее
От: Ron
Дата:
Сообщение: Re: Postgresql - Modelo backup full + incremental