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

From MusicBrainz Wiki
(New page: ===Setting up Postgres for Musicbrainz on a Mac System Install MacPorts <pre> port gmake port install postgresql83 </pre> Reboot Run pgadmin check can connect to server Create user musi...)
 
Line 2: Line 2:
  
 
Install MacPorts
 
Install MacPorts
 +
 +
Now install gmake using MacPorts
 
<pre>
 
<pre>
 
port gmake
 
port gmake
port install postgresql83
 
 
</pre>
 
</pre>
Reboot
 
 
Run pgadmin check can connect to server
 
  
Create user musicbrainz
 
 
Create database musicbrainz
 
  
 
Download postgres8.3 source and unzip
 
Download postgres8.3 source and unzip
  
 +
Build and install Postgres and Cube extension required by Musicbrianz
 
<pre>
 
<pre>
 
gmake
 
gmake
Line 25: Line 21:
 
psql -d musicbrainz -U musicbrainz -f cube.sql
 
psql -d musicbrainz -U musicbrainz -f cube.sql
 
</pre>
 
</pre>
 +
 +
Reboot, start Postgres Server (becuase if built from source wont be started automatically)
 +
<pre>
 +
sudo - postgres/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l logfile start
 +
</pre>
 +
 +
Run pgadmin check can connect to server
 +
 +
Create user musicbrainz
 +
 +
Create database musicbrainz_db

Revision as of 12:42, 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 Musicbrianz

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 (becuase 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

Create database musicbrainz_db