Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gW1a6-0006Me-2H for pgsql-admin@arkaria.postgresql.org; Sun, 09 Dec 2018 16:05:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gW1a4-0003H0-Qb for pgsql-admin@arkaria.postgresql.org; Sun, 09 Dec 2018 16:05:20 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gW1a4-0003G2-HB for pgsql-admin@lists.postgresql.org; Sun, 09 Dec 2018 16:05:20 +0000 Received: from mail-oi1-x22e.google.com ([2607:f8b0:4864:20::22e]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gW1Zy-0007AF-4d for pgsql-admin@postgresql.org; Sun, 09 Dec 2018 16:05:20 +0000 Received: by mail-oi1-x22e.google.com with SMTP id i6so7121876oia.6 for ; Sun, 09 Dec 2018 08:05:13 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=to:from:subject:message-id:date:user-agent:mime-version :content-transfer-encoding:content-language; bh=RCVDR9ZeVDh5OAourtBbPjpCDOQlEP0UPZ/vEvGEn0g=; b=jZKk8J9bxaaE8kQz1GNj0ym4l/fvYfFm8rw2iqRQD///scCJrSmdgskkz/Qwn31YqJ jIPgSrnqJGnznqvSZkzzcJBHBWf396QfPxGpTnKFFByInnkRWHoj0eUgcHmLIKkWlU08 i0jb/zaK8kaRSKxULNtsKOd4tJo9snryj6A5auw0jlv7In2ZaZBnAZdxZgeilE8Q4P0z oPwKbMJ8kLqdgYtjzJ+WAsr4J85DvqEmr76NZ+FX2P3jy/+u07Oi5y2WaSngG/zDPwhb yBCNE/WvhKf2QfjJKYMEdhXZCnwvHsl5moEo6qlkZBAciBr+FdsOZrmBJdX8og+z3v2J I83g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:to:from:subject:message-id:date:user-agent :mime-version:content-transfer-encoding:content-language; bh=RCVDR9ZeVDh5OAourtBbPjpCDOQlEP0UPZ/vEvGEn0g=; b=ibbNFKJvTew9WowpsjnPoQeudSoXU3C/1a+uwLewVXCPOZ57E1DMuRGCiD5a/W6e62 Y/tNEy/5CMrNCya2qsCqOfsKPGXU1tLNBDZs2Bq3o2juzoqiV6yTE3Y+xDEvvjxQVHjG KvXlLybPOjrp1IteP8lZD9IE30MzJ38YLmEq4jd2pwuLu/KOcP+SbT6jCcUrz3OnZhnB fi/kbl7bUAFgfDaQhiPEuZz3Gh94qCVWiz3FJgxdR4LxbvP0DALC8qf6D3kunnPvfmuk dG3hJhJyG3HzPlmUCWHhG784085B1QjL9LXxYXqH6n1Ylyh3u3tAn/DWcpHhUrXqK/cl tDXg== X-Gm-Message-State: AA+aEWbBv1kN/YVea+cyZpSBSjWF13oQtgie+sBoe+2WIK4aeh34UA0r UskcQ+FD90vIxNTGomuVGHvJsBbO X-Google-Smtp-Source: AFSGD/WFNXzpIFysJ6fOqI6+bF+Y2rcLFcX2BSgDxzdJhsi5BbUVeTTNZOtIcVYMiGahFdeqBPtKfA== X-Received: by 2002:aca:bb04:: with SMTP id l4mr5370411oif.109.1544371511500; Sun, 09 Dec 2018 08:05:11 -0800 (PST) Received: from [192.168.1.10] (ip70-171-116-89.no.no.cox.net. [70.171.116.89]) by smtp.googlemail.com with ESMTPSA id k23sm3875465oic.41.2018.12.09.08.05.10 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Sun, 09 Dec 2018 08:05:10 -0800 (PST) To: pgsql-admin@postgresql.org From: Ron Subject: pgbackrest periodic WAL backups? Message-ID: Date: Sun, 9 Dec 2018 10:05:10 -0600 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi, I've got a full pgbackrest backup in crontab that runs weekly, and a diff backup that runs nightly.  However, I can't find any way to do hourly WAL backups. Or does "archive_command = 'pgbackrest --stanza=demo archive-push %p'" just keep things automatically caught up, obviating the need for periodic WAL backups (as are needed in other RDBMSs)? Thanks -- Angular momentum makes the world go 'round.