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
Does your version of Ruby on Rails still receive security updates?
Rails LTS provides security patches for old versions of Ruby on Rails (3.2 and 2.3).
