pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedMigration Articles.. ???
2+ messages / 2 participants
[nested] [flat]
* Migration Articles.. ???
@ 2008-06-17 13:13 sathiya psql <sathiya.psql@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: sathiya psql @ 2008-06-17 13:13 UTC (permalink / raw)
To: pgsql-performance
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 ???
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [PERFORM] Migration Articles.. ???
@ 2008-06-17 13:23 Matthew Wakeling <matthew@flymine.org>
parent: sathiya psql <sathiya.psql@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Matthew Wakeling @ 2008-06-17 13:23 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-06-17 13:23 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-06-17 13:13 Migration Articles.. ??? sathiya psql <sathiya.psql@gmail.com>
2008-06-17 13:23 ` Matthew Wakeling <matthew@flymine.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox