pg_dump not dumping default_text_search_config WAI?
От
Philip Warner
Тема
pg_dump not dumping default_text_search_config WAI?
Дата
Msg-id
d98b9174c2babf564e68415061460e0f@rhyme.com.au
Список
Дерево обсуждения
pg_dump not dumping default_text_search_config WAI? Philip Warner <pjw@rhyme.com.au>
Re: pg_dump not dumping default_text_search_config WAI? Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_dump not dumping default_text_search_config WAI? Philip Warner <pjw@rhyme.com.au>
Re: pg_dump not dumping default_text_search_config WAI? Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_dump not dumping default_text_search_config WAI? Philip Warner <pjw@rhyme.com.au>
Re: pg_dump not dumping default_text_search_config WAI? Philip Warner <pjw@rhyme.com.au>
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 по дате отправления
От: Jim Jones
Дата: