Exclusive lock for database rename

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Exclusive lock for database rename
Date: 2005-11-03 17:11:52
Message-ID: 200511031811.52314.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Marc G. Fournier 2005-11-03 17:17:33 Re: pgsql: Rename the members of CommandDest enum so
Previous Message Alvaro Herrera 2005-11-03 17:11:40 pgsql: Rename the members of CommandDest enum so they don't collide with