Help extracting data from database (for academic research)

The value of the port forwarding in virtualbox is correct.
You should have the host as localhost in PSequel. If you don’t do step 2, then you’ll always get the “timeout expired” error when trying to connect to the database from your mac.

Step 2 does not require advanced sysadmin skills, this should work:

Log into the virtual machine (it looks like you can already do this, great!)

cd musicbrainz/musicbrainz-docker
nano docker-compose.yml

move to line 15 below the lines

expose:
  - "5432"

add the new text:

ports:
  - "5432:5432"

Make sure that the indentation (spaces) is the same as the above expose block.

save the file - ctrl-x, say 'y' when it asks if you want to save, press return to save with the given name.

Reset the containers:

cd ../..
./bin/reset-containers

Once this is done you should be able to access the database from the mac.

Cool, the search path looks correct, although I see in your \l output that there is both a musicbrainz and musicbrainz_db database. I suspect you want to be looking in the second one.

1 Like