CFEngine policies to set up PostgreSQL

From: Ted Zlatanov <tzz(at)lifelogs(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: CFEngine policies to set up PostgreSQL
Date: 2012-12-21 09:39:36
Message-ID: 87wqwbiw13.fsf@lifelogs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I am interested in writing CFEngine policies to configure PostgreSQL for
the Database::Install sketch I maintain
(https://github.com/cfengine/design-center/tree/master/sketches/databases/db_install).

Currently the setup is just concerned with installing the packages and
starting the default server on popular RedHat (+CentOS, +Fedora) and
Debian (+Ubuntu) distributions. It supports client and client+server
install mode. The JSON syntax should be pretty easy to understand:

https://github.com/cfengine/design-center/blob/master/sketches/databases/db_install/params/demo.json

I am looking for advice on making the PostgreSQL support better:

- check the existing client and client+server packages for the Debian and RedHat variants

- support other distributions

- create some useful default configurations based on the hardware: EC2
instance type; memory size; CPU count; disk space...

- make getting started with PostgreSQL easier for new users

If you have any interest in helping you can either let me know here or
use the GitHub interface directly. Either way, I appeciate your
attention and will report back when I have updated Database::Install.

Thanks
Ted

Browse pgsql-admin by date

  From Date Subject
Next Message Gary Stainburn 2012-12-21 10:12:24 Re: create role?
Previous Message Kevin Grittner 2012-12-20 22:46:12 Re: Autovacuum issues with truncate and create index ...