manage postgres backups with jenkins

with jenkins you can use it also for backing up your postgres database scheduled with cron.

i assume you have jenkins user in system. login as user postgres and go to psql console: create user jenkins in psql:

create user jenkins;

now we need to grant permissions for this user:

GRANT SELECT ON ALL TABLES IN SCHEMA public TO jenkins;

GRANT CONNECT ON DATABASE yourdatabase to jenkins;
\c yourdatabase
GRANT USAGE ON SCHEMA public to jenkins;

GRANT SELECT ON ALL SEQUENCES IN SCHEMA public TO jenkins;

GRANT SELECT ON ALL TABLES IN SCHEMA public TO jenkins;