Posted over 3 years ago. Visible to the public.

postgresql create extension without giving the application superuser rights

If you need a postgresql extension for your database it isn't a good idea to give your applications database user superuser rights (like many people on stackoverflow think)

Just login to the database with a superuser account (e.g. postgres) and create the extension with it.

Example:

Copy
# with the default configuration of postgresql you normally can login as `postgres` user # without a password if you use the systems `postgres` user $ sudo su -l postgres $ pgsql postgres=# \c your_database; psql (9.3.9, server 9.3.5) You are now connected to database "your_database" as user "postgres". your_database =# CREATE EXTENSION "uuid-ossp"; CREATE EXTENSION your_database =# \q $ logout

By refactoring problematic code and creating automated tests, makandra can vastly improve the maintainability of your Rails application.

Owner of this card:

Avatar
Kim Jahn
Last edit:
almost 3 years ago
by Kim Jahn
About this deck:
We are makandra and do test-driven, agile Ruby on Rails software development.
License for source code
Posted by Kim Jahn to makandra dev
This website uses cookies to improve usability and analyze traffic.
Accept or learn more