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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-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
From | Date | Subject | |
---|---|---|---|
Next Message | Albe Laurenz | 2008-06-17 14:25:14 | Re: Error when trying to drop a tablespace |
Previous Message | sathiya psql | 2008-06-17 13:13:18 | Migration Articles.. ??? |
From | Date | Subject | |
---|---|---|---|
Next Message | Howard Cole | 2008-06-17 13:28:23 | Re: Tsearch2 Initial Search Speed |
Previous Message | Matthew Wakeling | 2008-06-17 13:13:27 | Re: Tsearch2 Initial Search Speed |