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:
postgresqlor<SERVER_IP> - Port: 5432
- Database: postgres
- User: admin
- Password: (check
/root/pgadmin/.env)
