Trying to enable `postgis` but getting ` ** (DBConnection.ConnectionError) tcp recv: closed` when executing

[jakewlacey]

Postgres with postgis

I ended up hitting some snags getting this running so I thought I would write down what worked for me to get postgis working. One note: if you go with the default VM size of shared-cpu-1x - 256, running CREATE EXTENSION postgis causes the db to run out of memory and you see this as a network disconnect. I spent ages thinking the issue was something more sinister! flyctl postgres create if you’re using shared-cpu-1x - 256, bump the memory: flyctl scale memory 1024 Clone the postgres-ha repo E…