MusicBrainz NGS Database Install for Mac: Difference between revisions

From MusicBrainz Wiki
Jump to navigationJump to search
Line 22: Line 22:
</pre>
</pre>


Reboot, start Postgres Server (because if built from source wont be started automatically)
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)
<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
Line 33: Line 33:


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

Edit admin/sql/CreateIndexes.sql removing the page indexes and musicbrainz_collate indexes
Edit admin/sql/CreateIndexes.sql removing the page indexes and musicbrainz_collate indexes
Also need to run admin/sql/vertical/rawdata/CreateTable.sql

Revision as of 21:24, 15 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 Edit admin/sql/CreateIndexes.sql removing the page indexes and musicbrainz_collate indexes Also need to run admin/sql/vertical/rawdata/CreateTable.sql