Re: pgdump from 8.0.4 not valid for import into 8.1.0

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
>
>
>
>