Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id C7F812E0042 for ; Thu, 24 Apr 2008 12:59:54 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 94899-03 for ; Thu, 24 Apr 2008 12:59:40 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from rn-out-0910.google.com (rn-out-0910.google.com [64.233.170.187]) by developer.postgresql.org (Postfix) with ESMTP id E73262E0044 for ; Thu, 24 Apr 2008 12:59:37 -0300 (ADT) Received: by rn-out-0910.google.com with SMTP id i24so1613602rng.0 for ; Thu, 24 Apr 2008 08:59:35 -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:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=TICCagFad8JPZwLi7xz4SOAiBSGkSNVUXyY5x/gbWYI=; b=pyavSLbt54d5zl+gjPVMFtttXdvmB7SKC96WRQzt9kxh3+xxUufucOihYqOq60lZpYl7KnYQ4lWgJ4ogJMJi49bD7GSOXI6UwGYykHDt7lhOlcpSKcRAVktBS5I+y8IUu4pChSiOYxOpjtwepknVtqcIXwq6SfQIk5IJM3PlYEc= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=A5JFrnRH6FepcQdnPb43Xi1WN2vI2uJaWcZ4V4xy6GbvpIjmu0A9TSRggA9KWk1n7C7rALWLODGSF2O8lnPLqStMywUNzftK1qixQtg5NPcKE1ZKDETeNFbqpRspO3bblZdroPyxTxaORGmEREKnbN1efvEzA/itSHcmHcyBoP0= Received: by 10.114.39.16 with SMTP id m16mr1993262wam.146.1209052774799; Thu, 24 Apr 2008 08:59:34 -0700 (PDT) Received: by 10.114.137.7 with HTTP; Thu, 24 Apr 2008 08:59:34 -0700 (PDT) Message-ID: Date: Thu, 24 Apr 2008 09:59:34 -0600 From: "Scott Marlowe" To: "Antonis Antoniou" Subject: Re: moving from 7.4.13 to 8.0.14 Cc: pgsql-admin@postgresql.org In-Reply-To: <48105DDB.6060405@witch-spirit.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <48105DDB.6060405@witch-spirit.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/248 X-Sequence-Number: 29012 On Thu, Apr 24, 2008 at 4:15 AM, Antonis Antoniou wrote: > Hi, > > Currently I am using postgres 7.4.13 and I will like upgrade it to 8.0.14 > I have backup my databases by using pg_dumpall (7.4.13) > pg_dumpall -U postgres > /root/backup_all_db It will probably work. However, it is best to dump the old database (7.4.x) with the new pg_dump (8.0.x) > Is it doable to load the backup file using the psql (8.0.14) ? Yes. psql is the preferred restore program for uncompressed file formats. > Another question: Is it possible to upgrade 7.4.13 straight to 8.2? yes, and also 8.3 as well. I'd recommend going to at least 8.2. 8.3 got rid of a lot of auto-type coercion that may break some poorly formed queries. I'd recommend at least testing on 8.3 to see if you can go to it.