Category Archives: PostgreSQL

Run rake db:seed and got table “does not exist” error

Background Rails version: 4.2.5 Database: PostgreSQL 9.5 On chapter 11 of Rails Tutorial, user table was created directly via pgAdmin III – not by Rails database migration – I prefer to create database tables etc via SQL script so I have full control over all things at database level. Also, that is probably necessary for… Read More »

Install PostgreSQL Database Driver

Background OS: Debian 8 PostgreSQL, Ruby and Rails installed Part of efforts to write a small Ruby on Rails reporting application which requires connection to PostgreSQL database. Attempt to install PostgreSQL database driver and got “missing library” error. > gem install postgresql Building native extensions. This could take a while… ERROR: Error installing postgresql: ERROR:… Read More »