Re: Recover anything from dropped database?

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Recover anything from dropped database?
Дата
Msg-id 200702151805.41949.peter_e@gmx.net
обсуждение исходный текст
Ответ на Re: Recover anything from dropped database?  ("John D. Burger" <john@mitre.org>)
Список pgsql-general
John D. Burger wrote:
> Still, I'm trying to figure out how to avoid my screw-up in the
> future.

The good old "don't do everything as root" comes to mind.

> I'm not that familiar with the permissions stuff - is there
> any way to take away "drop DB privileges" from a user, or even all
> users?  Again, this is PG 7.4.

There is no specific "drop database" privilege, but only owners or
superusers can drop things.  So do your general transactional
operations as some other user.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

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

Предыдущее
От: Emi Lu
Дата:
Сообщение: Re: postgresql 8.2 Installation error at "gmake"
Следующее
От: Emi Lu
Дата:
Сообщение: Re: postgresql 8.2 Installation error at "gmake"