X-Original-To: pgsql-novice-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9656E3A9FBA for ; Mon, 20 Dec 2004 17:08:22 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 94103-02 for ; Mon, 20 Dec 2004 17:08:12 +0000 (GMT) Received: from mx-00.sil.at (mx-00.sil.at [62.116.68.196]) by svr1.postgresql.org (Postfix) with ESMTP id 781A43A6CEE for ; Mon, 20 Dec 2004 17:08:11 +0000 (GMT) Received: (qmail-ldap/ctrl 39961 invoked from network); 20 Dec 2004 17:08:06 -0000 Received: from unknown (HELO bazaar.foomatic.at) ([213.129.239.202]) (envelope-sender ) by mx-00.sil.at (qmail-ldap-1.03) with DES-CBC3-SHA encrypted SMTP for ; 20 Dec 2004 17:08:06 -0000 Received: from localhost (bazaar.foomatic.lan [127.0.0.1]) by bazaar.foomatic.at (Postfix) with ESMTP id 339BBDF204; Mon, 20 Dec 2004 18:08:08 +0100 (CET) Received: from bazaar.foomatic.at ([127.0.0.1]) by localhost (bazaar.foomatic.at [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 25609-06; Mon, 20 Dec 2004 18:08:06 +0100 (CET) Received: from [192.168.15.239] (Weyoun.foomatic.lan [192.168.15.239]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by bazaar.foomatic.at (Postfix) with ESMTP id 0B6E4DF203; Mon, 20 Dec 2004 18:08:05 +0100 (CET) Message-ID: <41C706E3.5040302@foo.at> Date: Mon, 20 Dec 2004 18:07:47 +0100 From: Stefan Weiss Organization: Foo Orbital Operations User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.5) Gecko/20041206 Thunderbird/1.0 Mnenhy/0.7 X-Accept-Language: en-us, en MIME-Version: 1.0 To: sarlav kumar Cc: pgsqlnovice , pgsqlperform Subject: Re: [PERFORM] Postgres version change - pg_dump References: <20041220144034.93247.qmail@web51306.mail.yahoo.com> In-Reply-To: <20041220144034.93247.qmail@web51306.mail.yahoo.com> Content-Type: text/plain; charset=ISO-8859-15 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at foomatic.at X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200412/207 X-Sequence-Number: 11784 sarlav kumar wrote, On 2004-12-20 15:40: > I would like to do a pg_dump on the test database, and restore it in > the new database on Postgres 7.4.6. I would like to know if there > would be any problem due to the postgres version/OS change. If so, > could someone tell me what precautions I can take to avoid any > problems? Apart from using the pg_dump from 7.4.6 (see Bruno's answer), you should take care to use the same locale in the new database cluster. I have had problems in the past with unique constraints that could not be restored due to different locale settings. See here: http://www.spinics.net/lists/pgsql/msg05363.html In my case it was not enough to create the database with a different encoding, I had to re-initdb the whole cluster :-/ cheers, stefan