Exclusive lock for database rename - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Exclusive lock for database rename
Date
Msg-id 200511031811.52314.peter_e@gmx.net
Whole thread Raw
Responses 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>)
List 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 by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Reducing the overhead of NUMERIC data
Next
From: Alvaro Herrera
Date:
Subject: Re: [COMMITTERS] pgsql: Rename the members of CommandDest enum so