Reset the default postgres role credentials

postgres roles & traffic

// what it does

Rotates the credentials of the built-in `postgres` role on the branch — the recovery move when the default admin credential is lost or suspected compromised.

// shell

$ pscale role reset-default mydb main

// gotcha

Every connection still using the default postgres role breaks immediately; the new credentials print once. Ideally nothing in production uses the default role at all — create named roles per consumer instead.