From: | "Evan D(dot) Hoffman" <evandhoffman(at)gmail(dot)com> |
---|---|
To: | Brian Hirt <bhirt(at)me(dot)com> |
Cc: | Postgresql Mailing List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Copying data files to new hardware? |
Date: | 2010-10-13 16:59:07 |
Message-ID: | AANLkTimATVkVuvK=VJV3o7FWYg_emapxs=T0FxXHm1DJ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
Thanks, Brian & Jaime. Regarding Slony, would that allow for
migration to a new version as well - i.e. moving from 8.2 on the old
machine to 8.4 on the new machine via Slony with minimal downtime?
The Slony method is one I hadn't considered. Since our database is so
large, even a direct file copy would require some downtime (since we'd
need to stop the DB before beginning the copy). Slony would probably
let us cut the downtime from hours to minutes (dump & restore for us
has historically taken days).
Thanks again,
Evan
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-10-13 17:05:00 | Re: [GENERAL] Copying data files to new hardware? |
Previous Message | Brian Hirt | 2010-10-13 16:49:53 | Re: Copying data files to new hardware? |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-10-13 17:05:00 | Re: [GENERAL] Copying data files to new hardware? |
Previous Message | Brian Hirt | 2010-10-13 16:49:53 | Re: Copying data files to new hardware? |