Thread: Migration Articles.. ???

Dear All,

Am going to do migration of database from one version to another., is there any article or any other document explaining the possibilities and other things.

Further Explanation:

I have a database in postgres X.Y which has around 90 tables, and lot of data in it.
In the next version of that product, i had some more tables, so how to migrate that,. there may be 150 tables., in that 90 tables, 70 may be the same, 20 got deleted, and 80 may be new., i want the 70 tables to have same data as it is.,

How to do this migration ??? any ways ???

On Tue, 17 Jun 2008, sathiya psql wrote:
> I have a database in postgres X.Y which has around 90 tables, and lot of
> data in it.
> In the next version of that product, i had some more tables, so how to
> migrate that,. there may be 150 tables., in that 90 tables, 70 may be the
> same, 20 got deleted, and 80 may be new., i want the 70 tables to have same
> data as it is.,

Please do not cross-post. This question has nothing to do with
performance. (Cross-posting answer so everyone else doesn't answer the
same.)

You'll want to dump the source database selectively, and then reload the
dump into a new database. RTFM on pg_dump, especially the "-t" and "-T"
options.

Matthew

--
All of this sounds mildly turgid and messy and confusing... but what the
heck. That's what programming's all about, really
                                        -- Computer Science Lecturer