History

Alexey Skobkin c4ed180592 postgresql_backup. Systemd configuration.		2024-11-06 20:33:37 +00:00
..
.env.dist	postgresql_backup. Adding compression configuration to .env.dist	2024-11-06 20:05:21 +00:00
pg_backup.sh	postgresql_backup. Configurable ZSTD and GZip levels.	2024-11-06 20:04:19 +00:00
README.md	postgresql_backup. Systemd configuration.	2024-11-06 20:33:37 +00:00

README.md

Usage

Authentication

Do not forget to create and/or edit ~/.pgpass file providing all needed passwords for each host:

The format is the following:

hostname:port:database:username:password

Example

localhost:5432:*:postgres:pg_password_1
localhost:5433:*:postgres:pg_password_2

Scheduling

Systemd

Service

/etc/systemd/system/postgresql_backup.service

[Unit]
Description=PostgreSQL backup Script

[Service]
Type=oneshot
WorkingDirectory=/root/scripts/postgresql_backup
ExecStart=/root/scripts/postgresql_backup/pg_backup.sh

Timer

/etc/systemd/system/postgresql_backup.timer

[Unit]
Description=Run Backup Script Every Night

[Timer]
OnCalendar=*-*-* 22:00:00
Unit=postgresql_backup.service

[Install]
WantedBy=timers.target

Then:

systemctl enable postgresql_backup.timer --now