Re: DROPped database doesn't go away Postgres7.4

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: DROPped database doesn't go away Postgres7.4
Дата
Msg-id 11084.1094079251@sss.pgh.pa.us
обсуждение исходный текст
Ответ на DROPped database doesn't go away Postgres7.4  (Joseph Sadove <jsadove@beltion.net>)
Список pgsql-admin
Joseph Sadove <jsadove@beltion.net> writes:
> When I DROP it again and just re- CREATE it, without doing anything, all the
> schemas and objects are there as if I never dropped it.

It sounds to me like you have put a bunch of junk into the template1
database.  This was a bad move :-(.  What you can do as far as restoring
your old database goes is to create your new database using template0
instead of template1 as the source.  See
http://www.postgresql.org/docs/7.4/static/manage-ag-templatedbs.html

In the longer term, you might want to go back to a pristine template1.
It's possible to drop template1 and recreate it from template0, but
there are some gotchas to dodge.  Look up the detailed description
of how to do it at techdocs.postgresql.org --- I don't have the exact
URL at hand.

            regards, tom lane

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

Предыдущее
От: Seamus Ryan
Дата:
Сообщение: initdb - (InitPostgres) - FATAL: database "postgres" does not exist
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Runtime config of PGSQL