From: | Richard Sydney-Smith <richard(at)ibisau(dot)com> |
---|---|
To: | Richard Huxton <dev(at)archonet(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: pgdump from 8.0.4 not valid for import into 8.1.0 |
Date: | 2005-11-11 02:09:37 |
Message-ID: | 4373FD61.7000000@ibisau.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks Richard. Backup as compressed worked.
Richard Huxton wrote:
> Richard Sydney-Smith wrote:
>
>> ? In pgAdminIII linked to 8.0.4 server did a backup of all databased.
>> Chose "plain" and saved to disk.
>> uninstalled 8.0.4
>> installed 8.1.0
>>
>> create database in pgAdminIII v1.4
>> restore
>> ---- reports as not a valid archive.
>>
>> Obviously this is not what I expect.
>> Some older backups from a 7.4.? server on a Redhat machine will restore.
>
>
> I'd guess it's expecting the "custom" archive format which lets you
> pick and choose what to restore. Someone more knowledgable will pop up
> and say for certain shortly.
>
> You should be able to feed a "plain" backup to psql or to pg_restore
> though.
>
> --
> Richard Huxton
> Archonet Ltd
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2005-11-11 02:47:22 | Re: TIMESTAMP vs TIMESTAMP WITHOUT TIME ZONE |
Previous Message | Scott Frankel | 2005-11-11 02:07:16 | Re: Restoring from filesystem backup |