Your default postgres user is named like your linux user. That default user has limited access privileges, which can cause issues such as:

DatabaseCleaner needs to disable foreign key constraints before it can wipe the database.
Importing a remote dump with geordi Show archive.org snapshot
Asking Postgres to show the storage path of a database

Doing these things without a superuser will show a Postgres error or (in Ruby) raise PG::InsufficientPrivilege.

To do so, the application's PostgreSQL user must be a superuser. Grant superuser rights like this:

$ sudo -u postgres psql
# ALTER USER <your username> WITH SUPERUSER;

stackoverflow.com

Dominik Schöler

makandra.de

Say thanks4

Last edit

About 6 years ago

Henning Koch

License

Source code in this card is licensed under the MIT License.

Async control flow in JavaScript: Promises, Microtasks, async/await

Slides for Henning's talk on Sep 21st 2017.

Understanding sync vs. async control flow

Talking to synchronous (or "blocking") API

print('script start')
html = get('/foo')
print(html)
print('s...

Delivering Carrierwave attachments to authorized users only

Preparation

To attach files to your records, you will need a new database column representing the filename of the file. To do this, add a new migration (rails g migration <name>) with the following content:

class AddAttachmentToNotes...

Posted by Dominik Schöler to makandra dev (2018-02-06 14:51)

PostgreSQL: Upgrading your user to a superuser

Related cards:

Understanding sync vs. async control flow

Talking to synchronous (or "blocking") API

Preparation

Summary

Introduction