| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Richard Sickler <richard(dot)sickler(at)avagotech(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: backing up a PostGRES DB |
| Date: | 2009-04-01 16:05:43 |
| Message-ID: | 6643.1238601943@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Richard Sickler <richard(dot)sickler(at)avagotech(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Félix Sánchez Rodríguez | 2009-04-01 16:21:40 | Without schemas |
| Previous Message | Scott Whitney | 2009-04-01 15:32:39 | Re: backing up a PostGRES DB |