landho Posted April 10, 2023 Share Posted April 10, 2023 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! Link to comment Share on other sites More sharing options...
wolstech Posted April 10, 2023 Share Posted April 10, 2023 Krydos has to create extensions for you. 1 Link to comment Share on other sites More sharing options...
Krydos Posted April 11, 2023 Share Posted April 11, 2023 The extension pgcrypto has been created on the database landho_ratemyskipper_production. Link to comment Share on other sites More sharing options...
Recommended Posts