Re: 9.0: plpgsql eror when restoring a database as a non superuser

Поиск
Список
Период
Сортировка
От stefan
Тема Re: 9.0: plpgsql eror when restoring a database as a non superuser
Дата
Msg-id j7v47i$e7e$1@dough.gmane.org
обсуждение исходный текст
Ответ на Re: 9.0: plpgsql eror when restoring a database as a non superuser  (Adrian Klaver <adrian.klaver@gmail.com>)
Ответы Re: 9.0: plpgsql eror when restoring a database as a non superuser
Список pgsql-general
Дерево обсуждения 
>> Therefore the only solution I see is to drop plpgsql from template1, or
>> writing a wrapper script that exploits the -l and -L options of pg_restore.
>
> Yes. Though I could see an option to create a template database without plpgsql
> in it for use by non-superuser users and leave template1 as is.
>

Adrian,

Thanks for suggesting that. I had not thought about that option and it
may just be the best.

Cheers,
Stefan.

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

Предыдущее
От: "Greg Sabino Mullane"
Дата:
Сообщение: Re: Are file system level differential/incremental backups possible?
Следующее
От: stefan
Дата:
Сообщение: Re: 9.0: plpgsql eror when restoring a database as a non superuser