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.mdWhen 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 guide you 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 there isn'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 FreeBSD are mentioned).
If you are following those instructions and they do not appear to work, probably the best answer is to open an issue on that GitHub 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 seehttps://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 installWhen 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.