Thank you for "quiesced vs non-quiesced". I will ask the company providing the VM.
Regards,
Thomas Güttler
Am 21.09.2017 um 03:48 schrieb Michael Paquier:
On Wed, Sep 20, 2017 at 5:45 PM, Albe Laurenz <laurenz.albe@xxxxxxxxxx> wrote:
Thomas Güttler wrote:
We run a PostgreSQL 9.6 server in a virtual machine.
The virtual machine is managed by the customer.
He does backup the VM.
Is this enough, is this safe?
I don't know about VMware,
I heard about one or two things :)
but the general rule is that
if the backup is truly atomic (it is guaranteed to capture
a consistent state of the file system), you can use it
to backup the database.
There are two types of snapshots: quiesced and non-quiesced. You
definitely want a quiesced snapshot when taking a backup so as the
system gets into a consistent state when working on it. There should
be an option related to that on the vSphere client managing the VM, so
make sure that quiesced is enabled.
--
Thomas Guettler http://www.thomas-guettler.de/
I am looking for feedback: https://github.com/guettli/programming-guidelines
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
