Homelab Wiki

Writing /data/dokuwiki/data/cache/a/a16e906024bf7152fa4f7bea0878eb69.i failed

Unable to save cache file. Hint: disk full; file permissions; safe_mode setting.

Writing /data/dokuwiki/data/cache/a/a16e906024bf7152fa4f7bea0878eb69.xhtml failed

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== 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