You can add location information to your Tweets, such as your city or precise location, from the web and via third-party applications. You always have the option to delete your Tweet location history. Learn more
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".
Extensions can execute arbitrary code though. Requiring superuser permissions for that operation makes complete sense IMO.
