- (Optional) Create Database:
createdb -U musicbrainz musicbrainz
- Create Schema in your Table:
CREATE SCHEMA musicbrainz;
- Import Schema(There are some errors...let's ignore them):
psql -U musicbrainz -d musicbrainz -f schema_dump.sql
- Import actual dump(Takes a while):
psql -U musicbrainz -d musicbrainz -f dump.sql
- (Optional) Connect to DB & check data:
psql -U musicbrainz -d musicbrainz
- Something like:
musicbrainz=# select name from artist limit 10;