Am I the only person trying to use TRUENAS Core with postgresql 16.3 - I must be
Is it even possible - I wasted a weekend trying to sort out WTF is wrong and always come to a full stop when trying to initialise the database with permission denied as the initialisation seeks to create a folder
HAS ANYONE succesfully installed this in the last year the only help is 2019 and out of date
Scripted Database Installation (TrueNAS CORE)
Are you referring to jails?
Because installing software into the base OS is not allowed or supported.
…and assuming you are trying to install it into a jail, you’d get a lot more help with information about what you’ve tried and what happened when you did, than with the pretty-generic rant you posted.
Even in a jail, FreeBSD 13.2 is EOL, and 13.3 introduced some changes that break jails. So you’d need to run this under TrueNAS 13.3, which is unfortunately still in BETA.
But with that said, under 13.3, create a jail, and in the jail pkg install postgresql16-server; sysrc postgresql_enable=yes; service postgresql initdb; service postgresql start. And the installation itself gives you the last three commands, and except for the “initdb” step, it’s pretty much the same as installing any other server software under FreeBSD.
I have tried to get PostgreSQL running, but no luck. I spent the last few hours with ChatGPT, and still no luck.
The out of the box experience is astonishingly terrible. It seems that there is no default configuration that ‘just works.’
While TrueNAS does many things well, I have had nothing but trouble getting Apps working. It’s always endless hours of hacking…
Postgres needs permission set for user 999 (netdata). Did you set those on the dataset you want to use for postgres?
On SCALE, but this thread is about CORE. But Eric provided no more information about what’s going on for him than Neil did last year (less, even), so no idea what’s actually going on.
Since @Eric_Kolotyluk mentioned “apps” i assumed he was talking about problems on scale not like op did with core…
