* Tomeh, Husam <[EMAIL PROTECTED]> [070322 09:07]: > I strongly disagree with you. Any decent RDBMS such as Postgres should and I > think will have eventually a decent upgrade and migration tool rather than > using the conventional time-consuming dump and reload. What if your db is in > terabyte size like many enterprise-level ones nowadays! I think this an > essential tool for enterprise postgres implementations. I strongly disagree with you too :)
Well, most production setups should have some form of replication, because hardware can fail. Basically, you need to deal with the hardware failure case anyway, or you can accept the dump&reload waiting time anyway (because that's what you would be doing after a hardware failure). Now some nice replication packages like slony allow for easy upgrading. Plus as an addon, you get an exercise in switchover handling, that you can plan ahead. Andreas > > -- > Husam > > -----Original Message----- > From: "Andrew Sullivan" <[EMAIL PROTECTED]> > To: "[email protected]" <[email protected]> > Sent: 21-Mar-07 5:50 PM > Subject: Re: [Slony1-general] using slony to migrate large database from > pg8.1 to pg8.2 > > On Wed, Mar 21, 2007 at 10:15:43AM -0700, Tomeh, Husam wrote: > > > Hopefully it'll be integrated to the core distribution of postgres. > > _Please_, not this chestnut again. What is this "core distribution > of Postgres" that people keep talking about? This is a PostgreSQL > community project, supported with PostgreSQL community resources > (pgfoundry). It is an important tool, but there is no reason > whatever to "integrate" it with the "core distribution". > > Nobody thinks vi should be part of the kernel, just because vi is on > every usable UNIX in the world (pick some other "basic" program if > you like. Perhaps mkdir?). It's a separate program. It happens > to be shipped together in the same (perhaps virtual) box, but that > doesn't make it any less of a part of the working system. > > A > > > > -- > Andrew Sullivan | [EMAIL PROTECTED] > When my information changes, I alter my conclusions. What do you do sir? > --attr. John Maynard Keynes > _______________________________________________ > Slony1-general mailing list > [email protected] > http://lists.slony.info/mailman/listinfo/slony1-general > ********************************************************************** > This message contains confidential information intended only for the use of > the addressee(s) named above and may contain information that is legally > privileged. If you are not the addressee, or the person responsible for > delivering it to the addressee, you are hereby notified that reading, > disseminating, distributing or copying this message is strictly prohibited. > If you have received this message by mistake, please immediately notify us by > replying to the message and delete the original message immediately > thereafter. > > Thank you. > > FADLD Tag > ********************************************************************** > > _______________________________________________ > Slony1-general mailing list > [email protected] > http://lists.slony.info/mailman/listinfo/slony1-general _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
