News for hackers. Stuff that matters.

A comment on At 22 years old, Postgres might just be the most advanced database yet. Parent comment

Re:At 22 years old, Postgres might just be the most advanced... by gaius on Wednesday December 05, 2018 @04:37PM (#18612851)
If you lose the root password, you can fix it in Postgres without taking the database down.
[ Parent | on HN ]
Re:At 22 years old, Postgres might just be the most advanced... by captainperl on Wednesday December 05, 2018 @10:17PM (#18615067)
There are several ways to update the root password in MySQL with zero down-time, either by manipulating the user table, using replication, or using other accounts (ie. most people grant excessive privileges to role accounts.)

https://www.percona.com/blog/2014/12/10/reset-mysql-root-pas...

[ Parent | on HN ]