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

From MusicBrainz Wiki
(Setting up Postgres for Musicbrainz on a Mac System)
(Setting up Postgres for Musicbrainz on a Mac System)
Line 34: Line 34:
 
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
  
Just interested in mbdump and mpdump-cdstubs (cdstubs) and mbdump-derived (annotations)
+
Just interested in mbdump and mpdump-cdstubs (cdstubs) and mbdump-derived (annotations, tags)
  
 
Create one database called musicbrainz and use it for both main and raw database
 
Create one database called musicbrainz and use it for both main and raw database

Revision as of 09:43, 16 November 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, 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]http://wiki.musicbrainz.org/Database_Installation] but had to make some changes for NGS release as follows

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

Create one database called musicbrainz and use it for both main and raw database

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

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

for t in *; do echo `date` $t ; echo "\\copy $t from ./$t" | /usr/local/pgsql/bin/psql -U musicbrainz musicbrainz && mv $t ../done/; done; echo `date` Done

When build indexes modify IndexOptions.prepareDbConnection to not use a schema because schema is not used with the above instructions