Differences

This shows you the differences between two versions of the page.

--- services:postgresql [2026/02/06 20:22] – Refactor: Create postgresql service page admin
+++ services:postgresql [2026/02/08 08:34] (current) – created - external edit 127.0.0.1
@@ Line 1: / Line 1: @@
 ====== PostgreSQL ======
-Shared database server.
+Shared Database für alle Services.
-===== Access =====
+===== Details =====
-^ Item ^ Value ^
+^ Key ^ Value ^
 | Container | CT 110 |
-| IP | 10.100.161.110:5432 |
+| IP | 10.100.161.110 |
-| Admin | pgadmin |
+| Port | 5432 |
+| RAM | 1 GB |
+| Version | 15 |
-===== Databases =====
+===== Datenbanken =====
-^ Database ^ User ^ Used By ^
+^ Database ^ User ^ Service ^
-| n8n | n8n | [[services:n8n|n8n]] |
+| n8n | n8n | n8n Workflows |
-| vaultwarden | vaultwarden | [[services:vaultwarden|Vaultwarden]] |
+| vaultwarden | vaultwarden | Vaultwarden |
+| forgejo | forgejo | Forgejo Git |
-===== Management =====
+===== Zugriff =====
 <code bash>
-# Connect as admin
+# Auf dem Container
-pct exec 110 -- su - postgres -c "psql"
+su - postgres
+psql
-# List databases
+# Remote (von anderem CT)
-pct exec 110 -- su - postgres -c "psql -l"
+psql -h 10.100.161.110 -U <user> -d <database>
+</code>
-# Connect to specific DB
+===== Befehle =====
-psql -h 10.100.161.110 -U pgadmin -d n8n
+<code sql>
+-- Datenbanken anzeigen
+\l
+-- User anzeigen
+\du
+-- Zu DB wechseln
+\c <database>
+-- Tabellen anzeigen
+\dt
 </code>
 ===== Backup =====
-Daily backup via Proxmox (vzdump).
+<code bash>
+# Alle Datenbanken
+pg_dumpall -U postgres > backup.sql
+# Einzelne DB
+pg_dump -U postgres <database> > database.sql
+</code>
+Backup-Location: /var/lib/pve/local/dump/
+===== Ansible =====
+<code bash>
+ansible-playbook site.yml --limit postgres
+</code>
+===== Credentials =====
-===== Related =====
+Alle Passwörter in Vaultwarden:
+  * **Organisation:** mxmlabs
+  * **Collection:** Network Automation
-  * [[services:n8n|n8n]] - Uses PostgreSQL
-  * [[services:vaultwarden|Vaultwarden]] - Uses PostgreSQL