| 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: | dcc563d10804240859q7cc952ccre1f81ad63cd8444b@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bhella Paramjeet-PFCW67 | 2008-04-24 17:12:53 | Re: Vacuumdb error - corruption |
| Previous Message | Scott Marlowe | 2008-04-24 15:39:26 | Re: Problem with SGT (Singapore) timezone |