Capistrano::PostgreSQL

Note: this plugin works only with Capistrano 3. Please check the capistrano gem version you're using before installing this gem: $ bundle show | grep capistrano The plugin for Capistrano 2 is here.

About

Capistrano PostgreSQL plugin abstracts and speeds up common administration tasks for PostgreSQL when deploying rails apps.

Here are the specific things this plugin does for your capistrano deployment process:

• Creates a new PostgreSQL database and database user on the server
• Generates and populates database.yml file on all release nodes (using ssh)
• Support for multi-server setup: separate db and app nodes ( versions > 4.0 )

Note: gem version 4 introduces some breaking changes. If you installed gem version 3 or below you might want to follow the upgrade instructions.

Installation

Put the following in your application's Gemfile:

group :development do
  gem 'capistrano', '~> 3.11'
  gem 'capistrano-postgresql', '~> 6.2'
end

Then:

$ bundle install

Usage

In a standard RAILS app, you need to put the following in Capfile file:

require 'capistrano/postgresql' 

You need to include ONLY ONE of the following in your config/deploy/*.rb files:

set :pg_password, ENV['DATABASE_USER_PASSWORD'] # Example is an ENV value, but you can use a string instead
set :pg_ask_for_password, true # Prompts user for password on execution of setup
set :pg_generate_random_password, true # Generates a random password on each setup

Execution of cap ENV setup will run ALTER USER on pg_username if there is a different password. If you're using :pg_generate_random_password, you'll get a new random password on each run.

Example config:

server 'yoursite.net', user: 'ssh_username_here', roles: %w{app db}
set :stage, :development
set :branch, 'development'
# ==================
# Postgresql setup
set :pg_without_sudo, false
set :pg_host, 'db.yoursite.net'
set :pg_database, 'pg_database_name_here'
set :pg_username, 'pg_username_here'
#set :pg_generate_random_password, true
#set :pg_ask_for_password, true
set :pg_password, ENV['yoursite_PGPASS']
set :pg_extensions, ['citext','hstore']
set :pg_encoding, 'UTF-8'
set :pg_pool, '100'

Finally, to setup the server(s), run:

$ bundle exec cap development setup

Requirements

• Be sure to remove config/database.yml from your application's version control.
• Your pg_hba.conf must include local all all trust. We ssh into the servers to execute psql commands.
• Make sure the deploy_to path exists and has the right privileges on your servers. The ~ symbol (i.e. ~/myapp) is not supported.
• Within your app/config/deploy/{env}.rb files, you need to specify at least one :app and one :db server (they can be on the same host; roles: %w{web app db})
• If you have multiple :db role hosts, it's necessary to specify :primary => true on the end of your primary :db server.
• gem >= 6.0.0 requires SSHKIT >= 1.17.0 as passwords are redacted from logging.

How it works

How the plugin works

Read it only if you want to learn more about the plugin internals.

Configuration

A full list of configuration options.

The list can be overwhelming so consult it only if you're looking for something specific.

Customizing the database.yml template

Wiki page about the database.yml format.

More Capistrano automation?

Check out capistrano-plugins github org.

Contributing and bug reports

Contributions and improvements are very welcome.

If something is not working for you, or you find a bug, please report it.

Thanks

Here are other plugins and people this project was based upon:

• Matt Bridges - capistrano postgresql tasks from this plugin are heavily based on his capistrano-recipes repo.

License

MIT