pgAdmin 4 Web Console for Tower PostgreSQL

Deploy pgAdmin in Docker with persistent settings and HTTPS access through Traefik.

Summary

Category: Jet Templates
Tags: Database
Authors: Cetmix OÜ
License: AGPL-3
Version: 1.0.0
Call sign: jet_template_pg_admin
Website: cetmix.com/contact

This snippet imports a PG Admin Jet Template using dpage/pgadmin4:latest. The Jet depends on running PostgreSQL and Traefik Jets on the same server. It stores pgAdmin settings under the Jet root and uses Traefik to route HTTPS to the container's internal port 80. The YAML also includes PostgreSQL 17 with optional pgBackRest backups, plus the Traefik, Docker, Fail2ban and Tower Core templates.

Configure and launch

Import the YAML and install the template. Set postgres_password for the bundled PostgreSQL Jet. If enabling its S3 backups, set the repository parameters and the aws_key_id and aws_access_key secrets.
Configure Traefik's instance_certbot_email and the pgAdmin hostname. For automatic Cloudflare DNS registration, set web_domain, cloudflare_token and cloudflare_zone_id. For other providers, ensure the Jet has a URL and a matching DNS record. If using an ACME DNS challenge, set the selected provider's credentials (cloudflare_token, digitalocean_api_token, hetzner_api_token, or aws_dns_key_id and aws_dns_access_key).
Set pgadmin_username and pgadmin_password before launch, or let Prepare generate missing values. Create the Jet targeting Running, retrieve any generated credentials from the Jet variables and sign in at its HTTPS URL.
Register PostgreSQL from within pgAdmin. For the bundled PostgreSQL Jet, use its container name on the tower network, port 5432 and the database login.

Operate

Start, Stop and Restart manage the existing container. Rebuild recreates it using its existing data directory. Destroy removes the Jet's deployment and local pgAdmin settings. Check PGAdmin logs for application errors and Traefik logs for routing or TLS failures.

These Terms and Conditions (“Terms”) govern your access to and use of YAML configuration files (“Packages”, “YAML Snippets”, or “Snippets”) made available via the Cetmix Tower platform, operated by Cetmix OÜ, Ranna 6, Haademeeste, Voiste, 86501, Estonia (“Cetmix”, “we”, “our”, or “us”).

By downloading, installing, or otherwise using any YAML Snippets from the Cetmix Tower platform, you agree to be bound by these Terms.

1. Use of Packages

1.1. The YAML Snippets are provided either by Cetmix or third-party authors (“Authors”).

1.2. You are solely responsible for verifying the functionality, safety, and suitability of any YAML Snippet before using it in a production environment.

1.3. You may use the Snippets only in accordance with their respective licenses, which may be open-source or commercial.

2. Author Responsibility

2.1. Authors are solely responsible for the content, accuracy, functionality, and compliance of the YAML Snippets they publish.

2.2. Cetmix does not review or verify the correctness, security, or compliance of third-party Snippets.

2.3. If you are an Author, you represent and warrant that your submitted YAML Snippet:

Does not infringe on any third-party rights;
Complies with applicable laws and regulations;
Does not contain harmful, malicious, or misleading code or behavior.

3. Limitation of Liability

3.1. Cetmix provides access to the YAML Snippets “as is” and “as available,” without warranties of any kind, either express or implied.

3.2. Cetmix expressly disclaims all liability for any damages resulting from:

Use or inability to use a YAML Snippet;
Errors or omissions in the Snippets;
Actions taken in reliance on any YAML Snippet;
Misuse, misconfiguration, or system failure caused by a Snippet.

3.3. In no event shall Cetmix OÜ be liable for any indirect, incidental, special, punitive, or consequential damages, including but not limited to loss of data, profits, or service availability.

4. Security and Compliance

4.1. Cetmix does not guarantee that any Snippet is secure or free from vulnerabilities. You must review and test all Snippets before deploying them in sensitive or production environments.

4.2. Compliance with security, privacy, and regulatory requirements is your responsibility when using any Snippet.

5. Intellectual Property

5.1. Ownership of each YAML Snippet remains with its respective Author.

5.2. You must respect all license terms specified for each Snippet. Unauthorized reproduction, distribution, or sublicensing may result in legal consequences.

6. Modifications and Termination

6.1. Cetmix may modify or remove any YAML Snippet at any time without notice.

6.2. These Terms may also be updated periodically. Continued use of the platform constitutes acceptance of the revised Terms.

7. Governing Law and Jurisdiction

These Terms shall be governed by the laws of the Republic of Estonia. Any disputes arising under or in connection with these Terms shall be subject to the exclusive jurisdiction of the courts of Estonia.

8. Contact

For questions or concerns regarding these Terms or specific YAML Snippets, please contact us