Top "Rails-postgresql" questions

Open source RDBMS (relational database management system) when used in conjunction with the Ruby on Rails framework.

Rails :order by date in Postgres returning incorrect order

I have a model called Story that I'm trying to order by the created_at date. Since I've hosted my …

ruby-on-rails rails-postgresql
Error when creating unaccent extension on PostgreSQL

I am trying to configure PostgreSQL to use fulltext search in my rails app as mentioned in this Railscast. I …

postgresql full-text-search postgresql-9.1 rails-postgresql unaccent
Rails 4.0.1 on Heroku, can't create database

I can't get rake db:migrate to run on my rails 4.0.1 app on Heroku. I'm guessing that I don't have …

ruby-on-rails ruby heroku ruby-on-rails-4 rails-postgresql
Rails 5 how to clear or delete production postgres database

I am trying to delete a production database so I can start fresh. When I upgraded to rails 5 from rails 4, …

ruby-on-rails ruby rake ruby-on-rails-5 rails-postgresql
Set default value for Postgres JSON column in Rails < 4

So I'm starting to use the Postgres JSON datatype, now that there's a lot of fun stuff you can do …

ruby-on-rails json ruby-on-rails-3.2 rails-postgresql pg
Rails pg gem Incompatible library version

I'm getting the following 'incompatible library version' error when I try and access my Ruby on Rails website in development …

ruby-on-rails ruby-on-rails-4 rubygems rails-postgresql
rake db:create fails, authentication problem with postgresql 8.4

first things first, please excuse my utter noobness. I really tried to find a solution out there, but now i'm …

ruby-on-rails authentication rake rails-postgresql
Rails - Postgres - could not connect to server: Connection refused (PG::ConnectionBad)

Yesterday I've install Postgres and pgAdminIII, all worked correctly, but after reload it stopped working. After rails server I've got …

ruby-on-rails database sqlite database-connection rails-postgresql
How to Connect to Docker Postgres Container from Host Machine

I put together a Rails dev environment by following instructions from https://docs.docker.com/compose/rails/ It works, but …

postgresql docker rails-postgresql remote-connection
Rails - How to add a BLOB column using ActiveRecord?

I need to create a BLOB column to store some text content. I have read somewhere that I need to …

ruby-on-rails-3 blob rails-postgresql