how do I import pqsl 7.1 database into 8.0 - Mailing list pgsql-novice

From Mike Shen
Subject how do I import pqsl 7.1 database into 8.0
Date
Msg-id 200512152304.jBFN4Uhs014502@webmail.orcon.net.nz
Whole thread Raw
Responses Re: how do I import pqsl 7.1 database into 8.0
List pgsql-novice
hello list,

I have gone through FAQs, still got problem. so I just ask the question here.

we got a suse box running postgresql 7.1. now we are building a new box to replace it. the new machine is running
fedoracore 4 with postgresql 8.0. 

on the old box, we did pg_dump drbooks > drbooks.out
on the new one, createdb drbooks
then pg_restore -d drbooks -Fc drbooks.out
we got error "did not find magic string in the file header"

what can we do to fix that?

any input welcome.

Regards,

Mike





pgsql-novice by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: create table with table constraints
Next
From: Tom Lane
Date:
Subject: Re: how do I import pqsl 7.1 database into 8.0