PgUtils

Easy backup and restore for your remote PostgreSQL database.

Installation

Add this line to your application's Gemfile:

gem 'pg_utils'

And then execute:

$ bundle install

Or install it yourself as:

$ gem install pg_utils

Usage

Add your config file in config/pg_utils.yml

ssh_host: '3.3.3.3'
ssh_user: 'jack'
ssh_port: '33'
ssh_password: '33'
remote_backup_folder: '/my/app/public/backups'
remote_database_name: 'my_database'
remote_database_username: 'user'
remote_database_password: '333'
local_folder: '/my/backup/folder'
local_database: 'my_dev_database'
local_database_username: 'dev'
local_database_password: '555'

Then Download your database from the remote server using:

pg_utils backup

Then restore the most recent backup using:

pg_utils restore

Contributing

Bug reports and pull requests are welcome on GitHub at https://github.com/juniorjp/pg_utils. This project is intended to be a safe, welcoming space for collaboration, and contributors are expected to adhere to the Contributor Covenant code of conduct.

License

The gem is available as open source under the terms of the MIT License.