Re: Converting 7.x to 8.x

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Converting 7.x to 8.x
Date: 2007-02-02 16:51:56
Message-ID: 45C36C2C.9080405@cox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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-----

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2007-02-02 17:00:27 Re: large document multiple regex
Previous Message Jim C. 2007-02-02 16:36:59 Re: Postgres SQL Syntax