pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgresql - Modelo backup full + incremental
7+ messages / 5 participants
[nested] [flat]
* Postgresql - Modelo backup full + incremental
@ 2022-11-05 17:46 Erik Serrano <eserranos@gmail.com>
2022-11-05 19:16 ` Re: Postgresql - Modelo backup full + incremental Ron <ronljohnsonjr@gmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: Erik Serrano @ 2022-11-05 17:46 UTC (permalink / raw)
To: pgsql-admin
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.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Postgresql - Modelo backup full + incremental
2022-11-05 17:46 Postgresql - Modelo backup full + incremental Erik Serrano <eserranos@gmail.com>
@ 2022-11-05 19:16 ` Ron <ronljohnsonjr@gmail.com>
2022-11-05 19:40 ` Re: Postgresql - Modelo backup full + incremental Ninad Shah <ninad.shah@percona.com>
0 siblings, 1 reply; 7+ messages in thread
From: Ron @ 2022-11-05 19:16 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Postgresql - Modelo backup full + incremental
2022-11-05 17:46 Postgresql - Modelo backup full + incremental Erik Serrano <eserranos@gmail.com>
2022-11-05 19:16 ` Re: Postgresql - Modelo backup full + incremental Ron <ronljohnsonjr@gmail.com>
@ 2022-11-05 19:40 ` Ninad Shah <ninad.shah@percona.com>
2022-11-05 20:37 ` Re: Postgresql - Modelo backup full + incremental Mahesh Shetty <maheshetty20@gmail.com>
2022-11-06 01:19 ` Re: Postgresql - Modelo backup full + incremental Jwiencek3 <jwiencek3@comcast.net>
0 siblings, 2 replies; 7+ messages in thread
From: Ninad Shah @ 2022-11-05 19:40 UTC (permalink / raw)
To: Ron <ronljohnsonjr@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
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.
>
>
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Postgresql - Modelo backup full + incremental
2022-11-05 17:46 Postgresql - Modelo backup full + incremental Erik Serrano <eserranos@gmail.com>
2022-11-05 19:16 ` Re: Postgresql - Modelo backup full + incremental Ron <ronljohnsonjr@gmail.com>
2022-11-05 19:40 ` Re: Postgresql - Modelo backup full + incremental Ninad Shah <ninad.shah@percona.com>
@ 2022-11-05 20:37 ` Mahesh Shetty <maheshetty20@gmail.com>
2022-11-05 20:42 ` Re: Postgresql - Modelo backup full + incremental Ron <ronljohnsonjr@gmail.com>
1 sibling, 1 reply; 7+ messages in thread
From: Mahesh Shetty @ 2022-11-05 20:37 UTC (permalink / raw)
To: Ninad Shah <ninad.shah@percona.com>; +Cc: Ron <ronljohnsonjr@gmail.com>; pgsql-admin@lists.postgresql.org
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.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.
>>
>>
>>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Postgresql - Modelo backup full + incremental
2022-11-05 17:46 Postgresql - Modelo backup full + incremental Erik Serrano <eserranos@gmail.com>
2022-11-05 19:16 ` Re: Postgresql - Modelo backup full + incremental Ron <ronljohnsonjr@gmail.com>
2022-11-05 19:40 ` Re: Postgresql - Modelo backup full + incremental Ninad Shah <ninad.shah@percona.com>
2022-11-05 20:37 ` Re: Postgresql - Modelo backup full + incremental Mahesh Shetty <maheshetty20@gmail.com>
@ 2022-11-05 20:42 ` Ron <ronljohnsonjr@gmail.com>
0 siblings, 0 replies; 7+ messages in thread
From: Ron @ 2022-11-05 20:42 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Postgresql - Modelo backup full + incremental
2022-11-05 17:46 Postgresql - Modelo backup full + incremental Erik Serrano <eserranos@gmail.com>
2022-11-05 19:16 ` Re: Postgresql - Modelo backup full + incremental Ron <ronljohnsonjr@gmail.com>
2022-11-05 19:40 ` Re: Postgresql - Modelo backup full + incremental Ninad Shah <ninad.shah@percona.com>
@ 2022-11-06 01:19 ` Jwiencek3 <jwiencek3@comcast.net>
2022-11-09 02:16 ` Re: Postgresql - Modelo backup full + incremental Erik Serrano <eserranos@gmail.com>
1 sibling, 1 reply; 7+ messages in thread
From: Jwiencek3 @ 2022-11-06 01:19 UTC (permalink / raw)
To: Ninad Shah <ninad.shah@percona.com>; +Cc: Ron <ronljohnsonjr@gmail.com>; pgsql-admin@lists.postgresql.org
Check out barman as well.
Sent from my iPad
> On Nov 5, 2022, at 2:40 PM, 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.
>>
>>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Postgresql - Modelo backup full + incremental
2022-11-05 17:46 Postgresql - Modelo backup full + incremental Erik Serrano <eserranos@gmail.com>
2022-11-05 19:16 ` Re: Postgresql - Modelo backup full + incremental Ron <ronljohnsonjr@gmail.com>
2022-11-05 19:40 ` Re: Postgresql - Modelo backup full + incremental Ninad Shah <ninad.shah@percona.com>
2022-11-06 01:19 ` Re: Postgresql - Modelo backup full + incremental Jwiencek3 <jwiencek3@comcast.net>
@ 2022-11-09 02:16 ` Erik Serrano <eserranos@gmail.com>
0 siblings, 0 replies; 7+ messages in thread
From: Erik Serrano @ 2022-11-09 02:16 UTC (permalink / raw)
To: Jwiencek3 <jwiencek3@comcast.net>; +Cc: Ninad Shah <ninad.shah@percona.com>; Ron <ronljohnsonjr@gmail.com>; pgsql-admin@lists.postgresql.org
Excellent, with these three methods of making my full + incremental
recovery system, I think I will have a lot to investigate and do my labs to
test performance and recovery.
Many thanks to everyone who contributed on this occasion.
see you masters
*Erik R. Serrano Saavedra*
*Ingeniero de Sistemas Informáticos*
* Data Base Administrator*
* eserranos@gmail.com <eserranos@gmail.com>*
* 998596691*
El sáb, 5 nov 2022 a las 22:19, Jwiencek3 (<jwiencek3@comcast.net>)
escribió:
> Check out barman as well.
>
> Sent from my iPad
>
> On Nov 5, 2022, at 2:40 PM, 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.
>>
>>
>>
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2022-11-09 02:16 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-11-05 17:46 Postgresql - Modelo backup full + incremental Erik Serrano <eserranos@gmail.com>
2022-11-05 19:16 ` Ron <ronljohnsonjr@gmail.com>
2022-11-05 19:40 ` Ninad Shah <ninad.shah@percona.com>
2022-11-05 20:37 ` Mahesh Shetty <maheshetty20@gmail.com>
2022-11-05 20:42 ` Ron <ronljohnsonjr@gmail.com>
2022-11-06 01:19 ` Jwiencek3 <jwiencek3@comcast.net>
2022-11-09 02:16 ` Erik Serrano <eserranos@gmail.com>
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