Re: SQL access to database attributes - Mailing list pgsql-hackers

From Jaime Casanova
Subject Re: SQL access to database attributes
Date
Msg-id CAJKUy5heQmtGCODxUeQNwsBN60DJB53Nz88HAjjf88m9y_v8Sg@mail.gmail.com
Whole thread Raw
In response to SQL access to database attributes  (Vik Fearing <vik.fearing@dalibo.com>)
Responses Re: SQL access to database attributes  (Vik Fearing <vik.fearing@dalibo.com>)
List pgsql-hackers
On Fri, May 23, 2014 at 10:53 PM, Vik Fearing <vik.fearing@dalibo.com> wrote:
>
> It was suggested to me that these options should either error out if
> there are existing connections or terminate said connections.  I don't
> agree with that because there is no harm in connecting to a template
> database (how else do you modify it?), and adding a reject rule in
> pg_hba.conf doesn't disconnect existing users so why should turning off
> ALLOW CONNECTIONS do it?
>

Which lead us to the question: you need to connect to the database to
modify it, don't you? then, how do you change ALLOW CONNECTIONS to
true?

--
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
Phone: +593 4 5107566         Cell: +593 987171157



pgsql-hackers by date:

Previous
From: Vik Fearing
Date:
Subject: SQL access to database attributes
Next
From: Vik Fearing
Date:
Subject: Re: SQL access to database attributes