Search Postgresql Archives

Re: Converting 7.x to 8.x

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 01/29/07 13:20, Vivek Khera 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.
> 
> Then one must decide which costs more: 20+ hours of downtime

More like 50 hours:
- - 20 to pg_dump
- - 30 to restore the data and rebuild the indexes.

>                                                              or some
> disks and a computer...

Yeah, that would fly like a lead balloon where I work...



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

iD8DBQFFvm9uS9HxQb37XmcRAqa3AJ9HW8aDaddXJeQKHIIjD/C3DmCKwQCglkqR
qkhNxa38GjMLdBeFKpatXck=
=DpX+
-----END PGP SIGNATURE-----


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux