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