pgbackman icon indicating copy to clipboard operation
pgbackman copied to clipboard

Problems when updating cron

Open yerrysherry opened this issue 7 years ago • 1 comments

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

yerrysherry avatar Dec 17 '17 22:12 yerrysherry

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

rafaelma avatar Dec 30 '17 05:12 rafaelma