Fixing Postgres pg_load error: unrecognized configuration parameter “row_security”

When using pg_load, you may get an error like the following:

unrecognized configuration parameter "row_security"
Command was: SET row_security = off;

WARNING: errors ignored on restore: 546

This is an indication that you are using the 9.5 pg_dump/pg_load against an earlier database.

To provide this:

echo $PATH
/E/Program Files/PostgreSQL/9.5/bin

To fix this, you’ll need to change the PATH to include the correct Postgres version.

Leave a Reply

Your email address will not be published. Required fields are marked *