I have system where we perform large number of inserts and updates query(something upsert as well) I see occasionally error on my logs that states .. PG::ObjectNotInPrerequisiteState: ERROR: att...

I'm using PostgreSQL with nodejs and pg. Everything works fine, but I want to output a result from PostgreSQL as a nested json - as if I was working with MongoDB or similar. My 2 tables from Postg...

I want to take the results of a pl/pgsql function, that returns a set of records and user AMS to serialize the results. How can I do this?

I am using Ubuntu 12.10 64-bit and I have following packages installed : dpkg --get-selections | grep postgre output: postgresql postgresql-9.1 postgresql-client postgresql-client-9.1 postgresq...

I am deploying a simple application to AWS Elastic Beanstalk. However, the moment I put gem 'pg' in the Gemfile and push these to Elastic Beanstalk. I get the following errors in my logs: --------...

There are variations of this question bouncing around SO, but none of them seem to have an answer that solves my problem. I am running OSX Lion (10.7.3). The latest XCode is installed. I've insta...

I am learning Ruby on Rails and trying to develop an application. In my application I am trying to use the default SQLite database in the Development Mode and PostgreSQL in the Production Mode. But...

I am trying to use the prepared statements in ruby with pg gem. This is how my statement looks like conn.prepare("insert_values", "insert into " + objectName + "(" + headerStr + ") values (" + pre...

I have a rails app (4.1.5) backed by a postgres database (9.2.13) using the pg gem (0.17.1), unicorn server (1.1.0) with 2 worker processes. The rails app runs jobs using sidekiq (2.17.7) At some...

I tried to install pg Gem on Mac El Capitan, but I always get this error: Gem::Installer::ExtensionBuildError: ERROR: Failed to build gem native extension. /System/Library/Frameworks/Ruby.fram...

This is how looks my Gemfile: source 'http://rubygems.org' gem 'rails', '3.1.2' #gem 'sqlite3' gem 'mysql2' gem "rvm", "~> 1.9.2" gem 'authlogic' gem "taps", "~> 0.3.23" gem "paperclip", "...

I'm using the pg_search gem in a Rails app to search against users - their bios and associated skill model. Users are developers, so their skills include things like "CSS", "C++", "C#", "Objective ...

I am on osx 10.6.7 trying to run bundle install on a new rails 3.0.7 app and it keeps failing when trying to build the pg gem. It keeps telling me that I have need the developer tools. But as far a...

I finally managed to get the 'pg' gem install after spending hours trying to figure out why it's not working... at the end I entered sudo env ARCHFLAGS="-arch x86_64" gem install pg -v 0.12.2 -- -...

I'm attempting to run bundle in my Rails project on OSX 10.9. It fails when getting to the pg gem with this error: Gem::Installer::ExtensionBuildError: ERROR: Failed to build gem native extension....

I'm trying to setup postgres on OSX. I was having problems with a rails app ('cannot connect to database') and reinstalled postgres with homebrew. I cannot issue postgres commands from terminal now...

I am currently taking a databases course and one of the lab questions has me stumped as to how to implement the above and indeed, if it was even possible. I have tried searching the docs but the tr...

I recently updated to rails 4.1.6 and ruby 2.1.3p242. I also updated all gems on my system. After creating a new app, I keep getting a pg_ext load file error on running the server. I'm on windows 8...

My database uses PostgreSQL. I develop on Mac and this line is needed: # db/schema.rb on Mac environment enable_extension "plpgsql" However, the extension is not required on Linux. In this ca...

I have tried following this answer to get the gem to work, but it wont. I have my projects set up such that individuals projects have there own gems instead of all themes gems living in global spac...

I want to execute this query. INSERT INTO items (title, description, start_date, expiration_date, type, quantity, state, sold, cover_photo_file_name, cover_photo_content_type, cover_photo_file_siz...

I'm trying to run the following raw query in rails, only to see it fail: query = 'SELECT * FROM users WHERE id IN ($1);' results = ActiveRecord::Base.connection.exec_query(query, "My query", [ [1,...

I am trying to call a Ruby script (which connects to a postgres db) using the rails controller below, however it appears it is having problems loading one of the PG gem files. I have set my require...

I am running my rails 4 application with Postgres db, sometime my db connection getting lost with the below exception PG::ConnectionBad: PQconsumeInput() server closed the connection unexpectedl...

I'm using Postgres.app on OS X (10.8.3). I have modified my PATH so that the bin folder for the app is before all others. Rammy:~ phrogz$ which pg_config /Applications/Postgres.app/Contents/MacOS/...