pgAdmin
pgAdmin
Get Started with Apps!
Get Started with Apps!
App Version: 9.2
(Changelog)
Keywords: database, management
Train: Community
Home Page: https://www.pgadmin.org/
Keywords: database, management
Train: Community
Home Page: https://www.pgadmin.org/
pgAdmin Details
Added: 2024-09-24
Last Updated: 2025-04-23
Added: 2024-09-24
Last Updated: 2025-04-23
pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL
Run as Context- pgAdmin runs as non-root user.
Group: 5050 / pgadmin
User: 5050 / pgadmin
Screenshots
×
![Full Screenshot]()
Security Capabilities
- pgAdmin requires this ability to bind to privileged ports.
App Metadata (Raw File)
{
"1.1.14": {
"healthy": true,
"supported": true,
"healthy_error": null,
"location": "/__w/apps/apps/trains/community/pgadmin/1.1.14",
"last_update": "2025-04-23 17:43:28",
"required_features": [],
"human_version": "9.2_1.1.14",
"version": "1.1.14",
"app_metadata": {
"app_version": "9.2",
"capabilities": [
{
"description": "pgAdmin requires this ability to bind to privileged ports.",
"name": "NET_BIND_SERVICE"
}
],
"categories": [
"productivity"
],
"changelog_url": "https://www.pgadmin.org/news/",
"date_added": "2024-09-24",
"description": "pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL",
"home": "https://www.pgadmin.org/",
"host_mounts": [],
"icon": "https://media.sys.truenas.net/apps/pgadmin/icons/icon.png",
"keywords": [
"database",
"management"
],
"lib_version": "2.1.16",
"lib_version_hash": "dac15686f882b9ce65b8549a3d5c0ed7bafe2df7a9028880d1a99b0ff4af1eff",
"maintainers": [
{
"email": "dev@ixsystems.com",
"name": "truenas",
"url": "https://www.truenas.com/"
}
],
"name": "pgadmin",
"run_as_context": [
{
"description": "pgAdmin runs as non-root user.",
"gid": 5050,
"group_name": "pgadmin",
"uid": 5050,
"user_name": "pgadmin"
}
],
"screenshots": [
"https://media.sys.truenas.net/apps/pgadmin/screenshots/screenshot1.png",
"https://media.sys.truenas.net/apps/pgadmin/screenshots/screenshot2.png",
"https://media.sys.truenas.net/apps/pgadmin/screenshots/screenshot3.png"
],
"sources": [
"https://hub.docker.com/r/dpage/pgadmin4",
"https://www.pgadmin.org/"
],
"title": "pgAdmin",
"train": "community",
"version": "1.1.14"
},
"schema": {
"groups": [
{
"name": "pgAdmin Configuration",
"description": "Configure pgAdmin"
},
{
"name": "Network Configuration",
"description": "Configure Network for pgAdmin"
},
{
"name": "Storage Configuration",
"description": "Configure Storage for pgAdmin"
},
{
"name": "Labels Configuration",
"description": "Configure Labels for pgAdmin"
},
{
"name": "Resources Configuration",
"description": "Configure Resources for pgAdmin"
}
],
"questions": [
{
"variable": "pgadmin",
"label": "",
"group": "pgAdmin Configuration",
"schema": {
"type": "dict",
"attrs": [
{
"variable": "admin_email",
"label": "Admin Email",
"description": "The email address for the pgAdmin admin user.",
"schema": {
"type": "string",
"required": true,
"default": ""
}
},
{
"variable": "admin_password",
"label": "Admin Password",
"description": "The password for the pgAdmin admin user.",
"schema": {
"type": "string",
"required": true,
"private": true,
"default": ""
}
},
{
"variable": "additional_envs",
"label": "Additional Environment Variables",
"description": "Configure additional environment variables for pgAdmin.",
"schema": {
"type": "list",
"default": [],
"items": [
{
"variable": "env",
"label": "Environment Variable",
"schema": {
"type": "dict",
"attrs": [
{
"variable": "name",
"label": "Name",
"schema": {
"type": "string",
"required": true
}
},
{
"variable": "value",
"label": "Value",
"schema": {
"type": "string",
"required": true
}
}
]
}
}
]
}
}
]
}
},
{
"variable": "network",
"label": "",
"group": "Network Configuration",
"schema": {
"type": "dict",
"attrs": [
{
"variable": "web_port",
"label": "WebUI Port",
"description": "The port for pgAdmin WebUI",
"schema": {
"type": "int",
"default": 30056,
"required": true,
"$ref": [
"definitions/port"
]
}
},
{
"variable": "host_network",
"label": "Host Network",
"description": "Bind to the host network. It's recommended to keep this disabled.\n",
"schema": {
"type": "boolean",
"default": false
}
},
{
"variable": "certificate_id",
"label": "Certificate",
"description": "The certificate to use for Portainer.",
"schema": {
"type": "int",
"null": true,
"$ref": [
"definitions/certificate"
]
}
}
]
}
},
{
"variable": "storage",
"label": "",
"group": "Storage Configuration",
"schema": {
"type": "dict",
"attrs": [
{
"variable": "config",
"label": "pgAdmin Config Storage",
"description": "The path to store pgAdmin Config.",
"schema": {
"type": "dict",
"attrs": [
{
"variable": "type",
"label": "Type",
"description": "ixVolume: Is dataset created automatically by the system.</br>\nHost Path: Is a path that already exists on the system.\n",
"schema": {
"type": "string",
"required": true,
"immutable": true,
"default": "ix_volume",
"enum": [
{
"value": "host_path",
"description": "Host Path (Path that already exists on the system)"
},
{
"value": "ix_volume",
"description": "ixVolume (Dataset created automatically by the system)"
}
]
}
},
{
"variable": "ix_volume_config",
"label": "ixVolume Configuration",
"description": "The configuration for the ixVolume dataset.",
"schema": {
"type": "dict",
"show_if": [
[
"type",
"=",
"ix_volume"
]
],
"$ref": [
"normalize/ix_volume"
],
"attrs": [
{
"variable": "acl_enable",
"label": "Enable ACL",
"description": "Enable ACL for the storage.",
"schema": {
"type": "boolean",
"default": false
}
},
{
"variable": "dataset_name",
"label": "Dataset Name",
"description": "The name of the dataset to use for storage.",
"schema": {
"type": "string",
"required": true,
"immutable": true,
"hidden": true,
"default": "config"
}
},
{
"variable": "acl_entries",
"label": "ACL Configuration",
"schema": {
"type": "dict",
"show_if": [
[
"acl_enable",
"=",
true
]
],
"attrs": []
}
}
]
}
},
{
"variable": "host_path_config",
"label": "Host Path Configuration",
"schema": {
"type": "dict",
"show_if": [
[
"type",
"=",
"host_path"
]
],
"attrs": [
{
"variable": "acl_enable",
"label": "Enable ACL",
"description": "Enable ACL for the storage.",
"schema": {
"type": "boolean",
"default": false
}
},
{
"variable": "acl",
"label": "ACL Configuration",
"schema": {
"type": "dict",
"show_if": [
[
"acl_enable",
"=",
true
]
],
"attrs": [],
"$ref": [
"normalize/acl"
]
}
},
{
"variable": "path",
"label": "Host Path",
"description": "The host path to use for storage.",
"schema": {
"type": "hostpath",
"show_if": [
[
"acl_enable",
"=",
false
]
],
"required": true
}
}
]
}
}
]
}
},
{
"variable": "additional_storage",
"label": "Additional Storage",
"description": "Additional storage for pgAdmin.",
"schema": {
"type": "list",
"default": [],
"items": [
{
"variable": "storageEntry",
"label": "Storage Entry",
"schema": {
"type": "dict",
"attrs": [
{
"variable": "type",
"label": "Type",
"description": "ixVolume: Is dataset created automatically by the system.</br>\nHost Path: Is a path that already exists on the system.</br>\nSMB Share: Is a SMB share that is mounted to as a volume.\n",
"schema": {
"type": "string",
"required": true,
"default": "ix_volume",
"immutable": true,
"enum": [
{
"value": "host_path",
"description": "Host Path (Path that already exists on the system)"
},
{
"value": "ix_volume",
"description": "ixVolume (Dataset created automatically by the system)"
},
{
"value": "cifs",
"description": "SMB/CIFS Share (Mounts a volume to a SMB share)"
}
]
}
},
{
"variable": "read_only",
"label": "Read Only",
"description": "Mount the volume as read only.",
"schema": {
"type": "boolean",
"default": false
}
},
{
"variable": "mount_path",
"label": "Mount Path",
"description": "The path inside the container to mount the storage.",
"schema": {
"type": "path",
"required": true
}
},
{
"variable": "host_path_config",
"label": "Host Path Configuration",
"schema": {
"type": "dict",
"show_if": [
[
"type",
"=",
"host_path"
]
],
"attrs": [
{
"variable": "acl_enable",
"label": "Enable ACL",
"description": "Enable ACL for the storage.",
"schema": {
"type": "boolean",
"default": false
}
},
{
"variable": "acl",
"label": "ACL Configuration",
"schema": {
"type": "dict",
"show_if": [
[
"acl_enable",
"=",
true
]
],
"attrs": [],
"$ref": [
"normalize/acl"
]
}
},
{
"variable": "path",
"label": "Host Path",
"description": "The host path to use for storage.",
"schema": {
"type": "hostpath",
"show_if": [
[
"acl_enable",
"=",
false
]
],
"required": true
}
}
]
}
},
{
"variable": "ix_volume_config",
"label": "ixVolume Configuration",
"description": "The configuration for the ixVolume dataset.",
"schema": {
"type": "dict",
"show_if": [
[
"type",
"=",
"ix_volume"
]
],
"$ref": [
"normalize/ix_volume"
],
"attrs": [
{
"variable": "acl_enable",
"label": "Enable ACL",
"description": "Enable ACL for the storage.",
"schema": {
"type": "boolean",
"default": false
}
},
{
"variable": "dataset_name",
"label": "Dataset Name",
"description": "The name of the dataset to use for storage.",
"schema": {
"type": "string",
"required": true,
"immutable": true,
"default": "storage_entry"
}
},
{
"variable": "acl_entries",
"label": "ACL Configuration",
"schema": {
"type": "dict",
"show_if": [
[
"acl_enable",
"=",
true
]
],
"attrs": [],
"$ref": [
"normalize/acl"
]
}
}
]
}
},
{
"variable": "cifs_config",
"label": "SMB Configuration",
"description": "The configuration for the SMB dataset.",
"schema": {
"type": "dict",
"show_if": [
[
"type",
"=",
"cifs"
]
],
"attrs": [
{
"variable": "server",
"label": "Server",
"description": "The server to mount the SMB share.",
"schema": {
"type": "string",
"required": true
}
},
{
"variable": "path",
"label": "Path",
"description": "The path to mount the SMB share.",
"schema": {
"type": "string",
"required": true
}
},
{
"variable": "username",
"label": "Username",
"description": "The username to use for the SMB share.",
"schema": {
"type": "string",
"required": true
}
},
{
"variable": "password",
"label": "Password",
"description": "The password to use for the SMB share.",
"schema": {
"type": "string",
"required": true,
"private": true
}
},
{
"variable": "domain",
"label": "Domain",
"description": "The domain to use for the SMB share.",
"schema": {
"type": "string"
}
}
]
}
}
]
}
}
]
}
}
]
}
},
{
"variable": "labels",
"label": "",
"group": "Labels Configuration",
"schema": {
"type": "list",
"default": [],
"items": [
{
"variable": "label",
"label": "Label",
"schema": {
"type": "dict",
"attrs": [
{
"variable": "key",
"label": "Key",
"schema": {
"type": "string",
"required": true
}
},
{
"variable": "value",
"label": "Value",
"schema": {
"type": "string",
"required": true
}
},
{
"variable": "containers",
"label": "Containers",
"description": "Containers where the label should be applied",
"schema": {
"type": "list",
"items": [
{
"variable": "container",
"label": "Container",
"schema": {
"type": "string",
"required": true,
"enum": [
{
"value": "pgadmin",
"description": "pgadmin"
}
]
}
}
]
}
}
]
}
}
]
}
},
{
"variable": "resources",
"label": "",
"group": "Resources Configuration",
"schema": {
"type": "dict",
"attrs": [
{
"variable": "limits",
"label": "Limits",
"schema": {
"type": "dict",
"attrs": [
{
"variable": "cpus",
"label": "CPUs",
"description": "CPUs limit for pgAdmin.",
"schema": {
"type": "int",
"default": 2,
"required": true
}
},
{
"variable": "memory",
"label": "Memory (in MB)",
"description": "Memory limit for pgAdmin.",
"schema": {
"type": "int",
"default": 4096,
"required": true
}
}
]
}
}
]
}
}
]
},
"readme": "<h1>pgAdmin</h1> <p><a href=\"https://github.com/pgadmin-org/pgadmin4\">pgAdmin</a> is the most popular and feature rich Open Source administration and development platform for PostgreSQL</p>",
"changelog": null,
"chart_metadata": {
"app_version": "9.2",
"capabilities": [
{
"description": "pgAdmin requires this ability to bind to privileged ports.",
"name": "NET_BIND_SERVICE"
}
],
"categories": [
"productivity"
],
"changelog_url": "https://www.pgadmin.org/news/",
"date_added": "2024-09-24",
"description": "pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL",
"home": "https://www.pgadmin.org/",
"host_mounts": [],
"icon": "https://media.sys.truenas.net/apps/pgadmin/icons/icon.png",
"keywords": [
"database",
"management"
],
"lib_version": "2.1.16",
"lib_version_hash": "dac15686f882b9ce65b8549a3d5c0ed7bafe2df7a9028880d1a99b0ff4af1eff",
"maintainers": [
{
"email": "dev@ixsystems.com",
"name": "truenas",
"url": "https://www.truenas.com/"
}
],
"name": "pgadmin",
"run_as_context": [
{
"description": "pgAdmin runs as non-root user.",
"gid": 5050,
"group_name": "pgadmin",
"uid": 5050,
"user_name": "pgadmin"
}
],
"screenshots": [
"https://media.sys.truenas.net/apps/pgadmin/screenshots/screenshot1.png",
"https://media.sys.truenas.net/apps/pgadmin/screenshots/screenshot2.png",
"https://media.sys.truenas.net/apps/pgadmin/screenshots/screenshot3.png"
],
"sources": [
"https://hub.docker.com/r/dpage/pgadmin4",
"https://www.pgadmin.org/"
],
"title": "pgAdmin",
"train": "community",
"version": "1.1.14"
}
}
}Support, maintenance, and documentation for applications within the Community catalog is handled by the TrueNAS community. The TrueNAS Applications Portal hosts but does not validate or maintain any linked resources associated with this app.
There currently aren’t any resources available for this application!
Please help the TrueNAS community create content or discuss this application in the TrueNAS Community forum.