birdhousebuilder.recipe.postgres

Introduction

birdhousebuilder.recipe.postgres is a Buildout recipe to install and configure Postgres database with Anaconda. Postgres will be deployed as a Supervisor service.

The recipe is based on https://github.com/makinacorpus/makina.recipe.postgres.

This recipe is used by the Birdhouse project.

The recipe requires that Anaconda is already installed. It assumes that the default Anaconda location is in your home directory ~/anaconda. Otherwise you need to set the ANACONDA_HOME environment variable or the Buildout option anaconda-home.

It installs the postgresql package from a conda channel in a conda environment named birdhouse. The location of the birdhouse environment is .conda/envs/birdhouse. It deploys a Supervisor configuration for Postgres in ~/.conda/envs/birdhouse/etc/supervisor/conf.d/postgres.conf. Supervisor can be started with ~/.conda/envs/birdhouse/etc/init.d/supervisor start.

The Postgres database files are by default in ~/.conda/envs/birdhouse/var/lib/postgres.

The recipe depends on birdhousebuilder.recipe.conda and birdhousebuilder.recipe.supervisor.

Supported options

The recipe supports the following options:

anaconda-home

Buildout option with the root folder of the Anaconda installation. Default: $HOME/anaconda. The default location can also be set with the environment variable ANACONDA_HOME. Example:

export ANACONDA_HOME=/opt/anaconda

Search priority is:

anaconda-home in buildout.cfg
$ANACONDA_HOME
$HOME/anaconda

port

Port used for Postgres. Default: 5433.

pgdata

path to the database files. Default: ~/.conda/envs/birdhouse/var/lib/postgres

initdb

Options for Postgres initialisation. Default: --auth=trust

cmds

psql commands to setup your database schema and users.

Example usage

The following example buildout.cfg installs Postgres with Anaconda:

[buildout]
parts = postgres

anaconda-home = /home/myself/anaconda

[postgres]
recipe = birdhousebuilder.recipe.postgres
port = 5433
cmds =
     createuser -p 5433 --createdb --no-createrole --no-superuser --login demo
     createdb -p 5433 --owner=demo demo

After installing with Buildout start the Postgres service with:

$ cd /home/myself/.conda/envs/birdhouse
$ etc/init.d/supervisord start  # start|stop|restart
$ bin/supervisorctl status      # check that postgres is running

using postgresql from anaconda
refactored postgres setup
using subprocess instead of os.system

0.1.0 (2015-03-30)

Initial Release.

Metadata

Release files for birdhousebuilder.recipe.postgres 0.2.0

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for birdhousebuilder.recipe.postgres 0.2.0
File	Size	Uploaded
birdhousebuilder.recipe.postgres-0.2.0.tar.gz	12.8 kB	Mar 31, 2015	Details

Release files / birdhousebuilder.recipe.postgres-0.2.0.tar.gz

Download URL	birdhousebuilder.recipe.postgres-0.2.0.tar.gz
Size	12.8 kB
Tags	Source
SHA-256 checksum How to use checksums	`9d9b45558eb784ab1a71d49e243bfb50bf10b0f144c89e6c0b48a4476f8d3db7`
BLAKE2b-256 checksum How to use checksums	`add717feff055124aff02bab25245bc4ac28eb619919a49ad4aeaf93f8e1a2a2`
Upload date	Mar 31, 2015
Uploaded using Trusted Publishing? What is trusted publishing?	No