I was not bashing anyone. Bringing suggestions or ideas is a starter. Please don't take thbigs so personally.

   -- 
       Husam

-----Original Message-----
From: "cbbrowne at ca.afilias.info" <cbbrowne at ca.afilias.info>
To: "Tomeh, Husam" <htomeh at firstam.com>
Cc: "slony1-general at lists.slony.info" <slony1-general at lists.slony.info>
Sent: 21-Mar-07 7:22 PM
Subject: RE: [Slony1-general] using slony to migrate large database from pg8.1 to pg8.2

>  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 agree in part...

Yes, I think there should be a more direct migration mechanism, in the
long term.  I understand some people at Sun may be starting to work on
this.

What you have today, here, is Slony-I; that's the present workaround.

Bashing the options that you *do* have when they're not as nice as what we
might like to someday have is in poor taste particularly when talking with
the people that invested in creating what *is* available.

If these things are, as you say, "essential," a natural next question is:
What are you doing to contribute to making them available?  Wishing
migration tools into existence doesn't happen; it requires a lot of work.

If they're so essential, in your view, then can we assume you'll be
contributing time and/or money to building upgrade capabilities into
PostgreSQL 8.4?  Now's the time to start the effort...
**********************************************************************
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
**********************************************************************