Exclusive lock for database rename

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Exclusive lock for database rename
Дата
Msg-id 200511031811.52314.peter_e@gmx.net
обсуждение исходный текст
Ответы Re: Exclusive lock for database rename  (Peter Eisentraut <peter_e@gmx.net>)
Re: Exclusive lock for database rename  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Someone wanted to rename a database while someone else was running a 
rather long pg_dump, so the rename had to wait, and everyone else had 
to wait for the rename because no new connections would be allowed.  
It's clear that we need to prevent new connections to the database 
being renamed, but isn't there a less intrusive way to do that (row 
locks?)?  Right now, everyone with createdb privileges effectively has 
DOS superpowers.

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


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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: Reducing the overhead of NUMERIC data
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Rename the members of CommandDest enum so