Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tnqom-0007qD-ON for pgsql-admin@arkaria.postgresql.org; Wed, 26 Dec 2012 13:14:44 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1Tnqol-0004Xz-PJ for pgsql-admin@arkaria.postgresql.org; Wed, 26 Dec 2012 13:14:43 +0000 Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tm3Db-0004Ju-NF for pgsql-admin@postgresql.org; Fri, 21 Dec 2012 14:04:55 +0000 Received: from plane.gmane.org ([80.91.229.3]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tm3Da-0007vd-Db for pgsql-admin@postgresql.org; Fri, 21 Dec 2012 14:04:55 +0000 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1Tm3Dl-0006Wt-Ai for pgsql-admin@postgresql.org; Fri, 21 Dec 2012 15:05:05 +0100 Received: from c-65-96-148-157.hsd1.ma.comcast.net ([65.96.148.157]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Fri, 21 Dec 2012 15:05:05 +0100 Received: from tzz by c-65-96-148-157.hsd1.ma.comcast.net with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Fri, 21 Dec 2012 15:05:05 +0100 X-Injected-Via-Gmane: http://gmane.org/ Mail-Followup-To: pgsql-admin@postgresql.org Reply-To: pgsql-admin@postgresql.org To: pgsql-admin@postgresql.org From: Ted Zlatanov Subject: CFEngine policies to set up PostgreSQL Date: Fri, 21 Dec 2012 04:39:36 -0500 Organization: =?utf-8?B?0KLQtdC+0LTQvtGAINCX0LvQsNGC0LDQvdC+0LI=?= @ Cienfuegos Lines: 30 Message-ID: <87wqwbiw13.fsf@lifelogs.com> Mime-Version: 1.0 Content-Type: text/plain X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: c-65-96-148-157.hsd1.ma.comcast.net X-Face: bd.DQ~'29fIs`T_%O%C\g%6jW)yi[zuz6; d4V0`@y-~$#3P_Ng{@m+e4o<4P'#(_GJQ%TT= D}[Ep*b!\e,fBZ'j_+#"Ps?s2!4H2-Y"sx" Mail-Copies-To: never User-Agent: Gnus/5.130006 (Ma Gnus v0.6) Emacs/24.3.50 (gnu/linux) Cancel-Lock: sha1:+T6+5UGxo0hgH+27g3AN/3ERlyw= X-Pg-Spam-Score: -0.3 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org 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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin