Top "Rails-postgresql" questions

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

Can't find the 'libpq-fe.h header when trying to install pg gem

I am using the Ruby on Rails 3.1 pre version. I like to use PostgreSQL, but the problem is installing the …

ruby-on-rails ruby-on-rails-3 postgresql rails-postgresql pg
How to solve privileges issues when restore PostgreSQL Database

I have dumped a clean, no owner backup for Postgres Database with the command pg_dump sample_database -O -c …

postgresql database-backups rails-postgresql
PostgreSQL date() with timezone

I'm having an issue selecting dates properly from Postgres - they are being stored in UTC, but not converting with …

postgresql datetime timezone postgresql-9.1 rails-postgresql
Postgresql adapter (pg): could not connect to server

I get this error every this I run my Rails app (It cannot connect to my local Postgresql) /Users/leonardo/.…

ruby-on-rails postgresql rails-postgresql pg
How to set up Postgres database for local Rails project?

I recently got a new machine and would now like to work on my projects from Github. I'm curious as …

ruby-on-rails postgresql ubuntu postgresql-9.1 rails-postgresql
Postgres JSON data type Rails query

I am using Postgres' json data type but want to do a query/ordering with data that is nested within …

json postgresql ruby-on-rails-4 rails-postgresql psql
Batch insertion in rails 3

I want to do a batch insert of few thousand records into the database (POSTGRES in my case) from within …

ruby-on-rails ruby ruby-on-rails-3 activerecord rails-postgresql
Rails: rake db:create:all fails to connect to PostgreSQL database

I am trying to create a Rails app that uses PostgreSQL. Here is a description of what I did. PostgreSQL …

ruby-on-rails ruby-on-rails-3 postgresql postgresql-9.1 rails-postgresql
Connection refused (PGError) (postgresql and rails)

I keep getting this error when i try to run my localhost using "$rails s": (Mac OSX 10.8.3) (ruby 2.0.0p195 (2013-05…

ruby-on-rails postgresql postgresql-9.1 postgresql-9.2 rails-postgresql
Millisecond resolution of DateTime in Ruby

I have a string like 2012-01-01T01:02:03.456 that I am storing in a Postgres database TIMESTAMP using ActiveRecord. Unfortunately, …

ruby postgresql datetime activerecord rails-postgresql