Datenbank | Verwendung |
---|---|
synapse | Datenbank für matrix-synapse |
sudo su - postgres -c "createuser -P username"
sudo su - postgres -c "createdb databasename"
postgres=#
GRANT ALL PRIVILEGES ON DATABASE databasename TO username;
postgres=#
ALTER USER username WITH PASSWORD 'password';
/etc/postgresql/13/main/conf.d/local.conf
listen_addresses = 'localhost, 10.3.0.101, fd00:10:3:0::101' password_encryption = scram-sha-256
/etc/postgresql/13/main/pg_hba.conf
... # Network authentication host all all 10.3.0.0/24 scram-sha-256 host all all fd00:10:3:0::/64 scram-sha-256
/etc/borgmatic/config.yaml
... location: # List of source directories to backup (required). Globs and # tildes are expanded. source_directories: - /etc - /home - /root - /var/log ... hooks: .... postgresql_databases: - name: all hostname: 127.0.0.1 username: backup password: "PASSWORD_FOR_BACKUP" format: plain .... ...