Skip to main content
PG::InsufficientPrivilege: ERROR: permission denied to create extension "pgcrypto" HINT: Must be superuser to create this extension. : CREATE EXTENSION IF NOT EXISTS "pgcrypto"
For anyone having this issue in 2020, the problem is that the user `deploy` was not created with SUPERUSER privileges which are required to create/enable extensions in Postgres. In order to sol...
Julio Cesar Fausto replied

Polymorphic Search
I have a basic model structure like this: ``` class History < ActiveRecord::Base belongs_to :historical, polymorphic: true, touch: true end ``` with several related models: `has_m...
Dan Tappin posted

How do I structure a Bookings table for two models?
I've primarly built out support to book a flight, and now I'm looking to offer the ability to book a hotel as well. I'm looking for some insight on the best way to model this: Currently there is...
Taylor Cooney posted

Transactions
If I am working on a db with millions of users and i have a job that requires updating multiple tables, what is the best way to approach this? I was thinking to wrap it in a transaction but the iss...
Jacob Abraham posted

How do I manage business hours for a store?
Thanks @ChrisOliver. I got it working with your help! I really appreciate it, it seems rather trivial but a core function of my app - also, it seems like between the two of us we've provided the mo...
Taylor Cooney replied Solved

PG::ConnectionBad: FATAL: password authentication failed for user "deploy" capistrano rails
Hi I am working on deploying rails application to digital ocean everything is worked fine. just stuck on that final step: when I am runing `cap production deploy` I am getting &gt...
Hitesh Ranaut posted

403 errors on Nginx server
Hello, I have installed ruby on rails on digital ocean with NGINX and Passanger. the site was working find but after trying to install free ssl, it goes full wrong. i was following this article...
SMEHSAN posted

find_by not returning array but class insance
What am I missing please? class Choice < ApplicationRecord belongs_to :choiceable, polymorphic: true belongs_to :room_item, optional: false end create_table "choices", force: :cas...
jason Mardell posted

How can I improve query time in SQL ? (PostgreSQL)
Any ?
Boris Bresciani replied Solved

TinyTds::Error (closed connection): when using Apache/Passenger
Hello Chris, I am only using Puma or Passenger, definitely not both at the same time. When using Puma I start the rails server (i.e rails s -e production) from the application directory and the pa...
William Jones replied Solved

Subscribe to the newsletter

Join 31,353+ developers who get early access to new screencasts, articles, guides, updates, and more.

    By clicking this button, you agree to the GoRails Terms of Service and Privacy Policy.

    More of a social being? We're also on Twitter and YouTube.