thinknimble / tn-spa-bootstrapper

A production-ready Django SPA app on Heroku in 20 minutes or less!
https://tn-spa-bootstrapper-staging.herokuapp.com/
MIT License
8 stars 9 forks source link

fix init db script for pg15 #315

Closed r2dliu closed 2 months ago

r2dliu commented 2 months ago

What this does

Postgres 15 changes how create permissions work and makes them more strict: https://www.enterprisedb.com/blog/new-public-schema-permissions-postgresql-15

Essentially, without this extra line any migrations that would create new tables will fall flat

Heroku defaults to creating postgres 15 dbs, so it makes sense for us to stay up to date by developing on pg15 locally as well. Script should not affect existing pg 14 permissions.