Thread: BUG #18547: bemused by your unhelpful installation guides
The following bug has been logged on the website: Bug reference: 18547 Logged by: Neil Watcyn-Palmer Email address: nwpnow@gmail.com PostgreSQL version: 16.3 Operating system: truenas Description: Hi I am beyond critical of your documentation My research suggested that Postgresql would install on TRUENAS core see https://github.com/stualden/postgresql-misc/blob/main/install_postgres_on_truenas.md When I step through it features claimed in the git hub text are inaccurate for release 16.3 - the users and user group are NOT created automatically by the pkg install When they are manually created and given full access to both source and destination mount points the error permission denied to a folder structure not stated in the mount points is returned - what am I to do ? Read the manual. I have and it is utterly obtuse what to do. You guys have written it assuming knowledge. I am a film maker using Davinci Resolve which come with a postgreSQL database setup rather than an xml file structure. My films files are many and large so XML tends to creak a little. BUT I cannot use this facility because I cannot get past your installation "guide" so I write to explain the frustration and hope you can assist OR at least tell me that what I am doing is impossible because Postgresql is ot compatible with TrueNAS-13.0-U6.1
> On Jul 20, 2024, at 15:12, PG Bug reporting form <noreply@postgresql.org> wrote: > Hi I am beyond critical of your documentation > My research suggested that Postgresql would install on TRUENAS core see > https://github.com/stualden/postgresql-misc/blob/main/install_postgres_on_truenas.md > > When I step through it features claimed in the git hub text are inaccurate > for release 16.3 - the users and user group are NOT created automatically > by the pkg install I'm sure this is frustrating, but this bug reporting form is probably not the right place to bring up the issues. The guideyou describe is an individual's github page, not something that is maintained by the PostgreSQL development community. TrueNAS isn't one of the standard PostgreSQL platforms. That doesn't mean PostgreSQL *won't* run on it, but thereisn't the expertise here required to get those instructions to work. It's not even clear from a quick read of their documentation what the underlying OS for TrueNAS is (both Linux and FreeBSDare mentioned). If you are following those instructions and they do not appear to work, probably the best answer is to open an issue on thatGitHub repo. TrueNAS might also have support forums that could be useful.
On Sun, Jul 21, 2024 at 9:42 AM PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:
Bug reference: 18547
Logged by: Neil Watcyn-Palmer
Email address: nwpnow@gmail.com
PostgreSQL version: 16.3
Operating system: truenas
Description:
Hi I am beyond critical of your documentation
My research suggested that Postgresql would install on TRUENAS core see
https://github.com/stualden/postgresql-misc/blob/main/install_postgres_on_truenas.md
When I step through it features claimed in the git hub text are inaccurate
for release 16.3 - the users and user group are NOT created automatically
by the pkg install
When they are manually created and given full access to both source and
destination mount points the error permission denied to a folder
structure not stated in the mount points is returned - what am I to do ?
Read the manual. I have and it is utterly obtuse what to do.
The guide you found seems reasonable and I'd expect the pkg installation to create the users/groups it requires. If it doesn't it is odd and should be taken up with the group providing the installation package. The official documentation takes the position that it will not try and keep up with the many various packaging systems out in the wild. So you will not find helpful advice in it on how to perform a package-based installation and configuration. All it covers is a source code compilation installation which is not what you want to do.
If you want to search out someone to help the -general mailing list, Reddit, Slack, Discord, IRC and probably other places are where people willing to help in that way hang out.
Assuming TrueNAS is indeed built on top FreeBSD as described, and you can get whatever its equivalent of "root" is to perform all of the actions shown, PostgreSQL should work, not caring that it is running inside an appliance. But we also don't have anyone running a TrueNAS device in our build farm so it specifically isn't getting tested (FreeBSD is I believe) on a daily basis. Though even at that it is the source builds we test, not packages.
David J.