Re: BUG #14192: pg_dump/pg_restore omit setting search_path in restored db

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: BUG #14192: pg_dump/pg_restore omit setting search_path in restored db
Дата
Msg-id CAKFQuwZu=Wuap2Od6zi4jmafNb+UrV+unQfB+n+yw3biBYcC_g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #14192: pg_dump/pg_restore omit setting search_path in restored db  ("Hans Buschmann" <buschmann@nidsa.net>)
Список pgsql-bugs
On Thursday, June 16, 2016, Hans Buschmann <buschmann@nidsa.net> wrote:
>
> I understand the differences between cluster and database and pg_dumpall
> and pg_dump.
>
> In my opinion a pg_dump of a database should pack all informations of the
> application (the database) in the dumpfile in one container, to be able to
> restore it full functional at a different place.
>
> Because the search_path is a crucial information for the application to
> work correctly (like any other object inside the database) it should be
> packed into this container called pg_dump dumpfile.
>
> This should be independent of the current implementation, where we store
> the search_path in a cluster record: The informatation belongs semantically
> to the content of the database, even if it is stored elsewhere.
>
> My concern  with promoting this suggestion is to avoid trouble in
> emergency cases, logical consistency, intuitive usage of pg_dump and smooth
> experience for non-expert people.
>
>
You've made your opinion quite clear and likely others share it.  But
someone needs to design and write a patch - we can't commit opinions.  I'd
suggest, at least pushing for this after 9.6 is released.  No one is really
interested in pondering this days before beta2 is to be released.  I'd
suggest researching past discussions on the topic, I'm sure there are some,
in the meantime.

David J.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: jeremy.rumerio@gmail.com
Дата:
Сообщение: BUG #14196: Processes terminated with exception 0xFFFFFFFF
Следующее
От: "Hans Buschmann"
Дата:
Сообщение: Re: BUG #14192: pg_dump/pg_restore omit setting search_path in restored db