makina.recipe.postgres 0.1

init a postgresql's database for the project

Downloads ↓

================
makina.recipe.postgres package
================

.. contents::

What is makina.recipe.postgres ?
==================

it is a recipe that initialize a database from initdb command.

How to use makina.recipe.postgres ?
=====================

EXAMPLE (postgis init)::

        parts =
            ...
            initdb

        [initdb]
        recipe = makina.recipe.postgres
        bin = ${buildout:directory}/parts/postgresql/bin
        initdb = --auth=trust --pgdata=${buildout:directory}/var/postgres
        pgdata = ${buildout:directory}/var/postgres
        port = 5433
        cmds =
            createuser -p 5433 --createdb    --no-createrole --no-superuser --login admin
            createuser -p 5433 --no-createdb --no-createrole --no-superuser --login zope
            createdb -p 5433 --owner admin --encoding LATIN9 zsig
            createlang -p 5433 plpgsql zsig
            psql -d zsig -p 5433 -f ${buildout:directory}/parts/postgis/share/lwpostgis.sql
            psql -d zsig -p 5433 -f ${buildout:directory}/parts/postgis/share/spatial_ref_sys.sql



bin option can be just a sym link from the /usr/bin (where all postgresql system binaries are) if you don't want to install postgres with buildout.

• Author: jeanmichel FRANCOIS
• Home Page: http://www.makina-corpus.org
• License: GPL
• Categories
  • Programming Language :: Python
  • Topic :: Software Development :: Libraries :: Python Modules
• Package Index Owner: toutpt
• DOAP record: makina.recipe.postgres-0.1.xml