Re: Copying data files to new hardware?

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

In response to

Responses

Browse pgsql-admin by date

  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?

Browse pgsql-general by date

  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?