Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 312892E004C; Tue, 17 Jun 2008 10:23:51 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 69697-02-6; Tue, 17 Jun 2008 10:23:37 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from ppsw-0.csi.cam.ac.uk (ppsw-0.csi.cam.ac.uk [131.111.8.130]) by developer.postgresql.org (Postfix) with ESMTP id A5B232E0074; Tue, 17 Jun 2008 10:23:10 -0300 (ADT) X-Cam-SpamDetails: Not scanned X-Cam-AntiVirus: No virus found X-Cam-ScannerInfo: http://www.cam.ac.uk/cs/email/scanner/ Received: from flymine.sysbiol.cam.ac.uk ([131.111.60.120]:50266 helo=flymine.flymine.org) by ppsw-0.csi.cam.ac.uk (ppsw.cam.ac.uk [131.111.8.130]:25) with esmtp id 1K8b9I-0008Ob-1g (Exim 4.67) (return-path ); Tue, 17 Jun 2008 14:23:00 +0100 Received: from host103 ([192.168.128.103] helo=aragorn.flymine.org ident=Debian-exim) by flymine.flymine.org with esmtp (Exim 4.12) id 1K8b9I-0005IT-00; Tue, 17 Jun 2008 14:23:00 +0100 Received: from mnw21 (helo=localhost) by aragorn.flymine.org with local-esmtp (Exim 4.69) (envelope-from ) id 1K8b9I-0006Si-Ep; Tue, 17 Jun 2008 14:23:00 +0100 Date: Tue, 17 Jun 2008 14:23:00 +0100 (BST) From: Matthew Wakeling X-X-Sender: mnw21@aragorn.flymine.org To: pgsql-general@postgresql.org, "pgsql-performance@postgresql.org" Subject: Re: [PERFORM] Migration Articles.. ??? In-Reply-To: Message-ID: References: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/508 X-Sequence-Number: 134037 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