[Support] FoxxMD - pgadmin4

[FoxxMD]

Application Name: pgadmin4

Application Site: https://www.pgadmin.org/

Github Repo: https://github.com/postgres/pgadmin4

Docker Hub: https://hub.docker.com/r/dpage/pgadmin4/

Template Repo: https://github.com/FoxxMD/unraid-docker-templates

 

Overview

 

pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world. Some features:

 

• Designed for PostgreSQL 9.5 and above
• Access and manage multiple databases
• CRUD for all the things and raw SQL execution
• Wizards and graphic tools for many administrative tasks (ACL, backup/restore, etc.)
• Monitoring dashboard

 

 

How is this different than the existing CA template for pgAdmin4?

 

• The dockerhub repo (fenglc) used for that template has not been updated in 2 years and is now archived
• This dockerhub repo (dpage) is the official image for pgAdmin4 and is up to date
• fenglc only supports utilities (pg_restore, etc.) for postgres 9 while dpage contains utilities for postgres 9.5, 9.6, 10, 11, and 12
• fenglc has hardcoded default credentials while dpage supports supplying your own default user/pass for new installations
• dpage supports many more environmental variables for configuration

 

Usage

 

NOTE: On initial container build there may be a noticeable delay (10-20 seconds) between when the container starts and when the UI becomes available.

 

=== Migrating from fenglc or bringing your own data ===

 

Use the Config path (under "Show More Settings") in the template to map your working directory. If you are migrating from fenglc just use the same folder from appdata.

 

If you use this approach you can safely ignore or remove the Email/Password variables from the template.

 

=== New Installations ===

 

You must provide values for Default Email and Default Password in the template or the container will not start. The email is not actually used, it's just a username. After the container has been started for the first time these variables can be removed from the template.

 

Configuration

 

All other configuration for the container can be found in the pgAdmin docs.

[R.NOVACHKOV]

Hello, I am trying to create a backup for database and there is one problem I can't set path out of the default backup (/usr/local/pgsql-12) folder or go in that folder after that. It is asking for password, but it is not working with the account password setted in the container.

[Mattyfaz]

Is there any current issue with this? A completely fresh install the Username and Password don't work, just always says they are invalid.

[FoxxMD]

13 hours ago, Mattyfaz said:

Is there any current issue with this? A completely fresh install the Username and Password don't work, just always says they are invalid.

I just tried a fresh install and am seeing this issue now...it seems the login attempt is redirecting and then not passing the form data correctly. I'm looking to see if there is any troubleshooting info on this...

 

EDIT: @Mattyfaz can you try setting the Config path to a new (non-existing) location? I was able to login after using a clean path.

Edited September 30, 2020 by FoxxMD

[Zerreth]

So any attempt at login / password does not work anymore.
Removing the config folder/files & setting the default login & password in the container variables had no effect.
Seems very broken to me...

[bwarlick]

YOU MUST DO THE FOLLOWING IN ORDER TO RUN THIS DOCKER:

 

After installing the docker container, there should be a folder in appdata on the unraid host named pgadmin4.  You must change the permissions on this folder:

 

Here's how:

 

On the unraid host, click the terminal button at the top right:

 

When you get a terminal window, set the permissions on the pgadmin4 folder as follows