From: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Using SAN Splits to instantly copy a DB |
Date: | 2006-11-15 21:25:38 |
Message-ID: | 455B85D2.1070801@cox.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 11/15/06 14:46, Martijn van Oosterhout wrote:
>> How does it know what a crashed PostgreSQL database look like?
>>
>> Besides, active transactions need to be *rolled back*, not written
>> ahead, since half the data hasn't been sent from the computer yet.
>
> There's a section of the docs dealing with this:
>
> http://www.postgresql.org/docs/8.1/static/wal.html
Oh, wait, I missed this in your previous email: "start a new
postmaster". That resolves a *lot* of my confusion.
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?
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?
- --
Ron Johnson, Jr.
Jefferson LA USA
Is "common sense" really valid?
For example, it is "common sense" to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However, that "common sense" is obviously wrong.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)
iD8DBQFFW4XRS9HxQb37XmcRAmE2AKCczirloNDRAIIgftniLYDn7G2+cwCg6pN2
mQGjvqHE3AW4DpLc6yN+0ZI=
=HFlW
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Alexander Staubo | 2006-11-15 21:35:35 | Re: ORDER BY |
Previous Message | Adrian Klaver | 2006-11-15 21:16:15 | Re: Data conversion tools? |