Skip site navigation (1) Skip section navigation (2)

Re: moving from 7.4.13 to 8.0.14

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Antonis Antoniou" <antonis(at)witch-spirit(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: moving from 7.4.13 to 8.0.14
Date: 2008-04-24 15:59:34
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
On Thu, Apr 24, 2008 at 4:15 AM, Antonis Antoniou
<antonis(at)witch-spirit(dot)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.

In response to

pgsql-admin by date

Next:From: Bhella Paramjeet-PFCW67Date: 2008-04-24 17:12:53
Subject: Re: Vacuumdb error - corruption
Previous:From: Scott MarloweDate: 2008-04-24 15:39:26
Subject: Re: Problem with SGT (Singapore) timezone

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group