pgbundle

bundling postgres extension

install

gem install pgbundle

usage

define your dependent postgres extensions in a Pgfile like this:

#Pgfile

database 'my_database', host: 'my.db.server', use_sudo: true, system_user: 'postgres'

pgx 'hstore'
pgx 'my_extension', '1.0.2', github: me/my_extension
pgx 'my_other_extionsion', :git => 'https://github.com/me/my_other_extionsion.git'
pgx 'my_ltree_dependend_extension', github: me/my_ltree_dependend_extension, require: 'ltree'

install your extension

pgbundle install

installs the extensions and dependencies on your database server

check your dependencies

pgbundle check

checks whether all dependencies are available for creation on the database server

getting started

if your already have some database on your current project you can get a starting point with

pgbundle init

lets say your database named 'my_project' runs on localhost with user postges

pgbundle init my_project -u postgres -h localhost