How do I change the maintenance window for Heroku Postgres?

Resolution

You can check to see if maintenance is required on databases using the CLI tools:

heroku pg:maintenance -a APP_NAME
Maintenance not required, window is Fridays 22:00 to Saturdays 02:00 UTC

Your maintenance window can be changed using:

heroku pg:maintenance:window postgres-slippery-100 "Sunday 06:00" -a APP_NAME

This will change your maintenance window to every Sunday morning, 06:00 UTC to 07:00 UTC.

If you want greater control over maintenance, you can manually run maintenance on your database using:

heroku pg:maintenance:run postgres-slippery-100 -a APP_NAME