MusicBrainz NGS Database Install for Mac

From MusicBrainz Wiki
Jump to navigationJump to search

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 Musicbrainz

cd contrib/cube
sudo gmake install
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, Best to put this command in a script in postgres users home dir)

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

Install pgadmin

Run pgadmin check can connect to server then create user musicbrainz

I then followed [[1]] but had to make some changes for NGS release as follows

Just interested in mbdump and mpdump-cdstubs (cdstubs) and mbdump-derived (annotations)

Edit admin/sql/CreateIndexes.sql removing the page indexes and musicbrainz_collate indexes

Also need to run admin/sql/vertical/rawdata/CreateTable.sql