Barman

To make the configurations above work, you must execute these SQL commands on your to create the necessary users: Create the Barman User :

: Ensure the Barman home directory is owned by the barman user: chown barman:barman /var/lib/barman . barman

[pg-server] description = "Main PostgreSQL Database (Streaming)" ; Database connection info conninfo = host=192.168.1.10 user=barman dbname=postgres ; Connection info specifically for WAL streaming streaming_conninfo = host=192.168.1.10 user=streaming_barman dbname=postgres ; Backup method (postgres for streaming or rsync for SSH) backup_method = postgres streaming_archiver = on slot_name = barman create_slot = auto Use code with caution. Copied to clipboard 3. Essential PostgreSQL "Text" Commands To make the configurations above work, you must

CREATE USER streaming_barman WITH REPLICATION PASSWORD 'your_secure_password'; Use code with caution. Copied to clipboard Troubleshooting Checklist Copied to clipboard

: Use barman check to verify your text configurations are correct.

[barman] ; User that runs Barman barman_user = barman ; Where backup data is stored barman_home = /var/lib/barman ; Directory for individual server config files configuration_files_directory = /etc/barman.d ; Log file location log_file = /var/log/barman/barman.log log_level = INFO ; Default compression for backups compression = gzip Use code with caution. Copied to clipboard