Posted over 6 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.


# 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

Flaky tests are tests that sometimes fail for no obvious reason. They are the plague of many end-to-end (E2E) test suites that automate the browser through tools like Capybara and Selenium.

Join our free training event and learn to fix any flaky test suite, even in large legacy applications.

Owner of this card:

Kim Jahn
Last edit:
over 5 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 short-lived cookies to improve usability.
Accept or learn more