Re: Converting 7.x to 8.x - Mailing list pgsql-general

From Ron Johnson
Subject Re: Converting 7.x to 8.x
Date
Msg-id 45C36C2C.9080405@cox.net
Whole thread Raw
In response to Re: Converting 7.x to 8.x  (Jim Nasby <decibel@decibel.org>)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 02/01/07 21:14, Jim Nasby wrote:
> 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?

If your existing storage system needs SCSI for the speed, then the
target disks for the converted database must match the original
disks in performance.

> 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.*.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFFw2wsS9HxQb37XmcRAlauAKDEAT4lROqNNNfhI5G9DOGM1xBxDQCfdN4v
Sc8BDvwsac6KGKnbFrcfNsM=
=BVmR
-----END PGP SIGNATURE-----

pgsql-general by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Predicted lifespan of different PostgreSQL branches
Next
From: Andrew Sullivan
Date:
Subject: Re: DBMS Engines and Performance