38 lines
1.3 KiB
Markdown
38 lines
1.3 KiB
Markdown
# lexware-db-mirror
|
|
|
|
Echtzeit-Replikation der Lexware Professional 2026 PostgreSQL-Datenbank auf einen Linux-Server.
|
|
|
|
## Architektur
|
|
|
|
```
|
|
W2K25 (192.168.115.111) PostgreSQL 17.4 :15432
|
|
Logical Replication (WAL) + Fallback pg_dump/SCP/Webhook
|
|
Linux (192.168.115.113) PostgreSQL 18.4 :5432
|
|
```
|
|
|
|
## Dateien
|
|
|
|
| Datei | Ort | Funktion |
|
|
|---|---|---|
|
|
| hba-watcher.ps1 | Windows C:\lexware-db-connect\ | pg_hba.conf lxreplica-Regeln (10s Poll) |
|
|
| push-dump.ps1 | Windows C:\lexware-db-connect\ | Fallback pg_dump + SCP + Webhook |
|
|
| push-loop.ps1 | Windows C:\lexware-db-connect\ | Replication-Monitor + Fallback-Trigger |
|
|
| INSTALL.ps1 | Windows Desktop | Vollstaendiges Installations-Script |
|
|
| linux/webhook.py | Linux /opt/lexware-dumps/ | HTTP-Webhook fuer Restore-Requests |
|
|
| linux/restore-latest.sh | Linux /opt/lexware-dumps/ | Shadow-Swap Restore mit Replication Guard |
|
|
| config/windows-replication.conf | Windows conf.d/ | wal_level=logical, max_replication_slots=30 |
|
|
| config/linux-replication.conf | Linux conf.d/ | max_logical_replication_workers=16 |
|
|
|
|
## Installation
|
|
|
|
```powershell
|
|
powershell -ExecutionPolicy Bypass -File "INSTALL.ps1"
|
|
```
|
|
|
|
## Datenbanken
|
|
|
|
f1, f2, lexkonto, lexkk, rk, lxoffice, lx, lxcatalog
|
|
|
|
## Dokumentation
|
|
|
|
Obsidian Vault: Projekte/lexware-db-mirror.md |