Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id E55F22E005D for ; Tue, 17 Jun 2008 10:14:26 -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 54666-01-8 for ; Tue, 17 Jun 2008 10:14:09 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.228]) by developer.postgresql.org (Postfix) with ESMTP id 22B5F2E004C for ; Tue, 17 Jun 2008 10:13:47 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id c49so3184515wra.19 for ; Tue, 17 Jun 2008 06:13:45 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:mime-version:content-type; bh=nN30IiQz/oqwHNADMIUR13Smg4QaqM5sgfxECHKDMBg=; b=CUlLgr9tpjSyA36uXcnHrG+vk0tR8gbCmJmAvA4kibweDQo+rjv1oKpT5o4ruS2UjS tDepa5LZr7FHJzPN5NGqCKqcSvy2UG+N50kn8SJg2PjbxO9/Bvpa8LEPWkfAGDqwEfjJ l5VO1pondH0lRx9fx39wEtrcoxSECbkvixhzY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=lI/JK1pbxhJqN5rd2tvLrrZxE2wAq3lEvpYzNq2YuPTZssat6pj+z7SzFPLpGaLqCu XEGG3u0BdzeHvs602ibX/xmamRzgYqcShBkmGRs5iN5G81qmY52E+l0Ue09tF+o9emMK Wl3Qg69r2yVxZ3rnrO6b7FriIt0xYVhhrcLqw= Received: by 10.100.110.15 with SMTP id i15mr10690425anc.97.1213708425693; Tue, 17 Jun 2008 06:13:45 -0700 (PDT) Received: by 10.100.95.4 with HTTP; Tue, 17 Jun 2008 06:13:18 -0700 (PDT) Message-ID: Date: Tue, 17 Jun 2008 18:43:18 +0530 From: "sathiya psql" To: pgsql-general@postgresql.org, "pgsql-performance@postgresql.org" Subject: Migration Articles.. ??? MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_14997_14099194.1213708425686" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200806/507 X-Sequence-Number: 134036 ------=_Part_14997_14099194.1213708425686 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 ??? ------=_Part_14997_14099194.1213708425686 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 ???
------=_Part_14997_14099194.1213708425686--