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