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.92) (envelope-from ) id 1jBnVc-0003kD-AQ for pgsql-novice@arkaria.postgresql.org; Tue, 10 Mar 2020 22:37:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1jBnVa-0001dh-TW for pgsql-novice@arkaria.postgresql.org; Tue, 10 Mar 2020 22:37:54 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1jBnVa-0001da-CW for pgsql-novice@lists.postgresql.org; Tue, 10 Mar 2020 22:37:54 +0000 Received: from tamriel.snowman.net ([96.255.250.162]) by makus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jBnVX-0004NG-4n for pgsql-novice@lists.postgresql.org; Tue, 10 Mar 2020 22:37:52 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id BCBE55F7A0; Tue, 10 Mar 2020 18:37:53 -0400 (EDT) Date: Tue, 10 Mar 2020 18:37:53 -0400 From: Stephen Frost To: mimble9@danwin1210.me Cc: pgsql-novice@lists.postgresql.org Subject: Re: pgbackrest creating new directories (messing up cron jobs). Message-ID: <20200310223753.GO3195@tamriel.snowman.net> References: <5808963daa5dd7b4a3704bba8dac828b.squirrel@danielas3rtn54uwmofdo3x2bsdifr47huasnmbgqzfrec5ubupvtpid.onion> <20200310134448.GA3195@tamriel.snowman.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="QL+AO8UtxodMplYP" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --QL+AO8UtxodMplYP Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Greetings, * mimble9@danwin1210.me (mimble9@danwin1210.me) wrote: > >> This is annoying as I have a cron job set up to focus on files in the > >> 0000000100000000 directory. > > > > What is the cronjob doing..? You really shouldn't be hacking around > > with things in the repo- there's commands available like archive-get to > > extract out WAL files from the repo. >=20 > The cronjob is using 'mutt' to mail me the .gz files at a set period. >=20 > It says: >=20 > cd /var/lib/pgbackrest/archive/main/10/0000000100000000/ > echo "" | mutt -s "Ttile" test@example.com -a *.gz Isn't that going to mail you the same WAL over and over again if you set it up as a cronjob..? Is that really what you want? > Of course, once 0000000100000000 becomes 0000000100000001, this no longer > works. That doesn't seem like the worst of the problems here. > Is there, perhaps, a better way to achieve my goal? Well, you could use archive-get with pgbackrest to pull out the files by requesting each segment number, but I'm not sure what the idea here is exactly- *why* are you email'ing them? Thanks, Stephen --QL+AO8UtxodMplYP Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJeaBbBAAoJEO1sijiDR2RVMQgQAL9SQys40CisR7+Bc8tsarFN m4S6Nfg1QqXaWRwX7rQbfKU/6yJFLAIl0MZoc7TNdf03eGMiMY2caEvDtjE0cHXh 6qOjLi93ePep+HVAafPfQOt+/MMBbCXv8xzgYThjeu4aZlTzwoIc2vT1mXk1Gh10 hGm9qltges6vZoxpJ23qUezHoq/PIxwyMVWpp33AhEjVk5QNIdrLav2IHNZoEk8N qWR9qW8YEbPo0bXxiFubNLmzr92icQUN6GVtDUdSPpOXmOtzDt40Ue3AYRlyq3Tf /svDRHiKqDW81TDVl5wRaQkRXZUWu8ioEvFxtoUdo38r/aQOChlXUohrn1GOM/p9 y9jngBvVwTDNeIbuJzWHArsE6Q5zIz3xNPm1v9ea1d+u4cduFmU3bU2Pbb00WATS jFMLW/Cva0hCfAfYjaArdzYPcK44bpRC5SGyfv632w3zxNivoVnorZH5x34ASaTw qkBSf1qzb3u8yRLU0I/W3HvhuFYF3588jagI7J3Nn7q09Y6fnK0w/opSn5Bo5mdU PNumbtaHuNud/OATcHOHlzIjRDjYjLz0IKL9ZydyKFTK2/i3+mmv8ajaAtj2eaGr eDRH0yGecS0MFOGbxOQ8JhOBCE4mfoxRmtKqX+ZycedBOcelzxU9ydMwaRR/y1Q2 LS2iwWoZCOsPM9wkXrHr =OQpK -----END PGP SIGNATURE----- --QL+AO8UtxodMplYP--