pg_dump not dumping default_text_search_config WAI?
Philip Warner <pjw@rhyme.com.au>
From: Philip Warner <pjw@rhyme.com.au>
To: pgsql-hackers@postgresql.org
Date: 2025-11-08T16:14:35Z
Lists: pgsql-hackers
I just got bitten by dumping and restoring a database to a new cluster, and the default_text_search_config was not copied for the database. A check of the dump file shows no 'ALTER DATABASE' command. I used an 'ALTER DATABASE...' to set it correctly and then did a dump, and the config was not in the dump. From my understanding this is a cluster setting that only applies to this database, and ISTM that database config *should* be in the dump. Is this WAI? Are there other database settings that are not exported by a pg_dump?