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 172993A7146 for ; Mon, 20 Dec 2004 14:40:43 +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 12923-04 for ; Mon, 20 Dec 2004 14:40:32 +0000 (GMT) Received: from web51306.mail.yahoo.com (web51306.mail.yahoo.com [206.190.38.172]) by svr1.postgresql.org (Postfix) with SMTP id C67A53A713F for ; Mon, 20 Dec 2004 14:40:34 +0000 (GMT) Received: (qmail 93252 invoked by uid 60001); 20 Dec 2004 14:40:34 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=myApsLvB3m798r3E6sJ+W8DhEYeCRgaeXItHIrQQ67yL8RIK2VuucnyFxlVZq2fSSPIARPQY5/95lx7Yq+IM/Kf5ZOTf5Ak33KtiQi9rcOGrDNjYKhqXKpbYNJNzcBe9Jf5sdaCwXl8zkveE49mirYmI/YL7hS+sEdaabcC5Jzg= ; Message-ID: <20041220144034.93247.qmail@web51306.mail.yahoo.com> Received: from [65.218.182.242] by web51306.mail.yahoo.com via HTTP; Mon, 20 Dec 2004 06:40:34 PST Date: Mon, 20 Dec 2004 06:40:34 -0800 (PST) From: sarlav kumar Subject: Postgres version change - pg_dump To: pgsqlnovice , pgsqlperform MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-82885129-1103553634=:90526" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.542 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, HTML_40_50, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200412/178 X-Sequence-Number: 11755 --0-82885129-1103553634=:90526 Content-Type: text/plain; charset=us-ascii Hi All, Thanks to everyone for helping with my previous questions. I have a test database running on Postgres 7.3.2. version ------------------------------------------------------------- PostgreSQL 7.3.2 on i686-pc-linux-gnu, compiled by GCC 2.96 I have another server where a newer version of postgres that came with the Fedora Core 3 package installed. version ------------------------------------------------------------------------------------------------------------------------- PostgreSQL 7.4.6 on i386-redhat-linux-gnu, compiled by GCC i386-redhat-linux-gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2-6) 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? Thanks in advance, Saranya --------------------------------- Do you Yahoo!? Yahoo! Mail - Find what you need with new enhanced search. Learn more. --0-82885129-1103553634=:90526 Content-Type: text/html; charset=us-ascii
Hi All,
 
Thanks to everyone for helping with my previous questions.
 
I have a test database running on Postgres 7.3.2.
 
 version                          
-------------------------------------------------------------
 PostgreSQL 7.3.2 on i686-pc-linux-gnu, compiled by GCC 2.96
I have another server where a newer version of postgres that came with the Fedora Core 3 package installed.
 
version                                                        
-------------------------------------------------------------------------------------------------------------------------
 PostgreSQL 7.4.6 on i386-redhat-linux-gnu, compiled by GCC i386-redhat-linux-gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2-6)
 
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?
 
Thanks in advance,
Saranya
 
 
 


Do you Yahoo!?
Yahoo! Mail - Find what you need with new enhanced search. Learn more. --0-82885129-1103553634=:90526--