permission denied to create extension "hstore"解决方案

首先  

sudo -u postgres psql postgres

进入数据库后输入命令

ALTER USER mydb_user WITH SUPERUSER;        (把某个用户设置为超级用户)

 

原帖: http://www.wenda.io/questions/1606940/permission-denied-to-create-extension-uuid-ossp.html