Restore postgreqsl data dump


#1

Hello,

My client has produced a dump of his production database. I’m hoping to restore this dump and use it for my development database.

I’ve tried running this from the command line:
pg_restore --dbname=amisick-database --verbose amisick_dev_backup_tar

And I receive the error

pg_restore: [archiver] unsupported version (1.13) in file header

From other help forums, it seems that I need to update my version of postgresql to fix this problem. I’ve tried following the instructions from at least four different threads for updating postgresql on Cloud9. Struggled to get results from any of them.

Can somebody please point me toward a tutorial or article that can explain how to perform this function with a Cloud9 Rails app?

Thank you for any insight.