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?

Thanks

share|improve this question

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

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

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. –  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

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.