Dumping postgres database into development server from cloud66 backup

I am trying to dump my server’s database into my developmental but getting a lot of errors like

ERROR: insert or update on table “table_name” violates foreign key constraint “fk_rails_123123” DETAIL: Key (user_id)=(16325) is not present in table “users”. setval

because of using different versions with postgres on the server and development. Last resort would be to downgrade my postgres version but wondering if anyone got any other ideas. Thanks!

Hi there,

It is mostly OK to restore a back up file to a different version as it is a normal sql file. Could you tell me what your Postgres versions are?

You must be logged in to answer this question