Skip to content

Capistrano tasks for automatic WAL-E setup (continuous PostgreSQL backups)

License

Notifications You must be signed in to change notification settings

capistrano-plugins/capistrano-wal-e

Repository files navigation

Capistrano::UnicornNginx

Capistrano tasks for automatic and sensible WAL-E configuration

Goals of this plugin:

  • automatic configuration for setting up WAL-E for continuous backups of PostgreSQL.

Specifics:

  • generates environment variables for WAL-e
  • sets up cronjobs for base backups and deleting old ones

Almost all the setup has been done by capistrano. There is just one manual step that needs to be done.

  • Uncomment and modify these lines in your postgresql.conf file under /etc/postgresql/9.3/main/
wal_level = archive
archive_mode = on
archive_command = 'envdir /etc/wal-e.d/env /usr/local/bin/wal-e wal-push %p'
archive_timeout = 60

Then restart postgres: service postgresql restart.

  • Test by making the first snapshot backup:
/usr/bin/envdir /etc/wal-e.d/env /usr/local/bin/wal-e backup-push /var/lib/postgresql/9.3/main

capistrano-wal-e works only with Capistrano 3!

Installation

Add this to Gemfile:

group :development do
  gem 'capistrano', '~> 3.2.1'
  gem 'capistrano-wal-e', '~> 0.1.1'
end

And then:

$ bundle install

About

Capistrano tasks for automatic WAL-E setup (continuous PostgreSQL backups)

Resources

License

Code of conduct

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages