services:postgresql
This is an old revision of the document!
Table of Contents
PostgreSQL
Shared database server.
Access
| Item | Value |
|---|---|
| Container | CT 110 |
| IP | 10.100.161.110:5432 |
| Admin | pgadmin |
Databases
| Database | User | Used By |
|---|---|---|
| n8n | n8n | n8n |
| vaultwarden | vaultwarden | Vaultwarden |
Management
# Connect as admin pct exec 110 -- su - postgres -c "psql" # List databases pct exec 110 -- su - postgres -c "psql -l" # Connect to specific DB psql -h 10.100.161.110 -U pgadmin -d n8n
Backup
Daily backup via Proxmox (vzdump).
Related
- n8n - Uses PostgreSQL
- Vaultwarden - Uses PostgreSQL
services/postgresql.1770409320.txt.gz · Last modified: by admin