Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id B66C39FD37F for ; Wed, 31 Oct 2007 15:46:53 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 12369-01-2 for ; Wed, 31 Oct 2007 15:46:11 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.171]) by postgresql.org (Postfix) with ESMTP id 8E3169FC926 for ; Wed, 31 Oct 2007 14:28:28 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id j3so339758ugf for ; Wed, 31 Oct 2007 10:28:27 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; bh=mlhqAfLodxCfFTTcmS83ED02NGZkdU5JaAvkWF9PPZU=; b=tGytkUuAvgOZ9aTk8vHqiRkVRyZTadqzck99HQ38C2yWhmSTZ5nrZ6FwAMylbAi90ym6odd/bLT+rC4CAN+GVr4Sc+tBckSdroodS3jP1ymjxAr/q0HCZ+ImJfqKJ+DMGEpFMJCBH3MgtvxrPp4xHM5MmilU5Q/k/wmhq6MrDhU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type; b=unCso6LZxDBefGqGUAI9sNc9e+XesA0JT3QoIMULP/yascvixArq2niJGC1lH2HrFOfmsRfXEszxt7WTjWFnTbiuuYQTcg6h/6PtJcHj9ezT9+sDZCawV95c/unpCiA4neKrvu+RRFgJaiFY8kGeiS+713zb2VCIVxjU1zb4wz0= Received: by 10.78.204.20 with SMTP id b20mr6342560hug.1193851707006; Wed, 31 Oct 2007 10:28:27 -0700 (PDT) Received: by 10.78.197.6 with HTTP; Wed, 31 Oct 2007 10:28:26 -0700 (PDT) Message-ID: <1d219a6f0710311028s745446aay7dd59c1982af7b03@mail.gmail.com> Date: Wed, 31 Oct 2007 13:28:26 -0400 From: "Chris Hoover" To: "pgsql-admin@postgresql.org Admin" Subject: Upgrading from 7.2.1 to 8.x MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_13770_8306460.1193851706992" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/319 X-Sequence-Number: 27233 ------=_Part_13770_8306460.1193851706992 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Question, I have an ancient database that is running Postgresql 7.2.1 on AIX. Is it safe to directly upgrade the database to 8.1? If not, what steps do I need to take? I have been pushing for 3 years to upgrade this database, and with some upcoming projects, I am going to do another push with management to upgrade this database. Also, I know there are a ton of fixes/improvements from 7.2, but are there any major data losing bugs in this version that I can use as added pressure on management? Thanks, Chris ------=_Part_13770_8306460.1193851706992 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Question,

I have an ancient database that is running Postgresql 7.2.1 on AIX.  Is it safe to directly upgrade the database to 8.1?  If not, what steps do I need to take?

I have been pushing for 3 years to upgrade this database, and with some upcoming projects, I am going to do another push with management to upgrade this database.

Also, I know there are a ton of fixes/improvements from 7.2, but are there any major data losing bugs in this version that I can use as added pressure on management?

Thanks,

Chris
------=_Part_13770_8306460.1193851706992--