Re: [GENERAL] minimizing downtime when upgrading

2006-06-23 Thread Kenneth Downs
Jim Nasby wrote: On Jun 21, 2006, at 7:42 AM, H.J. Sanders wrote: The last 15 years we also used Informix and we never, never had to unload/load the database because of an upgrade. Perhaps somebody knows how they do the trick? Do they provide a migration/upgrade utility? In the case of

Re: [GENERAL] minimizing downtime when upgrading

2006-06-22 Thread Jim Nasby
On Jun 21, 2006, at 7:42 AM, H.J. Sanders wrote: The last 15 years we also used Informix and we never, never had to unload/load the database because of an upgrade. Perhaps somebody knows how they do the trick? Do they provide a migration/upgrade utility? -- Jim C. Nasby, Sr. Engineering Cons

Re: [GENERAL] minimizing downtime when upgrading

2006-06-21 Thread H.J. Sanders
>>> > >>> Is anybody over at the dev team considering what an onerous burden > >>> this is? Is anyone considering doing away with it? Just my 2 cents: more and more databases have to run 24 * 7 , so something has to be done. The last 15 years we also used Informix and we never, never had to

Re: [GENERAL] minimizing downtime when upgrading

2006-06-21 Thread Alban Hertroys
Kenneth Downs wrote: Richard Huxton wrote: Kenneth Downs wrote: AFAIK it has always been the case that you should expect to have to dump out your databases and reload them for version upgrades. Is anybody over at the dev team considering what an onerous burden this is? Is anyone consideri

Re: [GENERAL] minimizing downtime when upgrading

2006-06-21 Thread Martijn van Oosterhout
On Wed, Jun 21, 2006 at 08:10:20AM -0400, Kenneth Downs wrote: > Regardless of whether a package is commercial or free, it strikes me as > counter to the very soul of programming to build in a burden that > increases with the user's use of the program, threatening even to tip > the balance altog

Re: [GENERAL] minimizing downtime when upgrading

2006-06-21 Thread Kenneth Downs
Richard Huxton wrote: Kenneth Downs wrote: AFAIK it has always been the case that you should expect to have to dump out your databases and reload them for version upgrades. Is anybody over at the dev team considering what an onerous burden this is? Is anyone considering doing away with it?

Re: [GENERAL] minimizing downtime when upgrading

2006-06-16 Thread Bill Moran
In response to snacktime <[EMAIL PROTECTED]>: > On 6/16/06, Richard Huxton wrote: > > > The other option would be to run replication, e.g. slony to migrate from > > one version to another. I've done it and it works fine, but it will mean > > slony adding its own tables to each database. I'd stil

Re: [GENERAL] minimizing downtime when upgrading

2006-06-16 Thread snacktime
On 6/16/06, Richard Huxton wrote: The other option would be to run replication, e.g. slony to migrate from one version to another. I've done it and it works fine, but it will mean slony adding its own tables to each database. I'd still do it one merchant at a time, but that should reduce your d

Re: [GENERAL] minimizing downtime when upgrading

2006-06-16 Thread Richard Huxton
Kenneth Downs wrote: AFAIK it has always been the case that you should expect to have to dump out your databases and reload them for version upgrades. Is anybody over at the dev team considering what an onerous burden this is? Is anyone considering doing away with it? Far from trivial. You

Re: [GENERAL] minimizing downtime when upgrading

2006-06-16 Thread Oleg Bartunov
On Thu, 15 Jun 2006, snacktime wrote: Anyone have any tips for minimizing downtime when upgrading? So far we have done upgrades during scheduled downtimes. Now we are getting to the point where the time required for a standard dump/restore is just too long. What have others done when downtime

Re: [GENERAL] minimizing downtime when upgrading

2006-06-16 Thread Kenneth Downs
snacktime wrote: Anyone have any tips for minimizing downtime when upgrading? So far we have done upgrades during scheduled downtimes. Now we are getting to the point where the time required for a standard dump/restore is just too long. What have others done when downtime is critical? The on

Re: [GENERAL] minimizing downtime when upgrading

2006-06-16 Thread Richard Huxton
snacktime wrote: Anyone have any tips for minimizing downtime when upgrading? So far we have done upgrades during scheduled downtimes. Now we are getting to the point where the time required for a standard dump/restore is just too long. What have others done when downtime is critical? The onl