I use PGadmin backup function, reduction in another empty table, but I have been an error row_security couldn't identify the environment configuration, ah, but will have the same database operating, an error is as follows:
Pg_restore: connecting to the database for restore
Pg_restore: [archiver (db)] Error while INITIALIZING:
Pg_restore: [archiver (db)] could not execute query: ERROR: unrecognized configuration parameter "idle_in_transaction_session_timeout
"The Command was: SET idle_in_transaction_session_timeout=0;

Pg_restore: [archiver (db)] could not execute query: ERROR: unrecognized configuration parameter "row_security
"The Command was: SET row_security=off;

WARNING: errors ignored on restore: 2

CodePudding user response:

Should be a version of the problem, what are you going to in the above check postgresl version of reduction, if less than 9.5, it is not support this option
Select the version ()