* Tomeh, Husam <htomeh at firstam.com> [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" <ajs at crankycanuck.ca>
> To: "slony1-general at lists.slony.info" <slony1-general at lists.slony.info>
> 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  | ajs at crankycanuck.ca
> When my information changes, I alter my conclusions.  What do you do sir?
> 		--attr. John Maynard Keynes
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> 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
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general