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@wien.gv.at> 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general