MusicBrainz NGS Database Install for Mac

From MusicBrainz Wiki
Jump to navigationJump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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 

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

Install pgadmin

Run pgadmin check can connect to server then create user musicbrainz

I then followed [[1]http://wiki.musicbrainz.org/Database_Installation] but had to make some changes for NGS release as follows

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

Retrieved from "https://wiki.musicbrainz.org/index.php?title=MusicBrainz_NGS_Database_Install_for_Mac&oldid=40711"