create extension hstore needs superuser

[5at]

After following instructions in "Getting Started" to create database and user the AuditSchema.sql fails as the "create extension if not exists hstore;" statement requires superuser access (version 9.5.9 of postgresql).

[kyleu]

Thanks for finding this, I added the hstore column recently, and usually run superuser locally.

[kyleu]

Hmm, looks like postgres requires superuser to allow the extension. I use an hstore for the audit stuff, I could update the documentation to require a superuser, but that seems like overreaching. It's only for the tags, I may just pull that out for now.

[padurean]

Hi, what is the best solution for this? For the moment i've altered the role to be superuser.

[kyleu]

The alternative would be creating the hstore extension with a superuser, then removing the extension creation from ./ddl. Hstores are just too useful to give up :)