Issues installing postgresql with homebrew OS 10.6.8

Question

I'm having issues installing postgresql with homebrew on my MBP running OS 10.6.8.

It finishes

sudo brew install postgresql

without any issues.

When I try:

initdb /usr/local/var/postgres

I get the following error:

This user must also own the server process.

The database cluster will be initialized with locale en_US.UTF-8.
The default database encoding has accordingly been set to UTF8.
The default text search configuration will be set to "english".

fixing permissions on existing directory /usr/local/var/postgres ... initdb: could not change permissions of directory "/usr/local/var/postgres": Operation not permitted

But when I try to run

  mkdir -p ~/Library/LaunchAgents
  cp /usr/local/Cellar/postgresql/9.1.1/org.postgresql.postgres.plist ~/Library/LaunchAgents/
  launchctl load -w ~/Library/LaunchAgents/org.postgresql.postgres.plist

I get the following error:

launchctl: CFURLWriteDataAndPropertiesToResource(/var/db/launchd.db/com.apple.launchd.peruser.501/overrides.plist) failed: -10

I don't understand how to fix this.

So I was a little impatient and then tried to startup postgres manually anyway and it wouldn't work.

Anyway, I don't know how to proceed. Any suggestions?

Answer 1

From the installation document: You don’t need sudo when you brew install.

Uninstall the sudo copy of postgres and reinstall without sudo.

sudo brew uninstall postgresql
brew install postgresql