Doug-MacDowell/portfolio — pull request #8 by Doug-MacDowell (2014-04-25 05:36:54+00:00)
Title: DONE PostgreSQL https://app.asana.com/0/11169835259596/11460608805008

Note: I did a merge earlier that included files that changed when postgres was set up. This is a final pull request for this assignment.

Observations: Getting Postgres installed on my linux (Ubuntu variant) was relatively straightforward. Hooking it up to my Portfolio was also fairly easy to do, but I need to get more practice with the psql command syntax. I also wanted to try and port my existing data over, so I created a dump file, took out the sqlite-specific stuff and tried to load it, but had id sequence issues and decided to just start entering new data. Time permitting, I may still try to port that old data back after getting the id issue solved.

Had some minor collaboration with a coworker at my office (he is fairly experienced with Postgres on Linux), so he was able to provide some tips toward the end of the work. Websites visited included:

https://help.ubuntu.com/community/PostgreSQL
http://blog.flatironschool.com/post/68064669290/porting-sqlite3-data-to-postgresql-database-in-rails-4