Tag Archives: apple

Postgres 9.04 on OS X 10.7 Lion

I installed PostgreSQL on my new MacBook Air today via Homebrew. Having installed it I was mystified why I could not connect without specifically specifying the host was localhost. e.g.

yes:postgres ian$ psql --list
psql: could not connect to server: Permission denied
	Is the server running locally and accepting
	connections on Unix domain socket \
            "/var/pgsql_socket/.s.PGSQL.5432"?

Instead I would have to specify “psql –host=localhost –list”.

Turns out that 10.7 has postgres installed by default (or at least bits of it), but not configured to run. The postgres commands that you type are picked up by the default install as they are first on the path (they are in /usr/bin/, whereas the Homebrew binaries appear in /usr/local/bin/). This posting has more info.

I have changed my previous solution (moving the postgres files out of /usr/bin), which was stupid (and will give similar issues with other Homebrew installs. The correct solution is to amend ~/.bash_profile (create if it doesn’t exist) and add the following line:

export PATH="/usr/local/bin:$PATH"

Start a new terminal and you should be good to go.

Losing focus on Windows 7

I came across an irritating issue on my Windows 7 machine. Something would keep tacking focus from me. As I spend a lot of time in a full screen Ubuntu virtual machine under VMWare, this was amazingly annoying but I just couldn’t track it down.

Eventually a suggestion from Simon Bisson that iTunes had a reputation for doing such things put me on the right track. I don’t have iTunes on Windows but I did have the Apple Software Updater and QuickTime installed. I removed both of them and so far the issue has not returned in the last couple of days.

Let’s hope this is not a false dawn.