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