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.