pgbackman
pgbackman copied to clipboard
Problems when updating cron
Hallo,
[pgbackman]$ update_pgsql_node_config
NodeID / FQDN []: 3
Minutes cron interval [01-59]: 6
Hours cron interval [01-06]:
Day-month cron [*]:
Month cron [*]:
Weekday cron [*]:
Backup code [FULL]:
Retention period [7 days]:
Retention redundancy [1]:
Automatic deletion retention [14 days]:
Extra backup parameters []:
Extra restore parameters []:
Backup Job status [ACTIVE]:
Domain [yerry.be]:
Logs e-mail [[email protected]]:
PostgreSQL admin user [postgres]:
Port [5432]:
Backup directory [/export/pgsql_node_3]:
Crontab file [/etc/cron.d/pgsql_node_3]:
PgSQL node status [STOPPED]:
Are all values to update correct (yes/no):
Are all values to update correct (yes/no):
Are all values to update correct (yes/no):
Are all values to update correct (yes/no): yes
[WARNING]: Wrong minutes interval format, using default. [DONE] Configuration parameters for NodeID: 3 updated.
root@pgbackman:/etc/cron.d# cat pgsql_node_3
File: /etc/cron.d/pgsql_node_3
This crontab file is generated automatically
and contains the backup jobs to be run
for the PgSQL node pg2.yerry.be
in the backup server pgbackman.yerry.be
Generated: 2017-12-17 22:23:56.730401+00
SHELL=/bin/bash PATH=/sbin:/bin:/usr/sbin:/usr/bin [email protected]
32 04 0,5,10,15,20,25,30,35,40,45,50,55 * * pgbackman /usr/bin/pgbackman_dump --node-fqdn pg2.yerry.be --node-id 3 --node-port 5432 --node-user postgres --def-id 2 --dbname gerrit_1 --encryption false --backup-code FULL --root-backup-dir /export 49 06 0,5,10,15,20,25,30,35,40,45,50,55 * * pgbackman /usr/bin/pgbackman_dump --node-fqdn pg2.yerry.be --node-id 3 --node-port 5432 --node-user postgres --def-id 3 --dbname gerrit_2 --encryption false --backup-code FULL --root-backup-dir /export
I do not understand the input fields
Minutes cron interval [01-59]: 6
Filling in 0,5,10, .... does not work.
Regards, Gerrit
Hello
Thank you for the feedback.
This is not a bug but a feature ;-) I realize that the documentation for the command update_pgsql_node_config is not clear enough and we will fix that.
"Minutes cron interval [01-59]" and "Hours cron interval [01-06]" defines the intervals of minutes and hours where you want your backups to be run.
PgBackMan will generate a random value for minutes and hours for the default cron minutes and cron hours values when you define a backup definition. The random value will be in the interval you have defined in the pgsql node default configuration.
You can of course define your own minutes and hours cron values when defining a backup definition.
regards Rafael Martinez Guerrero