Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1orUKH-0008Vj-RD for pgsql-admin@arkaria.postgresql.org; Sun, 06 Nov 2022 01:19:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1orUKG-0003YZ-BT for pgsql-admin@arkaria.postgresql.org; Sun, 06 Nov 2022 01:19:52 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1orUKF-0003US-5g for pgsql-admin@lists.postgresql.org; Sun, 06 Nov 2022 01:19:51 +0000 Received: from resdmta-a1p-077302.sys.comcast.net ([2001:558:fd01:2bb4::c]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1orUK6-0000za-BW for pgsql-admin@lists.postgresql.org; Sun, 06 Nov 2022 01:19:48 +0000 Received: from resomta-a1p-077058.sys.comcast.net ([96.103.145.239]) by resdmta-a1p-077302.sys.comcast.net with ESMTP id rU6UoItcV7fsnrUK3oasFC; Sun, 06 Nov 2022 01:19:39 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=comcast.net; s=20190202a; t=1667697579; bh=NSh6WI4DYIjB66RKJEeabAKjBg1xSg5rad9FZ9ql5po=; h=Received:Received:Content-Type:From:Mime-Version:Subject:Date: Message-Id:To:Xfinity-Spam-Result; b=F6mUk3cpO4DaYLausevEmT1tKl5jFhkFh60ij33QcCYnXDBKLSBE0/6Nhg2IsVx+n CqeRtwb/xLHnNmmgDZ9d2C7tCDADTWXIvBf3dz3uusZjaN66cgertX++qwUwQOdUSN e9OTK6ajf5nLNyZQ9ZLIQ3rWvqeWR2ABJoQLQghR5T9M7L/kt40Vcmpia3Hm2oaLso aBEfMRIupEVoaqyrckKX6T+3zWoOUm3EPWgh8y8d8kPirWRNCg70S1CWt7mz7Twyg6 b4/0kL3Vvc2h2DVw3w68X6eOncN8t26+aRPW9y4E6FYuW8WMMVq1ZMP7ULCH9KVpSt w+ZgYkR6Nck5w== Received: from smtpclient.apple ([IPv6:2601:240:d000:c160:c11:aa84:dbaa:38cd]) by resomta-a1p-077058.sys.comcast.net with ESMTPA id rUJfo1E8deGY2rUJgoZuPC; Sun, 06 Nov 2022 01:19:17 +0000 X-Xfinity-VMeta: sc=-70.00;st=legit Content-Type: multipart/alternative; boundary=Apple-Mail-43CD18FF-1080-48E3-93F0-57E89EFB2FDD Content-Transfer-Encoding: 7bit From: Jwiencek3 Mime-Version: 1.0 (1.0) Subject: Re: Postgresql - Modelo backup full + incremental Date: Sat, 5 Nov 2022 20:19:14 -0500 Message-Id: References: Cc: Ron , pgsql-admin@lists.postgresql.org In-Reply-To: To: Ninad Shah X-Mailer: iPad Mail (19G82) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail-43CD18FF-1080-48E3-93F0-57E89EFB2FDD Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Check out barman as well. =20 Sent from my iPad > On Nov 5, 2022, at 2:40 PM, Ninad Shah wrote: >=20 > =EF=BB=BF > Apart from Pgbackrest pg_probackup is also a considerable option. It has m= ore features than Pgbackrest e.g. merging adjacent backups and faster increm= ental backups using ptrack extension. >=20 >=20 > Thanks, >=20 > -- >=20 > Ninad Shah > PostgreSQL DBA I, Managed Services >=20 > e: ninad.shah@percona.com > w: www.percona.com > Databases Run Better with Percona.=20 >=20 >=20 >=20 >> On Sun, Nov 6, 2022 at 12:46 AM Ron wrote: >> On 11/5/22 12:46, Erik Serrano wrote: >> > Hello guys, >> > >> > Along with saying hello, I would like information to establish a Full += =20 >> > incremental postgresql database backup service, since I currently only=20= >> > have the full model. >>=20 >> I use PgBackRest. >>=20 >> --=20 >> Angular momentum makes the world go 'round. >>=20 >>=20 --Apple-Mail-43CD18FF-1080-48E3-93F0-57E89EFB2FDD Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable Check out barman  as well.  
<= br>
Sent from my iPad

On Nov 5, 2022, at 2:40 PM, Ninad Shah <ninad.shah@percona.c= om> wrote:

=EF=BB=BF
Apart from Pgbackrest pg_probackup is a= lso a considerable option. It has more features than Pgbackrest e.g. merging= adjacent backups and faster incremental backups using ptrack extension.


Thanks,

--

<= tbody>


 PostgreSQL DBA I, Managed S= ervices

 e: ninad.shah@percona.com

 w= : www.percona.co= m

Databases Run Better wit= h 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 <= br> > have the full model.

I use PgBackRest.

--
Angular momentum makes the world go 'round.


= --Apple-Mail-43CD18FF-1080-48E3-93F0-57E89EFB2FDD--