Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Converting 7.x to 8.x



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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group