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:20:45 -0500
Message-ID: <2276564.1640884845@sss.pgh.pa.us> (raw)
In-Reply-To: <CALQRbyyOqWPNBMmeHEa1T2NKqWHaUvjw7uyqR_vp9syVrD3UeA@mail.gmail.com>
References: <CALQRbyyOqWPNBMmeHEa1T2NKqWHaUvjw7uyqR_vp9syVrD3UeA@mail.gmail.com>
Tom Korach <tom@safekeep.com> writes:
> We have a Postgresql instance (0.5-4TB in size) used for development and
> on-line reporting.
> We do not need high-availability, but we do need:
> 1. Quick disaster recovery (<1 hour) is important.
> 2. Recovery from corruption of the server or mistakes.
> Will file-system replication be enough to achieve this goal?
What do you mean exactly by "file-system replication"? Something
equivalent to rsync will absolutely not work against a running
Postgres server, because it won't capture a consistent state of
all the files. If you have (and trust) a filesystem with snapshot
capabilities, it might work to take a filesystem snapshot and hold
onto it long enough to rsync from the snapshot. I'm not sure about
the reliability or performance implications of such a setup, though.
See
https://www.postgresql.org/docs/current/backup-file.html> Do we also need WAL file archiving?
Not as long as you capture the currently-active WAL files along
with the database contents.
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: <2276564.1640884845@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