pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
To: Stephen Frost <sfrost@snowman.net>
Cc: pgsql-admin@postgresql.org
Subject: Re: Bad recovery: no pg_xlog/RECOVERYXLOG
Date: Thu, 2 Nov 2017 10:20:51 +1300
Message-ID: <4efa2769-78c4-7bf0-5c33-0cf2d942ce74@catalyst.net.nz> (raw)
In-Reply-To: <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>
	<20171101122847.GS4628@tamriel.snowman.net>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>



On 02/11/17 01:28, Stephen Frost wrote:
> 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)?
> 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".
>
>

I don't think either the original script author - or myself - are 
attempting to suggest a few shell scripts were the next, complete 
coverage backup solution (ahem - it is only yourself that is pushing 
this extreme interpretation)!

However there is the use case for people that just want a minimal backup 
solution that works for their specific environment, and don't want to 
bring along a lot of extra machinery that a full coverage 
all-singing-and-dancing product includes - this *can* be accomplished by 
a few shell scripts. Yes, it does mean that you spend extra time testing 
and debugging [1]. Err - I think that is all the original author (who is 
probably scared off now), was wanting a bit of help with.

regards

Mark

[1] which is where a pre-existing more complex solution is likely to be 
better - it has had more testing in the field, and of course it is fine 
to point that out.


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



view thread (18+ messages)  latest in thread

Message-ID: <4efa2769-78c4-7bf0-5c33-0cf2d942ce74@catalyst.net.nz>
Permalink:  ../4efa2769-78c4-7bf0-5c33-0cf2d942ce74@catalyst.net.nz/
Also on:    postgresql.org/message-id/4efa2769-78c4-7bf0-5c33-0cf2d942ce74@catalyst.net.nz

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: mark.kirkwood@catalyst.net.nz, sfrost@snowman.net
  Subject: Re: Bad recovery: no pg_xlog/RECOVERYXLOG
  In-Reply-To: <4efa2769-78c4-7bf0-5c33-0cf2d942ce74@catalyst.net.nz>
  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> <20171101122847.GS4628@tamriel.snowman.net> <4efa2769-78c4-7bf0-5c33-0cf2d942ce74@catalyst.net.nz>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox