On Fri, May 23, 2014 at 11:06 PM, Vik Fearing <vik.fear...@dalibo.com> wrote: > 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. >
ah! doh! right! don't know why i was convinced you need to connect to the database to execute ALTER DATABASE -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593 4 5107566 Cell: +593 987171157 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
