How do I install pgAdmin on TrueNAS Scale? Errors during deployment

Software & Web Applications
1

TrueNAS Scale, version Dragonfish-24.04.2
app version is pgAdmin 4 8.11, chart version is 1.2.12.

I’m trying to install pgAdmin to access Nextcloud’s postgress database to create backups etc. and get stuck on Deploying step with the following errors:

If I provide a real email address when configuring the app with a real password for the email account (external to the TrueNAS), during the deployment I get an error, in Related Kubernetes events:
Startup probe failed: Get “http://172.16.0.143:30056/misc/ping”: context deadline exceeded (Client.Timeout exceeded while awaiting headers)

If I provide just the name without @mailserver I get a different error:
Back-off restarting failed container pgadmin in pod pgadmin-67699885ff-4kt78_ix-pgadmin(eace5ecd-e75f-49ce-b278-8c8e49f5c4e7)

Should there be an email server installed on the TrueNAS first? Do I use my local TrueNAS username? I could be asking wrong questions.

In any case I can’t install pgAdmin, can’t find any guides online on how to install it on TrueNAS SCALE, I’m new to TrueNAS and would really appreciate any help!

Thank you!

2

I have never attempted to add that to a TrueNAS Scale system so I do not really have any guidance. Perhaps someone in the TrueNAS Forums has some insight https://forums.truenas.com/

3

I actually encountered this issue as well with ElectricEel-24.10.2.

This is due to the pgadmin user the docker container uses. It is briefly mentioned in the pgAdmin documentation.

The solution I found that worked for me during the installation:

  • In the Storage Configuration section, check the Enable ACL option.
  • Under ACL Configuration and ACL Entries, manually add the ACL for the user specified in the pgAdmin documentation.
  • Add one Entry is for a USER, with ID of 5050, Access of Modify Access.
  • Add one Entry is for a Group, with ID of 5050, Access of Modify Access.
2 Likes
4

Sort of slightly off topic, but if you upgrade to Electric Eel, you might have an easier time with containers. The move from Kubernetes to plain old docker was brilliant in my opinion. I installed portainer and now I just re-use all my docker compose YAML files to run docker apps in TrueNAS set up the way I want them to be

1 Like
5

Thank you! I’ll give this a try!