Date: Wed, 1 Nov 2017 08:28:47 -0400
From: Stephen Frost <sfrost@snowman.net>
To: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
Cc: pgsql-admin@postgresql.org
Subject: Re: Bad recovery: no pg_xlog/RECOVERYXLOG
Message-ID: <20171101122847.GS4628@tamriel.snowman.net>
References: <d90474b1-6913-f3ff-d224-73fd931cdd98@cahoots.pl>
 <1070071508952614@web46j.yandex.ru>
 <ae7f2ee9-97ff-267e-b6dc-9399250a9314@cahoots.pl>
 <20171030154706.GE4628@tamriel.snowman.net>
 <7966ee9e-2241-eced-4639-e32c157b915a@catalyst.net.nz>
 <20171031114756.GP4628@tamriel.snowman.net>
 <2e3453d3-da6f-88af-05ec-7530e7f60547@catalyst.net.nz>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="P+m40iAaHLzsb1Wf"
Content-Disposition: inline
In-Reply-To: <2e3453d3-da6f-88af-05ec-7530e7f60547@catalyst.net.nz>
User-Agent: Mutt/1.5.21 (2010-09-15)
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org


--P+m40iAaHLzsb1Wf
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Mark,

* Mark Kirkwood (mark.kirkwood@catalyst.net.nz) wrote:
> While I agree that the scripts concerned would benefit from some
> development/qa etc, I'm really disagreeing with your point that folk
> 'should not do this'. I would like to say that folk 'should do this'
> - but try to do it well - and we should help them (isn't that idea
> kinda tied up with the whole point of these lists)?=20

I'm all for someone else starting up a new project to improve the
situation around backups for PG.  That not going to be three shell
scripts amounting to maybe 100 lines of code and what I really am
concerned about is people seeing these simple shell scripts thinking
"oh, I'll just use these simple things" without realizing that they're
going to end up in a bad spot because those simple shell scripts aren't
sufficient to do backups with PG properly and reliably.

We could store data in a CSV file and access it through shell scripts
too and call it a database.  If someone posted those as an alternative
to PG, I don't doubt that they'd get shot down pretty hard too.

These aren't just perfectionism complaints about shell scripts being
used to do backups of PG either, I've seen people using them and doing
so in ways that result in not having reliable backups which has then
lead to literally days of work be lost.

Put these shell scripts out on a github website with a big "in
development, not for production use, do not use" readme and continue to
hack on them as much as you'd like.  Don't post them to these lists with
a "this is how you do backups in PG".

Thanks!

Stephen

--P+m40iAaHLzsb1Wf
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iQIcBAEBCgAGBQJZ+b3+AAoJEO1sijiDR2RVz7oP/i4F5vptirHpJuvlDSyMte8y
DpBGEDxOuluhtMZuoEl83YX0NdqRvazyFflEeYxYJG0oi9Dso1NChzHxK2331Qo+
EbRXp5bNB/2f9YnNpdsuR2gGjBKEjM1C/Ysb2cu2CXUbj9utxY0QWGDHTyXv+Obs
9sKw5VqwZM5hkcZMWF35iuG7Jv9eatIAvV/Offa4KyGMSmpFsprtGt15KZem20zf
yGjBIX4a3qQzrExjfVbBWMl/AhzZY1/fTHM0hmFQ7zhE6VXHFWFj3PqXrpjstxsJ
bT8va4s5Z8LcA8FRlt09QT1Jj1f0INPGh1jeosOPCiKaoXXUpjM1w96Wivsu3U7p
m1tjpVO4/s+VBd23T6VKFja30agfMXqK6a0B1xrg9wAVq7WoW09z8RseMeyLobvP
RHPkq7GtI5iyXNu+nGdiA291bKsVW4AHOEyxDiac6hGNPlJIYk8thTDdK1hWrWvm
o77Ipcxm2UbqamzMcX103VBX0VBfiPOtFC9yTJkh8YdtObX+Q3h9IbtVCaughmxU
m1XvTNyIBpfpYNmxDqlq9ZajBGEZ4Aeajka7XyrlEo0nm5SBUjq5QC5gVp9S7eTX
zenYKKvIH/OULTlBfYnSqGBRtZvuKWE6UlbU0ISrqGNxioAeFQ5fRw/3UeqSYXzL
xT56tKngqn5Bar+wrXPj
=R4+f
-----END PGP SIGNATURE-----

--P+m40iAaHLzsb1Wf--