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 по дате отправления
От: Joel Jacobson
Дата:
Сообщение: Re: Optimize LISTEN/NOTIFY
От: Jim Jones
Дата:
FAQ