Re: Using SAN Splits to instantly copy a DB

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 19:41:47
Message-ID: 455B6D7B.9070406@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 09:47, Jim Nasby wrote:
> On Nov 14, 2006, at 3:44 PM, Paul Silveira wrote:
[snip]
> Rule 2 is needed to ensure that the data files in the database are all
> consistent to each other. If you have a SAN/filesystem with snapshot
> capability (sounds like you do), then you can do that to create the copy
> rather than shutting the database down.

How does SAN-snapshot ensure transactional consistency?

- --
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)

iD8DBQFFW217S9HxQb37XmcRAocuAKCBvrpXWQrNeAEaFQ7UqXZxj0NPnwCfbbYP
9sPsnMb0uYqyPonOOFKVR6U=
=IL6Q
-----END PGP SIGNATURE-----

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ashley Moran 2006-11-15 19:50:39 Re: ORDER BY
Previous Message Dan Armbrust 2006-11-15 19:41:41 Data conversion tools?