Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 6E5AF9FB2DE for ; Thu, 19 Oct 2006 12:11:51 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 59182-03 for ; Thu, 19 Oct 2006 15:10:07 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 3B2689FB2FA for ; Thu, 19 Oct 2006 12:06:36 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id k9JF6ZVJ007105 for ; Thu, 19 Oct 2006 12:06:35 -0300 (ADT) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id k9JElnDO083179 for pgsql-admin@postgresql.org; Thu, 19 Oct 2006 11:47:49 -0300 (ADT) (envelope-from news) From: "Craig W" X-Newsgroups: pgsql.admin Subject: Version 7.3.8 Upgrade Date: 19 Oct 2006 07:47:49 -0700 Organization: http://groups.google.com Lines: 15 Message-ID: <1161269269.072003.312790@m73g2000cwd.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Complaints-To: groups-abuse@google.com User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: m73g2000cwd.googlegroups.com; posting-host=62.189.112.129; posting-account=xxRP6A0AAACKzv8HnYuk0OzXWWSnHZ4s To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=UNPARSEABLE_RELAY X-Spam-Level: X-Archive-Number: 200610/132 X-Sequence-Number: 23435 I have been tasked with investigating an upgrade from 7.3.8 to 8.1.5. I have spent the last 12 years as an Ingres DBA, and am new to PostgreSQL. I know database theory, but not the specifics of this one I am sure that there will be benefits of upgrading, but are there any known problems with upgrading ? Please also let me know if it is a painless transition. Thanks in advance for any useful replies Craig