Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id BD0B32E00A0 for ; Thu, 24 Apr 2008 07:36:47 -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 15088-09 for ; Thu, 24 Apr 2008 07:36:38 -0300 (ADT) X-Greylist: delayed 00:25:35.035244 by SQLgrey-1.7.5 Received: from smtp132.iad.emailsrvr.com (smtp132.iad.emailsrvr.com [207.97.245.132]) by developer.postgresql.org (Postfix) with ESMTP id 16CF22E0037 for ; Thu, 24 Apr 2008 07:36:43 -0300 (ADT) Received: from relay3.r3.iad.emailsrvr.com (localhost [127.0.0.1]) by relay3.r3.iad.emailsrvr.com (SMTP Server) with ESMTP id AB7E944C0BF for ; Thu, 24 Apr 2008 06:11:06 -0400 (EDT) Received: by relay3.r3.iad.emailsrvr.com (Authenticated sender: antonis-AT-witch-spirit.com) with ESMTP id 1FE3B44C0BB for ; Thu, 24 Apr 2008 06:11:05 -0400 (EDT) Message-ID: <48105DDB.6060405@witch-spirit.com> Date: Thu, 24 Apr 2008 13:15:55 +0300 From: Antonis Antoniou User-Agent: Thunderbird 2.0.0.12 (X11/20080213) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: moving from 7.4.13 to 8.0.14 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200804/247 X-Sequence-Number: 29011 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 Is it doable to load the backup file using the psql (8.0.14) ? Another question: Is it possible to upgrade 7.4.13 straight to 8.2? Many Thanks, Antonis