ionas ionas

PostgreSQL on Lion

Much to my dismay, PostgreSQL on OS X is not as trouble-free to install and configure as my experiences with it on a variety of Linux distributions. This Gist documents how to overcome these issues using the Homebrew installation of postgresql.

This is an effort to document how to get setup to a coworker who was having troubles with Postgres on Lion recently.

Installation

This is usually the easy part:

	# Google Art Project fullsize image downloader.
	# By Henrik Nyh <http://henrik.nyh.se> 2011-02-05 under the MIT license.
	# Requires Ruby and ImageMagick.
	#
	# Usage e.g.:
	# ruby google_art_project.rb http://www.googleartproject.com/museums/tate/portrait-of-william-style-of-langley-174
	#
	# You can specify multiple URLs on the command line, separated by space.
	# Or you can specify no URLs on the command line and instead list them at the end of this file, one on each line,
	# with "__END__" before the list.


	/*-
	* fuse_wait - Light wrapper around a FUSE mount program that waits
	* for the "mounted" notification before exiting.
	*
	* Copyright (C) 2007-2009 Erik Larsson
	*
	* This program is free software; you can redistribute it and/or
	* modify it under the terms of the GNU General Public License
	* as published by the Free Software Foundation; either version 2

	$(function() {
	$('#products_search input').keyup(function() {
	$.bbq.pushState($('#products_search').serialize() + '&page=1');
	}, 250);
	});
	$('#products th a, #products .pagination a').live('click', function(e) {
	e.preventDefault();
	$.bbq.pushState($.param.querystring(this.href));
	});
	$(window).bind('hashchange', function() {

	#http://stackoverflow.com/questions/373731/override-activerecord-attribute-methods
	def price(option = nil)
	if option == :nice
	("%.2f" % price).gsub('.00', '.--').gsub('.', ',')
	else
	read_attribute(:price) # No test for nil?
	end
	end

	# TODO: do label translation here as well.
	@@labels = {
	:price => 'Price incl. VAT'
	}
	def self.labels(attribute_name)
	if @@labels[attribute_name]
	@@labels[attribute_name]
	else
	attribute_name.to_s.titleize
	end

	// Place your application-specific JavaScript functions and classes here
	// This file is automatically included by javascript_include_tag :defaults

	$(function() {

	// Hide the form button
	$('#products_search input[type="submit"]').hide();

	// Push searches onto the location hash
	var inputTimeoutId = -1;

	# index.js.erb:
	$("#products").html(
	"<%= escape_javascript(render('products')) %>"
	);
	$("#products_search_hidden_fields").html(
	"<%= escape_javascript(render('products_search_hidden_fields')) %>"
	);

	# index.html.erb:
	<%= form_tag products_path, :method => 'get', :id => "products_search" do %>