Technology Insights

PostgreSQL Log Entries: CDTLOG: statement: SHOW client_min_messages

I was troubleshooting an issue at work the other day regarding some PostgreSQL connections that were not closing. They were left IDLE, never closed, and eventually used up all of the possible connections (which totaled 100) configured in the  postgresql.conf configuration file. In the process of troubleshooting I noticed a bunch of Postgres log entries that I was unable to immediately pin down to what was causing the entries. Below I describe the view of the idle Postgres connections, the PostgreSQL log entries that were unfamiliar, and the cause of both.

Technology Errors

Error Starting Ruby Script/Server On A Macbook Pro Running OSX With PostgreSQL, Ruby, & Mongrel

A friend contacted me the other day because he was having an issue starting his development environment which consists of Ruby, PostgreSQL, and Mongrel. Ruby communicates with PostgreSQL using the postgres-pr gem version 0.6.1. Starting things using “ruby script/server” from within his Ruby project had been working for months without issue and there had been no confguration changes to Ruby, Postgres, or Mongrel so it appeared to not be configuration related. After getting a brief explanation of the issue I logged into his laptop and attempted to start the server. Below is the error received when attempting to start the server using “ruby script/server” via a terminal window on the Macbook Pro.

Technology Insights

Making (and Verifying) the Migration to PostgreSQL in Rails

Install After installing PostgreSQL on Windows, I converted my Rails application from MySQL to PostgreSQL with the following steps: Create a new database in PostgreSQL Installed postgres-pr gem (Ruby driver) because the postgres gem (native driver) didn’t work. Will figure out why later on. Changed the appropriate Rails config stuff in database.yml development: adapter: postgresql…