pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Migration 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