Rotate a Database Password With Only Seconds of Downtime

[julia-kafarska]

Full tutorial with screenshots: https://blog.light-cloud.com/tutorials/rotate-database-password

Part 6 of 8 of the series Databases on Light Cloud.

Rotate a Light Cloud PostgreSQL password safely: choose the new password, update DATABASE_URL first, rotate when the deploy finishes. 7 seconds of errors, not 2 minutes.

Level: Intermediate · Time: about 15 minutes · Plan: Lite · Stack: PostgreSQL, Node.js, Express

Steps

• Step 1: Choose the new password
• Step 2: Save it on the app first
• Step 3: Get the rotation ready
• Step 4: Rotate when the deploy is live
• Step 5: Update everything else

Source code: https://github.com/light-cloud-com/tutorial-database-basics

---

Questions, problems with a step, or a screen that no longer matches the console? Reply here. Every tutorial is re-run on the live platform before it is published, and this thread is where fixes get discussed.