Posted over 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
Once an application no longer requires constant development, it needs periodic maintenance for stable and secure operation. makandra offers monthly maintenance contracts that let you focus on your business while we make sure the lights stay on.
