Re: [GENERAL] VM-Ware Backup of VM safe?: snapshots: quiesced and non-quiesced

2017-09-26 Thread Thomas Güttler
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 wrote: Thomas Güttler wrote: We run a PostgreSQL 9.6 server in a virtual machine. The v

Re: [GENERAL] VM-Ware Backup of VM safe?

2017-09-22 Thread George Neuner
On Fri, 22 Sep 2017 16:14:23 +0200, "Klaus P. Pieper" wrote: >I am aware that VSS is purely Windows, and your comment about VSS aware >application is true. Backup programs / VM managers like Data Protection >Manager trigger these applications to put the files into a safe state >prior to the snaps

Re: [GENERAL] VM-Ware Backup of VM safe?

2017-09-22 Thread Klaus P. Pieper
> -Ursprüngliche Nachricht- > Von: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- > ow...@postgresql.org] Im Auftrag von George Neuner > Gesendet: Donnerstag, 21. September 2017 18:35 > > I can't speak for all VM managers, but Vmware's standard static snapshots > *do* capture bot

Re: [GENERAL] VM-Ware Backup of VM safe?

2017-09-21 Thread George Neuner
On Wed, 20 Sep 2017 20:24:05 +0200, "Klaus P. Pieper" wrote: >> Von: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- >> ow...@postgresql.org] Im Auftrag von George Neuner >> >> But VSS is needed only to copy VM files *while* they are in >> use. If you snapshot the VM, the snapshot file

Re: [GENERAL] VM-Ware Backup of VM safe?

2017-09-20 Thread Michael Paquier
On Wed, Sep 20, 2017 at 5:45 PM, Albe Laurenz 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

Re: [SPAM] Re: [GENERAL] VM-Ware Backup of VM safe?

2017-09-20 Thread Klaus P. Pieper
> -Ursprüngliche Nachricht- > Von: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- > ow...@postgresql.org] Im Auftrag von Moreno Andreo > Gesendet: Mittwoch, 20. September 2017 17:42 > I may be wrong, as I don't know MS SQL Server, but in the way you describe it, > you make me com

Re: [GENERAL] VM-Ware Backup of VM safe?

2017-09-20 Thread Klaus P. Pieper
> Von: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- > ow...@postgresql.org] Im Auftrag von George Neuner > > But VSS is needed only to copy VM files *while* they are in use. If you > snapshot > the VM, the snapshot files then are read-only and can be freely copied. As > long > as t

Re: [GENERAL] VM-Ware Backup of VM safe?

2017-09-20 Thread George Neuner
er 2017 10:03 >> An: pgsql-general@postgresql.org >> Betreff: [GENERAL] VM-Ware Backup of VM safe? >> >> 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

Re: [SPAM] Re: [GENERAL] VM-Ware Backup of VM safe?

2017-09-20 Thread Moreno Andreo
] VM-Ware Backup of VM safe? 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? When you run MS SQL Server on Hyper-V / Windows, the SQL Server provides ist own VSS writer responding to a taking

Re: [GENERAL] VM-Ware Backup of VM safe?

2017-09-20 Thread Klaus P. Pieper
> -Ursprüngliche Nachricht- > Von: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- > ow...@postgresql.org] Im Auftrag von Thomas Güttler > Gesendet: Mittwoch, 20. September 2017 10:03 > An: pgsql-general@postgresql.org > Betreff: [GENERAL] VM-Ware Backup of VM

Re: [GENERAL] VM-Ware Backup of VM safe?

2017-09-20 Thread George Neuner
On Wed, 20 Sep 2017 10:03:15 +0200, 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? It is "safe" if the VM is shut down first or if the backup is by copying a poi

Re: [GENERAL] VM-Ware Backup of VM safe?

2017-09-20 Thread Moreno Andreo
Il 20/09/2017 13:36, PT ha scritto: On Wed, 20 Sep 2017 10:03:15 +0200 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? There are so many variables involved with d

Re: [GENERAL] VM-Ware Backup of VM safe?

2017-09-20 Thread David Steele
On 9/20/17 7:36 AM, PT wrote: > On Wed, 20 Sep 2017 10:03:15 +0200 > 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? > > There are so many variab

Re: [GENERAL] VM-Ware Backup of VM safe?

2017-09-20 Thread PT
On Wed, 20 Sep 2017 10:03:15 +0200 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? There are so many variables involved with doing that ... I don't thi

Re: [GENERAL] VM-Ware Backup of VM safe?

2017-09-20 Thread Albe Laurenz
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, but the general rule is that if the backup is truly atomic (it is guaranteed t

[GENERAL] VM-Ware Backup of VM safe?

2017-09-20 Thread Thomas Güttler
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? Regards, Thomas Güttler -- Thomas Guettler http://www.thomas-guettler.de/ I am looking for feedback: https://github.com/guettli/programm