I'm trying to enable extension by issuing SQL command 'create extension earth_distance with schema extensions;' but what I get is error saying 'could not open extension control file "/usr/share/postgresql/14/extension/earth_distance.control": No such file or directory'. I'm running a local instance of supabase in docker, but I'm getting the same error in online instance too.

Hello @avalanche! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.

It probably means that extension doesn't exists in your postgres setup

avalanche (2022-05-19)

I just realized I misspelled extension name 😆 It's not earth_distance, it's earthdistance. Cube extension is also required so I ended up with lines like this: create extension cube with schema extensions; create extension earthdistance with schema extensions;