MusicBrainz NGS Database Install for Mac: Difference between revisions
From MusicBrainz Wiki
Jump to navigationJump to search
Line 26: | Line 26: | ||
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 |
||
</pre> |
</pre> |
||
Install pgadmin |
|||
Run pgadmin check can connect to server |
Run pgadmin check can connect to server |
||
then create user musicbrainz |
|||
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 |
Revision as of 13:25, 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
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