3 ms·
I think the problem here is not only related to cloud environments. Is having an SQL command that writes the configuration file a good idea to start with? It's
by alerighi 2y ago
I think the problem here is not only related to cloud environments. Is having an SQL command that writes the configuration file a good idea to start with? It's probably something dangerous, I prefer to SSH into the machine and edit the config file by hand, possibly adding comments describing why I've set a parameter to a specified value, rather than doing it with an SQL command.
I also think that is a feature that is rarely used, that probably shouldn't be on by default.
- MBCook 2y agoSee 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.
- nijave 2y agoMaybe 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.