+"$tool"/local/postgresql-user-create backup
+sudo -u postgres psql template1 -a -f - <<-EOF
+ \set ON_ERROR_STOP on
+ ALTER USER backup WITH SUPERUSER;
+ -- NOTE: permet VACUUM
+ GRANT USAGE ON SCHEMA pg_catalog TO backup;
+ GRANT USAGE ON SCHEMA public TO backup;
+ GRANT SELECT ON ALL TABLES IN SCHEMA pg_catalog TO backup;
+ GRANT SELECT ON ALL TABLES IN SCHEMA public TO backup;
+ GRANT SELECT ON ALL SEQUENCES IN SCHEMA public TO backup;
+ GRANT CONNECT ON DATABASE template1 TO backup;
+ GRANT CONNECT ON DATABASE postgres TO backup;
+ EOF
+sudo adduser backup postgres-data
+
+sudo find "$tool"/local/backup \
+ -mindepth 1 -maxdepth 1 -type f -perm /+x \
+ -name 'postgresql-*' \
+ -exec install -m 750 -o backup -g backup \
+ -t ~backup/bin {} +
+sudo install -m 640 -o root -g root \
+ "$tool"/etc/cron.d/postgresql-backup \
+ /etc/cron.d/postgresql-backup