Backup

How to back up server services.

Prepare

CREATE ROLE backup WITH
    NOSUPERUSER
    NOCREATEDB
    NOCREATEROLE 
    PASSWORD 'tropcool'
    LOGIN
    ;

Add in the file pg_hba.conf :

local all backup trust

Reload with SELECT pg_reload_conf();.

With postgres : GRANT SELECT ON ALL TABLES IN SCHEMA public TO backup;

Connect with sudo -u postgres psql --username=backup --host localhost --dbname=kanboard_db

pg_dump kanboard_db --username=backup --host=localhost > dumpfile.test

Does not work because backup can't access sequences.

See ServerScripts/Backup.

Use Jenkins.