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

From MusicBrainz Wiki
(Setting up Postgres for Musicbrainz on a Mac System)
Line 32: Line 32:
 
I then followed [[http://wiki.musicbrainz.org/Database_Installation]http://wiki.musicbrainz.org/Database_Installation] but had to make some changes for NGS release as follows
 
I then followed [[http://wiki.musicbrainz.org/Database_Installation]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
+
Edit admin/sql/CreateIndexes.sql removing the page indexes and musicbrainz_collate indexes

Revision as of 13:24, 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 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

Run pgadmin check can connect to server 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