pg_dump not dumping default_text_search_config WAI? - Mailing list pgsql-hackers

From Philip Warner
Subject pg_dump not dumping default_text_search_config WAI?
Date
Msg-id d98b9174c2babf564e68415061460e0f@rhyme.com.au
Whole thread Raw
Responses Re: pg_dump not dumping default_text_search_config WAI?
List 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?


pgsql-hackers by date:

Previous
From: "Joel Jacobson"
Date:
Subject: Re: Optimize LISTEN/NOTIFY
Next
From: Jim Jones
Date:
Subject: Re: [PATCH] Add pg_get_tablespace_ddl() function to reconstruct CREATE TABLESPACE statement