Cannot enable PostGIS

I am having trouble enabling postgis extension in postgres. I saw people having similar problem when the memory was too low on the instance. But even if I rise memory to 2048 postgres still crashes when adding postgis extension.

After updating the machine with command:

fly machine update 148e275b15e989 --memory 512 --app skyja-db

when I try to restart app I get:

Attempting to acquire lease(s)
Machine 148e275b15e989: success
Error no active leader found

This is a known issue that we are working on. The health checks are getting de-registered on update. If you restart that machine using flyctl machine restart 148e275b15e989 it should re-register the checks.

1 Like