Thread

1. BUG #18547: bemused by your unhelpful installation guides

   PG Bug reporting form <noreply@postgresql.org> — 2024-07-20T22:12:30Z

   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
   
   

2. Re: BUG #18547: bemused by your unhelpful installation guides

   Christophe Pettus <xof@thebuild.com> — 2024-07-21T16:52:36Z

   
   > 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 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.
   
   
   

3. Re: BUG #18547: bemused by your unhelpful installation guides

   David G. Johnston <david.g.johnston@gmail.com> — 2024-07-21T19:39:43Z

   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.