| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | Jeff <threshar(at)torgo(dot)978(dot)org>, "markw(at)osdl(dot)org" <markw(at)osdl(dot)org> |
| Cc: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>, "linux-lvm(at)sistina(dot)com" <linux-lvm(at)sistina(dot)com>, <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: [PERFORM] backup/restore - another area. |
| Date: | 2003-10-16 16:49:59 |
| Message-ID: | 200310160949.59442.josh@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-performance |
Jeff,
> The downside is
> this method will only work on that specific version of PG and it isn't the
> "cleanest" thing in the world since you are essentially simulating a power
> failure to PG. Luckly the WAL works like a champ. Also, these backups can
> be much larger since it has to include the indexes as well. but this is a
> price you have to pay.
The other downside is, of course, that the database needs to be shut down.
> COOL HUH?
Certainly very useful in the DBA's arsenal of backup tools.
--
Josh Berkus
Aglio Database Solutions
San Francisco
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2003-10-16 17:02:51 | Re: question re double quotes |
| Previous Message | Adam Witney | 2003-10-16 16:38:05 | Re: question re crosstab query |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff | 2003-10-16 17:06:37 | Re: [PERFORM] backup/restore - another area. |
| Previous Message | Jeff | 2003-10-16 11:50:27 | Re: [PERFORM] backup/restore - another area. |