On Mon, Dec 20, 2021 at 12:33 PM dulhaver via Barman, Backup and
Recovery Manager for PostgreSQL <
pgba...@googlegroups.com> wrote:
> As far as my understanding goes the barman-cli package is required on the PostgreSQL server. So my question is how to install barman-cli from source on the PostgreSQL machines? I have managed to install barman from source on the barman server, but can not find any instructions for manual install of the the barman-cli package.
<
https://github.com/EnterpriseDB/barman/blob/75320f64412f20f687fdd6212b9b2b57a7cdeb59/doc/manual/55-barman-cli.en.md>
> do I need a barman unix-user on the PostgreSQL server also?
No, at least, not in the database. You need however an user to connect
to PostgreSQL and issue queries, and an operating system user to
connect via ssh (if using rsync).
You can use already existing users, but I would recommend creating an
user wth the appropriate privileges, like:
CREATE ROLE backup WITH REPLICATION LOGIN PASSWORD 'xxxx';
GRANT EXECUTE ON FUNCTION pg_start_backup(text, boolean, boolean) to backup;
GRANT EXECUTE ON FUNCTION pg_stop_backup() to backup;
GRANT EXECUTE ON FUNCTION pg_stop_backup(boolean, boolean) to backup;
GRANT EXECUTE ON FUNCTION pg_switch_wal() to backup;
GRANT EXECUTE ON FUNCTION pg_create_restore_point(text) to backup;
GRANT pg_read_all_settings TO backup;
GRANT pg_read_all_stats TO backup;
Luca