On 05/24/2014 12:03 AM, Jaime Casanova wrote: > On Fri, May 23, 2014 at 10:53 PM, Vik Fearing <vik.fear...@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?
You can ALTER DATABASE from anywhere. -- Vik -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
