[Solved] CREATE permission required for 'pgcrypto' extension

[landho]

Hello!

To enable the 'pgcrypto' extension on my postgresql database, my user requires the 'CREATE' permission for my database. Can I have this permission enabled?

Database: landho_ratemyskipper_production

User: landho_ratemyskipper_production_user

Server: Tommy

 

The error in my logs gives me:

ActiveRecord::StatementInvalid: PG::InsufficientPrivilege: ERROR: permission denied to create extension "pgcrypto"
HINT: Must have CREATE privilege on current database to create this extension.

 

Thank you!

[wolstech]

Krydos has to create extensions for you.

[Krydos]

The extension pgcrypto has been created on the database landho_ratemyskipper_production.