Skip site navigation (1) Skip section navigation (2)

Re: ALTER DATABASE and datallowconn

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: ALTER DATABASE and datallowconn
Date: 2012-05-03 12:48:43
Message-ID: CA+U5nM+5mUBYSuKLhZs-WGFXprTFMk+L7YBbHJNa+D3prWCxFA@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Thu, May 3, 2012 at 1:31 PM, Magnus Hagander <magnus(at)hagander(dot)net> wrote:

> Is there a particular reason we don't have an ALTER DATABASE switch
> that controls the datallowconn, or is it just something "missed out"?

I think it can be removed, or rather deprecated.

datconnlimit can be set to 0

If we need to special case template0 then we should just do that. No
need to add a column to do it.

-- 
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

In response to

Responses

pgsql-hackers by date

Next:From: Robert HaasDate: 2012-05-03 12:54:44
Subject: Re: Torn page hazard in ginRedoUpdateMetapage()
Previous:From: Kevin GrittnerDate: 2012-05-03 12:46:57
Subject: Re: "unexpected EOF" messages

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group