Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: how do I import pqsl 7.1 database into 8.0
Date
Msg-id 18442.1134691701@sss.pgh.pa.us
Whole thread Raw
In response to how do I import pqsl 7.1 database into 8.0  (Mike Shen <x.shen@orcon.net.nz>)
List pgsql-novice
Tree view 
Mike Shen <x.shen@orcon.net.nz> writes:
> 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"

pg_dump would have produced a plain-text dump, which you should feed to
psql not pg_restore.

            regards, tom lane

pgsql-novice by date:

Previous
From: Mike Shen
Date:
Subject: how do I import pqsl 7.1 database into 8.0
Next
From: Raghunandan Bapuram
Date:
Subject: Regarding retrieving a bytea datatype using embedded SQL