pgAdmin

Access URL

• Open a browser and navigate to: https://<SERVER_IP>
• Accept the self-signed SSL certificate warning.
• Use the credentials specified during setup or stored in /root/pgadmin/.env.

Important Files and Directories

• /root/pgadmin/docker-compose.yml → Service definitions
• /root/pgadmin/.env → Stored credentials and environment variables
• /etc/nginx/sites-available/pgadmin.conf → Nginx reverse proxy config
• /var/lib/docker/volumes/ → Persistent pgAdmin and PostgreSQL data

Reverse Proxy

Nginx automatically redirects HTTP to HTTPS, serves pgAdmin securely with a self-signed certificate, and proxies all traffic to port 5050.

Connection Information

If PostgreSQL was installed and a local PostgreSQL instance runs alongside pgAdmin, you can connect to it directly through pgAdmin using the following details:

• Host: postgresql or <SERVER_IP>
• Port: 5432
• Database: postgres
• User: admin
• Password: (check /root/pgadmin/.env)