Save 36% for Black Friday! Learn more

Julio Cesar Fausto

Joined

800 Experience
1 Lesson Completed
1 Question Solved

Activity

For anyone having this issue in 2020, the problem is that the user deploy was not created with SUPERUSER privileges which are required to create/enable extensions in Postgres.

In order to solve that, you have to give this privilege to the user deploy by doing the following:

1 - ssh root@machine-address
2 - sudo su - postgres
3 - psql
4 - ALTER ROLE deploy SUPERUSER;
5 - \q
6 - exit

Now, re-run the deployment command: bundle exec cap production deploy and it should work.

If you wan't to revoke the SUPERUSER privilate later for the deploy user, repeat steps 1 to 6 above, replacing step for by:

ALTER ROLE deploy NOSUPERUSER;

I hope this helps someone :)

logo Created with Sketch.

Screencast tutorials to help you learn Ruby on Rails, Javascript, Hotwire, Turbo, Stimulus.js, PostgreSQL, MySQL, Ubuntu, and more. Icons by Icons8

© 2022 GoRails, LLC. All rights reserved.