Skip site navigation (1) Skip section navigation (2)

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

From: Matthew Wakeling <matthew(at)flymine(dot)org>
To: pgsql-general(at)postgresql(dot)org, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: [PERFORM] Migration Articles.. ???
Date: 2008-06-17 13:23:00
Message-ID: Pine.LNX.4.64.0806171418580.3987@aragorn.flymine.org (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-performance
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

In response to

pgsql-performance by date

Next:From: Howard ColeDate: 2008-06-17 13:28:23
Subject: Re: Tsearch2 Initial Search Speed
Previous:From: Matthew WakelingDate: 2008-06-17 13:13:27
Subject: Re: Tsearch2 Initial Search Speed

pgsql-general by date

Next:From: Albe LaurenzDate: 2008-06-17 14:25:14
Subject: Re: Error when trying to drop a tablespace
Previous:From: sathiya psqlDate: 2008-06-17 13:13:18
Subject: Migration Articles.. ???

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group