up vote 0 down vote favorite
share [g+] share [fb]

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?

Thanks

link|improve this question
5  
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
5  
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. – Bay Wolf 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. – Bay Wolf 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
feedback

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

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

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard

Browse other questions tagged or ask your own question.