Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have an archaic postgresql dump that I'm trying to bring up on a recent 8.x installation. I get a ton of errors when I use psql -U [username] -d [databaseName] -f [filename]. I wonder if its even possible to do. Any ideas?


share|improve this question
You have a binary dump, right? You could build 7.4.3 from source, restore into that, dump as SQL, and then load the SQL dump in 8.4. –  mu is too short Sep 1 '11 at 2:13
It would help if you you showed your exact command lines and which errors you get. –  Peter Eisentraut Sep 1 '11 at 6:37
the dump is of type SQL_ASCII I believe. I tried rebuilding 7.x from source, but its so old I can't seem to get all the deps to install. specifically openssl. –  omencat Sep 1 '11 at 17:20
The command being used is: psql -U postgres -d [databasename] -f [backupFileName] ... The errors that scroll by are "Error: Syntax error at or near reboot". It looks like some detail in a comments table field. –  omencat Sep 1 '11 at 17:22
You mention in the question that you use pg_restore, not psql. Complete details please. –  Peter Eisentraut Sep 1 '11 at 19:41
show 1 more comment

migrated from stackoverflow.com Sep 1 '11 at 13:16

This question came from our site for professional and enthusiast programmers.

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.