Re: [PERFORM] Migration Articles.. ???

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