Re: WAL Archiving and base backup

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Issa Gorissen <issa-gorissen(at)usa(dot)net>
Cc: Torsten Förtsch <tfoertsch123(at)gmail(dot)com>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: WAL Archiving and base backup
Date: 2022-01-14 18:31:45
Message-ID: 20220114183144.GA10577@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greetings,

* Issa Gorissen (issa-gorissen(at)usa(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2022-01-14 19:27:43 Re: WAL Archiving and base backup
Previous Message Miles Elam 2022-01-14 14:31:12 Re: How can a Postgres SQL script be automatically run when a new table turns up?