Re: Converting 7.x to 8.x

From: Jim Nasby <decibel(at)decibel(dot)org>
To: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Converting 7.x to 8.x
Date: 2007-02-02 03:14:42
Message-ID: C68E0D20-42A8-4DFB-B0DA-4463306FAD86@decibel.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Jan 27, 2007, at 10:45 AM, Ron Johnson wrote:
> Using slony or "piped pg_dump" requires that you have *double* the
> amount of disk space. Having a *very large* database and double
> capacity of SCSI disks (including storage controllers, shelves, etc,
> etc) is expensive, and might not be available.

You sure it has to be SCSI?

Even better question... how are you backing up right now? Are you
ready to accept the huge amount of downtime to restore from backup if
your server explodes?

In any case, there is an update utility for 8.1->8.2... you could
look into hacking that to work for 7.4->8.*.
--
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jim Nasby 2007-02-02 03:29:21 Re: Predicted lifespan of different PostgreSQL branches
Previous Message Jim Nasby 2007-02-02 03:09:19 Re: SQL Newbie Question