SQL options for Truenas SCALE

[Maddnezz]

Hi,

For the past couple of weeks I have been, on and off, digging to find a way to run a SQL server on my Truenas SCALE box. I have the Truecharts and default repositories running and, unless I'm missing something, I don't see anything other than clients there. Any help would be appreciated.

 

[jgreco]

Doesn't Scale work with Kubernetes/Docker containers?

 

[Maddnezz]

Doesn't Scale work with Kubernetes/Docker containers?

I tried a mariadb Docker container but it's stuck at "deploying." I'm new to Kubernetes/Docker.

 

[jgreco]

I'm new to Kubernetes/Docker.

I'm even newer, as in, grand total is like used a handful of times. Sorry I have nothing more there.

 

[jhanmann]

I'm running the latest release of PostgreSQL (15.0) on my TrueNAS Scale system. Installed the docker image from this location:

Docker

Instructions on how to configure it for other than the default installation are in there. If you're new to docker/k3s (like I was) it will take a little figuring out but it wasn't that difficult. I put my database in a separate dataset rather than letting it live in the docker container with PostgreSQL. That way I can theoretically keep the database even if I destroy the container and then recreate it later. I've done this once already just to test it out and it worked fine. Not sure why you'd want to do that but it is the safest way to go IMHO.

 

[DaSnipe]

Hi,

For the past couple of weeks I have been, on and off, digging to find a way to run a SQL server on my Truenas SCALE box. I have the Truecharts and default repositories running and, unless I'm missing something, I don't see anything other than clients there. Any help would be appreciated.

If you add the Dependency train to the TrueCharts Catalog (check the box inside Edit Catalog) there's PostgresSQL there, most people don't need to see it since it's installed by default by charts whenever they need it

 

[Maddnezz]

If you add the Dependency train to the TrueCharts Catalog (check the box inside Edit Catalog) there's PostgresSQL there, most people don't need to see it since it's installed by default by charts whenever they need it

This was exactly it. Man running around in circles for so long when the answer was that easy. Thanks Everyone

 

[rodneysing]

This was exactly it. Man running around in circles for so long when the answer was that easy. Thanks Everyone

Apologies. I’m just catching up and am new to TrueNAS Scale — about a 1 month now. I too want to run an SQL Server container on TrueNAS Scale, with separate preserved data volumes. Is this container an option from Truecharts? I tried getting the latest Thanks!

 

[DGTM]

I'm running the latest release of PostgreSQL (15.0) on my TrueNAS Scale system. Installed the docker image from this location:

Docker

Instructions on how to configure it for other than the default installation are in there. If you're new to docker/k3s (like I was) it will take a little figuring out but it wasn't that difficult. I put my database in a separate dataset rather than letting it live in the docker container with PostgreSQL. That way I can theoretically keep the database even if I destroy the container and then recreate it later. I've done this once already just to test it out and it worked fine. Not sure why you'd want to do that but it is the safest way to go IMHO.

Thanks for the tip and link to postgres Docker Official Image, but it would be helpful if you would give us some information how did you managed to make this work on your side. I am useing OS Version:TrueNAS-SCALE-23.10.1.1. I am looking various tutorials and documentations, but non of them are actually doing the same what I am doing (installing this image on a TrueNas) and nothing works for me. I am able to have this image running, but then what? I am unable to access it, by looking in to logs I am getting error, but google is not giving me the solution... soooo.. all this just uses a lot of my energy and time, eventually I am willing to throw away all this NAS and go back to simple ubuntu server...