From: | Jim Nasby <jim(at)nasby(dot)net> |
---|---|
To: | Paul Silveira <plabrh1(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Using SAN Splits to instantly copy a DB |
Date: | 2006-11-15 15:47:49 |
Message-ID: | 691E0DE9-5026-4B6C-BC4E-22412D5A2A2E@nasby.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Nov 14, 2006, at 3:44 PM, Paul Silveira wrote:
> Does anyone know if it is possible to use SAN Splitting (the
> function of
> splitting a mirror of disks so that there are two idential copies of a
> Postgres Instance)?
There are essentially 2 rules for doing a filesystem-level copy of
the database:
1. A copy is unlikely to work on a different architecture or OS.
2. You must either shut the database down to make the copy, use PITR,
or do a filesystem snapshot or equivalent.
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.
--
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
From | Date | Subject | |
---|---|---|---|
Next Message | Jim Nasby | 2006-11-15 15:48:07 | Re: The old Insert and retrieving your Serial problem in |
Previous Message | Jim Nasby | 2006-11-15 15:46:07 | Re: connectby usage question |