unrecognized configuration parameter "default table access method" google cloud
Mar 3
I try to import some files to a PostgreSQL database but I get this error:
Falha Importar:
SET
SET
SET
SET
SET
set_config ------------
(1 row)
SET
SET
SET
SET
SET
Import error: exit status 3 ERROR: unrecognized configuration parameter "default_table_access_method"
postgresql1 answer
Accepted answer · original discussion
Mar 4
You are importing a PostgreSQL v12 pg_dump into something that is obviously based on an earlier version of PostgreSQL.
This error is harmless (the parameter default_table_access_method was introduced in v12), but you may have more interesting problems with other new v12 features. If the rest of the import works without error, you are probably fine, but keep in mind that downgrading PostgreSQL is not supported.
You would be best off using the same version throughout. If you cannot have that locally because the hosted database is a closed source fork, that is a good point against using it.
0 question comments
Use comments to ask for clarification. Post a solution as an answer.
No question comments on this page.