Differences

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

--- services:postgresql [2026/02/07 10:40] – Consolidated into infrastructure:automation-stack admin
+++ services:postgresql [2026/02/08 08:34] (current) – created - external edit 127.0.0.1
@@ Line 1: / Line 1: @@
+====== PostgreSQL ======
+Shared Database für alle Services.
+===== Details =====
+^ Key ^ Value ^
+| Container | CT 110 |
+| IP | 10.100.161.110 |
+| Port | 5432 |
+| RAM | 1 GB |
+| Version | 15 |
+===== Datenbanken =====
+^ Database ^ User ^ Service ^
+| n8n | n8n | n8n Workflows |
+| vaultwarden | vaultwarden | Vaultwarden |
+| forgejo | forgejo | Forgejo Git |
+===== Zugriff =====
+<code bash>
+# Auf dem Container
+su - postgres
+psql
+# Remote (von anderem CT)
+psql -h 10.100.161.110 -U <user> -d <database>
+</code>
+===== Befehle =====
+<code sql>
+-- Datenbanken anzeigen
+\l
+-- User anzeigen
+\du
+-- Zu DB wechseln
+\c <database>
+-- Tabellen anzeigen
+\dt
+</code>
+===== Backup =====
+<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 =====
+Alle Passwörter in Vaultwarden:
+  * **Organisation:** mxmlabs
+  * **Collection:** Network Automation