Richard Sickler <richard.sickler@avagotech.com> writes:
> The entire web app, (Tomcat and PostGRES), will be run in a virtual
> machine. I was thinking about quiescing the DB, then copying the files that
> make up the virtual machine to some network attached backup store. This
> will be done once a day.
This is really only attractive if you are prepared to *shut down* the
DB during the copy, not just "quiesce" it. Otherwise there's
considerable risk of getting a corrupted copy. Read the manual's
chapter about backup strategies.
regards, tom lane
