From: Scott Marlowe <scott.marlowe@gmail.com>
To: Antonis Antoniou <antonis@witch-spirit.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: moving from 7.4.13 to 8.0.14
Date: Thu, 24 Apr 2008 09:59:34 -0600
Message-ID: <dcc563d10804240859q7cc952ccre1f81ad63cd8444b@mail.gmail.com> (raw)
In-Reply-To: <48105DDB.6060405@witch-spirit.com>
References: <48105DDB.6060405@witch-spirit.com>
On Thu, Apr 24, 2008 at 4:15 AM, Antonis Antoniou
<antonis@witch-spirit.com> 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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott.marlowe@gmail.com, antonis@witch-spirit.com
Subject: Re: moving from 7.4.13 to 8.0.14
In-Reply-To: <dcc563d10804240859q7cc952ccre1f81ad63cd8444b@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox