Posted about 4 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
Check out our new e-book:
Learn to structure large Ruby on Rails codebases with the tools you already know and love.
