Skip to content

Instantly share code, notes, and snippets.

View adamthede's full-sized avatar
:octocat:
Working from home

Adam Thede adamthede

:octocat:
Working from home
26 followers · 42 following
View GitHub Profile
@adamthede
adamthede / migrate_postgresql_database.md
Created December 1, 2016 01:01 — forked from olivierlacan/migrate_postgresql_database.md
How to migrate a Homebrew-installed PostgreSQL database to a new major version (9.3 to 9.4) on OS X

This guide assumes that you recently run brew upgrade postgresql and discovered to your dismay that you accidentally bumped from one major version to another: say 9.3.x to 9.4.x. Yes, that is a major version bump in PG land.

First let's check something.

brew info postgresql

The top of what gets printed as a result is the most important:

@adamthede
adamthede / gist:de85a83ca761bf937e9b
Last active February 18, 2016 23:13 — forked from arjunvenkat/gist:1115bc41bf395a162084
Seeding a Rails database with a CSV file

How to seed a Rails database with a CSV file

1. Setup

First, Create a folder inside of lib called seeds

Put your CSV file example.csv into the lib/seeds folder. In the example below, the file is called real_estate_transactions.csv

Make sure you've created a resource with the appropriate columns to match your seed data. The names don't have to match up.