Difference between revisions of "MusicBrainz NGS Database Install for Mac"

From MusicBrainz Wiki
Line 22: Line 22:
 
</pre>
 
</pre>
  
Reboot, start Postgres Server (becuase if built from source wont be started automatically)
+
Reboot, start Postgres Server (because if built from source wont be started automatically)
 
<pre>
 
<pre>
 
sudo - postgres/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l logfile start
 
sudo - postgres/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l logfile start

Revision as of 12:43, 7 June 2010

Setting up Postgres for Musicbrainz on a Mac System

Install MacPorts

Now install gmake using MacPorts

port gmake


Download postgres8.3 source and unzip

Build and install Postgres and Cube extension required by Musicbrianz

gmake
cd contrib/cube
gmake 
sudo gmake install
pg_config
cd /usr/local/pgsql/share/contrib
psql -d musicbrainz -U musicbrainz -f cube.sql

Reboot, start Postgres Server (because if built from source wont be started automatically)

sudo - postgres/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l logfile start

Run pgadmin check can connect to server

Create user musicbrainz

Create database musicbrainz_db