@AudioDan24, glad to see it at least somewhat worked. I read up on the DaVinci thing and realized that the Database is only a collaboration component of that product. If you want to give the RockOn approach whirl, here are a few ideas: I created a json file and testing it on my system it seems to work very well. It allows you to pick a specific version (like e.g. 9.5.21) and allows you to map a port. I also included the SuperUser creation (along with password for this).
{
"PostgreSQL": {
"description": "PostgreSQL, Note: This rock-on requires Rockstor version 3.9.2-51 or later.",
"version":"1.2",
"website":"https://www.postgresql.org",
"more_info": "Conf.file: <code>/var/lib/pgsql/data/pg_hba.conf</code></p><p>Database:.<code>/var/lib/pgsql/data</code></p> <p>Logs: <code>/var/log/postgresql</code></p>",
"volume_add_support":true,
"containers": {
"postgresql": {
"image": "postgres",
"tag": "9.5",
"launch_order":1,
"ports": {
"5432": {
"description":"PostgreSQL port. Suggested default: 5432",
"host_default":5432,
"label":"PostgreSQL port",
"protocol":"tcp"
}
},
"volumes": {
"/var/lib/postgresql/data":{
"description":"Choose a share where the database should be stored. E.g.: create a share called postgresql-share1 for this purpose alone. ",
"label":"Data Storage"
}
},
"environment": {
"VERSION": {
"description": "Choose version of PostgreSQL: Unless you know which version to try, just type latest",
"label": "VERSION"
},
"POSTGRES_USER": {
"description": "Choose A Superuser name for the PostgreSQL installation",
"label": "SuperUser"
},
"POSTGRES_PASSWORD": {
"description": "set a password for the SuperUser.",
"label": "SuperUser password"
}
}
}
}
}
}
Put this into a json text file and place it into the local RockOn store:
/opt/rockstor/rockons-metastore
Then hit the Update button in the RockOn Screen of the WebUI. Now the PostgresSQL should show up in the list and you can install it. In the example below you can see the ports mapped differently so the RockStor DB is not affected:
It will by default create the postgresql.
In order to look inside the docker container to make changes to the config files you probably already know to use:
docker exec -it <mycontainer> bash
and you should be able to connect to that Postgres instance with a string something like this (when you’re on the RockStore box, aka localhost):
psql -h localhost -p 5432 -U postgres -W
Now, I am no expert on all of this, but I essentially ignored the password request and then was in as a postgres user, and could check out with \l or \c the databases.
The rest I leave to you, as you probably are more of an expert.
I know, I shouldn’t advertise the competition, but here was a tutorial written for qnap on how to use the container and connect from an external machine that has DaVinci installed:
And with that, my science experiment is complete
Let us know, if you actually try out this approach …