Re: restoring a database to its initial state

Поиск
Список
Период
Сортировка
От Adrian von Bidder
Тема Re: restoring a database to its initial state
Дата
Msg-id 201003131606.11052@fortytwo.ch
обсуждение исходный текст
Ответ на restoring a database to its initial state  (Manlio Perillo <manlio.perillo@gmail.com>)
Список pgsql-general
Hyho!

On Saturday 13 March 2010 13.48:14 Manlio Perillo wrote:

> Usually when I need to restore a database to its initial state, what I
> do is to simply drop it, and then re-create it.
>
> However on a shared hosting this is not possible.

Create a schema, modify your default search path so that you're always
working in your new schema, then you can just drop schema foo cascade;

cheers
-- vbi


--
Today is Boomtime, the 72nd day of Chaos in the YOLD 3176

Вложения

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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: restoring a database to its initial state
Следующее
От: Gordon Shannon
Дата:
Сообщение: unexplained autovacuum to prevent wraparound