Postgres issue: I want my application user to be able to create extensions so application frameworks can enable any extensions they need on initial migration. It appears that there isn't a permission that allows extension creation other than superuser. Any ideas?
-
-
I think I'm going to create an extensions schema in template1 and add it to the search path so any new database will have them enabled, but it seems like I should be able to just say "this user should be allowed to create extensions".
-
It still adds an additional step but at least I only have to remember it once.
- 1 more reply
New conversation -
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.