Jordan Humphreys mrsweaters

Migrating a Rails project from MySQL to PostgreSQL

This brief guide is written from my own experience with migrating a large (~5GB) MySQL database to PostgreSQL for a Rails project.

No warranties, guarantees, support etc. Use at your own risk and, as always, ENSURE YOU MAKE BACKUPS FIRST!

I chose [pgloader][1] because it's extremely fast. YMMV.

Replace mysql2 gem with pg in Gemfile.
Update config/database.yml for PostgreSQL. I used [Rails' template][2] as a starting point.

Fin all MX records for host:

require 'resolv/dns'

mx = Resolv::DNS.open { |dns| dns.getresources('zurb.com',  Resolv::DNS::Resource::IN::MX) }

	{
	"caret_extra_width": 2,
	"color_scheme": "Packages/Theme - Spacegray/base16-eighties.dark.tmTheme",
	"ensure_newline_at_eof_on_save": true,
	"fallback_encoding": "UTF-8",
	"folder_exclude_patterns":
	[
	".git",
	"node_modules"
	],

	import angular from 'angular';
	import Honeybadger from 'honeybadger-js';

	Honeybadger.configure({
	apiKey: 'api-key',
	environment: (process.env.name === 'build') ? 'production' : process.env.name,
	revision: COMMIT_SHA,
	ignorePatterns: [new RegExp('password', 'i')]
	});

	var binary_search = function (list, item) {
	var low = 0;
	var high = list.length - 1;
	while(low <= high) {
	var mid = Math.floor((low + high) / 2);
	var guess = list[mid];
	if (guess === item) {
	return mid;
	} else if (guess > item) {
	high = mid - 1;

	[contenteditable=true]:empty:before{
	content: attr(placeholder);
	display: block;
	color: #ccc;
	}