Re: WAL Archiving and base backup - Mailing list pgsql-general

From Stephen Frost
Subject Re: WAL Archiving and base backup
Date
Msg-id 20220114183144.GA10577@tamriel.snowman.net
Whole thread Raw
In response to Re: WAL Archiving and base backup  (Issa Gorissen <issa-gorissen@usa.net>)
Responses Re: WAL Archiving and base backup  (Ron <ronljohnsonjr@gmail.com>)
Re: WAL Archiving and base backup  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Greetings,

* Issa Gorissen (issa-gorissen@usa.net) wrote:
> Thx a lot. I thought about it but was not so sure about having a complex
> script (compared to the very simple version when using the exclusive backup
> - but this this is deprecated...).
>
> I will test your option with the simpler version and post it back to it can
> maybe land in PostgreSQL documentation.

The PG docs show how the command works and that's it.  The commands
in the docs aren't intended to be actually used in production
environments.  Writing a full solution involves having a good
understanding of the PG code and how WAL archiving, backups, et al, are
done.  If you're not familiar with this portion of the PG code base, I'd
strongly suggest you look at using solutions written and maintained by
folks who are.

Trying to write documentation on how to develop a complete solution
would be quite an effort and would certainly go beyond bash scripting
and likely wouldn't end up getting used anyway- those who are developing
such solutions are already reading through the actual code.

Thanks,

Stephen

Attachment

pgsql-general by date:

Previous
From: Miles Elam
Date:
Subject: Re: How can a Postgres SQL script be automatically run when a new table turns up?
Next
From: Ron
Date:
Subject: Re: WAL Archiving and base backup