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





---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly