Just a few pieces of advice/questions:
1. When you say 'replication' what are you referring to?
2. To be honest, running as root in a jail isn't as big of a deal as it sounds like. If "someone" were to get "root" access to your jail they'd still be stuck in the jail. Not much gained there.
3. Do you know if the database compresses at all? Normally templates are in tar.gz so compression is used. I figure it "should" compress well because the appliance VM that is given out has a database in it and the file is less than 2GB.
1. Replicating changes to the local musicbrainz database.
2. OK, that's useful to know, thanks.
3. I'll test that when I have a working jail. However...
I think I've made a schoolboy error which means I'm going to have to start the whole database import again. joelmusicman's instructions include modifying the DBDefs.pm file and changing REPLICATION_TYPE to RT_SLAVE. I did that but forgot to remove the # from the beginning of the line. Running the command 'carton exec -- ./admin/replication/LoadReplicationChanges' which should update the local database (
https://github.com/rembo10/headphon...ping-your-local-musicbrainz-server-up-to-date) produces errors including 'relation "dbmirror_pending" does not exist'. I'm guessing the database wasn't created with everything needed to be a slave. Ho hum.
So back to the drawing board but not until tomorrow night. I might start again from scratch and, like I said before, make sure every step is recorded.
Incidentally cyberjock, you mentioned previously that "As for the allow.sysvipc=1 I have the fix for that." That would be useful as the jid is changing everytime I restart the jail.