Re: pg_dump not dumping default_text_search_config WAI?
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Philip Warner <pjw@rhyme.com.au>
Cc: pgsql-hackers@postgresql.org
Date: 2025-11-08T17:06:50Z
Lists: pgsql-hackers
Philip Warner <pjw@rhyme.com.au> writes: > 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. IIRC you'd need to use --create to prod pg_dump to produce a CREATE DATABASE command as well as any database-level ALTER commands. regards, tom lane