Re: Fixing the loss of 'template1'

Поиск
Список
Период
Сортировка
От Gary Chambers
Тема Re: Fixing the loss of 'template1'
Дата
Msg-id alpine.OSX.2.01.1203070946100.2542@localhost
обсуждение исходный текст
Ответ на Re: Fixing the loss of 'template1'  (Marti Raudsepp <marti@juffo.org>)
Список pgsql-general
Marti,

> As far as I can tell, the only way to remove the template1 database is to
> rename it.

Templates are databases with the datistemplate column set to true.  A
superuser can:

UPDATE pg_database SET datistemplate=false where datname='blah';
DROP DATABASE blah;

As far as Pg is concerned, there is no problem with removing the template1
or postgres databases.  That is not (or may not be) the case for some
utilities and Linux distributions out there that expect them to exist where
used as defaults.  I haven't yet tried removing template0.

--
Gary Chambers

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

Предыдущее
От: Marti Raudsepp
Дата:
Сообщение: Re: Fixing the loss of 'template1'
Следующее
От: Andy Colson
Дата:
Сообщение: rounding a timestamp to nearest x seconds