pg_dump not dumping default_text_search_config WAI?

From: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
To: pgsql-hackers(at)postgresql(dot)org
Subject: pg_dump not dumping default_text_search_config WAI?
Date: 2025-11-08 16:14:35
Message-ID: d98b9174c2babf564e68415061460e0f@rhyme.com.au
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
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?

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim Jones 2025-11-08 16:30:57 Re: [PATCH] Add pg_get_tablespace_ddl() function to reconstruct CREATE TABLESPACE statement
Previous Message Joel Jacobson 2025-11-08 15:04:42 Re: Optimize LISTEN/NOTIFY