I have a big dump file that is generated by
pg_dump that comes with PostgreSQL v12 client, and it is in customized format instead of plain sql text. The version of the server is PostgreSQL v12 too.
Now I need to reload the file into a PostgreSQL v11 server, and I get a error message:
unrecognized configuration parameter "default_table_access_method"
I guess that this parameter is introduced by PG12, so PG11 can't recognize it, even though I use the 12 version of
Because the file is huge and in binary format, I can NOT edit it to remove the line manually.
I tested that
pg_restore test_file -f plain.sql with a test dump file, and it looks like work, and I can remove the line from the plain SQL file.
But the real dump file is about 30GB, the plain SQL file expanded from the binary might be bigger (the working database occupies 300GB disk space).
Is there a way in it, I can cleanly reload it into PG11, only without the line "SET default_table_access_method = heap;"?
In fact, the following all can be ignored, because they are all default values:
SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); SET check_function_bodies = false; SET xmloption = content; SET client_min_messages = warning; SET row_security = off; SET default_tablespace = '';