Re:The PostgreSQL community debates ALTER SYSTEM
by MBCook on Sunday April 21, 2024 @10:48PM
(#40111059)
See I read that Postgres did that and thought “what a great idea!” I’ve seen so many stories of people who changed something important at runtime in their DB/router/managed switches/whatever and then forgot about it until after a restart “broke” things 2 years later and the change is lost forever.
Re:The PostgreSQL community debates ALTER SYSTEM
by nijave on Monday April 22, 2024 @03:15AM
(#40112053)
Maybe contentious but I'd argue the ability to rewrite config files at runtime with SQL is the thing that makes more sense being an extension although it's existed for so long as a core feature, it's non trivial to change.
I also think that is a feature that is rarely used, that probably shouldn't be on by default.