From: Tom Lane <tgl@sss.pgh.pa.us>
To: Tom Korach <tom@safekeep.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Is file system replication sufficient to recovery?
Date: Thu, 30 Dec 2021 12:52:11 -0500
Message-ID: <2286514.1640886731@sss.pgh.pa.us> (raw)
In-Reply-To: <CALQRbyyfjY7=z6Z8EGWj0aqPX0_Uk95v6pQkGoHbCDW=srFOGw@mail.gmail.com>
References: <CALQRbyyOqWPNBMmeHEa1T2NKqWHaUvjw7uyqR_vp9syVrD3UeA@mail.gmail.com>
<2276564.1640884845@sss.pgh.pa.us>
<CALQRbyyfjY7=z6Z8EGWj0aqPX0_Uk95v6pQkGoHbCDW=srFOGw@mail.gmail.com>
Tom Korach <tom@safekeep.com> writes:
>> What do you mean exactly by "file-system replication"?
> RAID1 setup (specifically, between two disks or EBS volumes [on AWS]),
> using LVM.
Maybe I'm missing something, but AFAIK plain old RAID will not protect
you against any scenario except failure of a single disk. It certainly
won't do anything to help you revert to a prior database state.
The docs page I pointed you to is part of a chapter that lays out all
the backup methods the PG community considers reliable. I strongly
suggest sticking to one of those and not trying to take shortcuts.
(The following chapter on high-availability setups is relevant
reading as well.)
regards, tom lane
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 using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, tom@safekeep.com, pgsql-admin@lists.postgresql.org
Subject: Re: Is file system replication sufficient to recovery?
In-Reply-To: <2286514.1640886731@sss.pgh.pa.us>
* 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