Re: [GENERAL] Converting 7.x to 8.x

2007-02-02 Thread Ron Johnson
-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 (

Re: [GENERAL] Converting 7.x to 8.x

2007-02-02 Thread Jim Nasby
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.

Re: [GENERAL] Converting 7.x to 8.x

2007-01-29 Thread Ron Johnson
-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

Re: [GENERAL] Converting 7.x to 8.x

2007-01-29 Thread Vivek Khera
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

Re: [GENERAL] Converting 7.x to 8.x

2007-01-27 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/27/07 04:13, Anton Melser wrote: > On 26/01/07, Jim Nasby <[EMAIL PROTECTED]> wrote: >> On Jan 25, 2007, at 12:47 PM, Benjamin Smith wrote: >> > On Tuesday 23 January 2007 13:55, Carlos wrote: >> >> What would be the faster way to convert a 7.4.x

Re: [GENERAL] Converting 7.x to 8.x

2007-01-27 Thread Anton Melser
On 26/01/07, Jim Nasby <[EMAIL PROTECTED]> wrote: On Jan 25, 2007, at 12:47 PM, Benjamin Smith wrote: > On Tuesday 23 January 2007 13:55, Carlos wrote: >> What would be the faster way to convert a 7.4.x database into an 8.x >> database? A dump of the database takes over 20 hours so we want >> to

Re: [GENERAL] Converting 7.x to 8.x

2007-01-25 Thread Jim Nasby
On Jan 25, 2007, at 12:47 PM, Benjamin Smith wrote: On Tuesday 23 January 2007 13:55, Carlos wrote: What would be the faster way to convert a 7.4.x database into an 8.x database? A dump of the database takes over 20 hours so we want to convert the database without having to do a dump and res

Re: [GENERAL] Converting 7.x to 8.x

2007-01-25 Thread Benjamin Smith
On Tuesday 23 January 2007 13:55, Carlos wrote: > What would be the faster way to convert a 7.4.x database into an 8.x > database? A dump of the database takes over 20 hours so we want to convert > the database without having to do a dump and resptore. You've probably already accounted for this,

Re: [GENERAL] Converting 7.x to 8.x

2007-01-24 Thread Bruno Wolff III
On Thu, Jan 25, 2007 at 15:43:19 +1100, Chris <[EMAIL PROTECTED]> wrote: > Carlos wrote: > >What would be the faster way to convert a 7.4.x database into an 8.x > >database? A dump of the database takes over 20 hours so we want to > >convert the database without having to do a dump and resptor

Re: [GENERAL] Converting 7.x to 8.x

2007-01-24 Thread Chris
Carlos wrote: What would be the faster way to convert a 7.4.x database into an 8.x database? A dump of the database takes over 20 hours so we want to convert the database without having to do a dump and resptore. That's your only option as far as I know (I'm sure someone will correct me if t

[GENERAL] Converting 7.x to 8.x

2007-01-24 Thread Carlos
What would be the faster way to convert a 7.4.x database into an 8.x database? A dump of the database takes over 20 hours so we want to convert the database without having to do a dump and resptore.