| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Using SAN Splits to instantly copy a DB |
| Date: | 2006-11-15 21:51:41 |
| Message-ID: | 20061115215141.GD31020@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Nov 15, 2006 at 03:25:38PM -0600, Ron Johnson wrote:
> However, what if the WAL is not on the SAN? You'd have to shut down
> pg anyway, in order to copy the WAL to a new directory, no?
You have to copy the *entire* cluster, you cannot split out one
database, for example. Two postmaster instances cannot share data,
period.
> Lastly: in order to do SAN splitting without risking your data,
> wouldn't you have to configure the disks as RAID-15 (mirrored
> RAID-5), since splitting a RAID10 would leave you with stripesets?
As long as you get all the data it OK. I'm not 100% clear on what SAN
splitting is so I'm not totally sure.
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rob Owen | 2006-11-15 22:07:53 | Re: Out of memory (Failed on request size 24) |
| Previous Message | Alexander Staubo | 2006-11-15 21:35:35 | Re: ORDER BY |