| From: | George Neuner <gneuner2(at)comcast(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: VM-Ware Backup of VM safe? |
| Date: | 2017-09-20 15:02:03 |
| Message-ID: | 6du4sc9ne7gnts9h95o1d8kufoatsgejmp@4ax.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 20 Sep 2017 10:03:15 +0200, Thomas Güttler
<guettliml(at)thomas-guettler(dot)de> 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?
It is "safe" if the VM is shut down first or if the backup is by
copying a point-in-time snapshot of the VM.
Whether it is "enough" is a matter of opinion. Backing up a VM
basically is the equivalent of imaging a hard drive: it's great if the
filesystem is intact and the image is clean ... otherwise it's not so
good.
If the database files on the VM's "drive" develop errors, those errors
will be preserved in the VM backup.
George
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2017-09-20 15:14:07 | Re: Insert large number of records |
| Previous Message | Job | 2017-09-20 14:10:58 | Inserting millions of record in a partitioned Table |