Post

1 follower Follow
0

Schema Restoration Error messages

While trying to restore the schema, you might encounter the below error messages:

 

The row_security, idle_in_transaction_session_timeout, lock_timeout configuration setting is new in 9.5, and that error indicates that you're restoring a database dump taken from a 9.5 database into an older version of PostgreSQL.

That combination is not supported, as new features can't work with old servers.

You need to check the version of the PostgreSQL installed in the server and ensure that it is higher than 9.5 for these error messages to not pop up. 

Please sign in to leave a comment.