Re: pg_dumpall

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dumpall
Дата
Msg-id 22213.1045754482@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_dumpall  ("Donald Fraser" <demolish@cwgsy.net>)
Список pgsql-admin
"Donald Fraser" <demolish@cwgsy.net> writes:
> My question now would be, is there an easy way to place your own objects
> into pg_catalog for template0?

Changing template0 is exactly what you are NOT supposed to do, as it
breaks what pg_dump is trying to accomplish.

However, you could probably just edit the dump file to replace the
references to template0 with template1.  When you reload the dump,
you will get lots of errors as the customized objects coming in from
the dump collide with the ones copied from template1 --- but that's
what you want.

            regards, tom lane

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

Предыдущее
От: "Al Sutton"
Дата:
Сообщение: Logging for psql only
Следующее
От: Robert Treat
Дата:
Сообщение: Re: uppercase = lowercase