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

Re: ALTER DATABASE and datallowconn

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: ALTER DATABASE and datallowconn
Date: 2012-05-03 13:01:25
Message-ID: CABUevEyu4ZHbZUd_NiUUtfCnOTLUubQUBRgm30TNkHiymLerCQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Thu, May 3, 2012 at 2:48 PM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> 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

superusers bypass datconnlimit, but not datallowconn, don't they?

-- 
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

In response to

pgsql-hackers by date

Next:From: Andres FreundDate: 2012-05-03 13:08:19
Subject: outdated comment in heapam.c
Previous:From: Robert HaasDate: 2012-05-03 12:54:44
Subject: Re: Torn page hazard in ginRedoUpdateMetapage()

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