MusicBrainz NGS Database Install for Mac: Difference between revisions

From MusicBrainz Wiki
Jump to navigationJump to search
(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...)
 
No edit summary
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