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 1orQ03-0004fw-Ja for pgsql-admin@arkaria.postgresql.org; Sat, 05 Nov 2022 20:42:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1orQ02-0008RW-EM for pgsql-admin@arkaria.postgresql.org; Sat, 05 Nov 2022 20:42:42 +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 1orQ01-0008RN-R2 for pgsql-admin@lists.postgresql.org; Sat, 05 Nov 2022 20:42:42 +0000 Received: from mail-oa1-x32.google.com ([2001:4860:4864:20::32]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1orPzz-0007Md-AU for pgsql-admin@lists.postgresql.org; Sat, 05 Nov 2022 20:42:40 +0000 Received: by mail-oa1-x32.google.com with SMTP id 586e51a60fabf-13b6c1c89bdso8925294fac.13 for ; Sat, 05 Nov 2022 13:42:39 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=ipeKqvAneMzJ6pUYpqb0HNu2neKgw1yEjMZe2TNoSDg=; b=ao0fYPjdlmK+ormrHbcDcaj3aN2TF88YAjEhzljMT2X6gatifl+tQKx1ICRMp1Wz8h FYAYXdBizExrDC3lOdPR3PjjpDPcYiDC0fs0DF51tqPwZnf47jzZ/mkTsqUYX3I9Xuxc NwP52tyK70jptClkj3K1NODVfl3REEogAYi9IOrcg1R9z9uzSuEa9jjVKPcHajY+WMac lPxeo2LLWdShY//utKxQX4TDdiV7jFt/RwzNypwTJNRErM7f3ABtY+P+pQIytnd9leCA yk/VnVTG27NB9dfwBeft91McodQOzivxDwNT2PKpy1EJVV5l+JRmJ/XKLslcF0WAnWat U1NA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=ipeKqvAneMzJ6pUYpqb0HNu2neKgw1yEjMZe2TNoSDg=; b=b1ZMJ+gtOkAQn31HKo8wMEEVuDBGZnhXfAuHX1u1gkG03XJSkOtO24CqPnqFpWq0PA dD0hThzByTaT1wuNeT9Mcn6zR0VhrK8qh1GLiqkHlhG9jByT8J3/BpAYjkJ05Yj4yRvY tBF5zRgBbd8ueiTuhDDKJOzjNyTBcMV9saeqbxbZv+jFDDfAXnLVGp9WUj7CM9xrcV+S o3NnER5kMp4d725mtXVOVVN8owBdSzzBQyAs4rZlqOnuT+tSrlaxdCXearmp4+VUjXAu QNr+c/ZJCs9CcUaR0CtXYhDok+fylWT3pEXeMIGYP7h75IQwz4lwS8H+bd5ayZBaTCSS NY/Q== X-Gm-Message-State: ACrzQf2j3xHMoj88wZFi2b7+IMCC676neqNlhh5VBKz87G73cKKqdUCC hJSIba0DqxF8r2geoJQZ4aQToGg0rss= X-Google-Smtp-Source: AMsMyM41rFiHVDL8toBSxltFTUrxlboNPK1uCWNcNMWbI6XxbLjkRIIc+u4GxaxW1Kf+WaCaYTXp1A== X-Received: by 2002:a05:6870:b407:b0:13a:f0b9:7c13 with SMTP id x7-20020a056870b40700b0013af0b97c13mr25995799oap.212.1667680958548; Sat, 05 Nov 2022 13:42:38 -0700 (PDT) Received: from [192.168.88.10] (ip68-11-68-85.no.no.cox.net. [68.11.68.85]) by smtp.googlemail.com with ESMTPSA id g11-20020a056870340b00b0011bde9f5745sm1168247oah.23.2022.11.05.13.42.37 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sat, 05 Nov 2022 13:42:38 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------a6BI30I831Rn2vLF3dGLs0XL" Message-ID: Date: Sat, 5 Nov 2022 15:42:37 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.2.2 Subject: Re: Postgresql - Modelo backup full + incremental Content-Language: en-US To: pgsql-admin@lists.postgresql.org References: <478ece0a-1160-d833-db0e-04875497dd03@gmail.com> From: Ron In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------a6BI30I831Rn2vLF3dGLs0XL Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit 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 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 > > Databases Run Better with Percona. > > > > 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 + > > 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. --------------a6BI30I831Rn2vLF3dGLs0XL Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit 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@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.



--
Angular momentum makes the world go 'round.
--------------a6BI30I831Rn2vLF3dGLs0XL--