From owner-freebsd-ports@FreeBSD.ORG Wed Jan 24 22:11:14 2007 Return-Path: X-Original-To: freebsd-ports@freebsd.org Delivered-To: freebsd-ports@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 9C21816A400; Wed, 24 Jan 2007 22:11:14 +0000 (UTC) (envelope-from lavalamp@spiritual-machines.org) Received: from mail.digitalfreaks.org (arbitor.digitalfreaks.org [216.151.95.158]) by mx1.freebsd.org (Postfix) with ESMTP id 75DC713C448; Wed, 24 Jan 2007 22:11:14 +0000 (UTC) (envelope-from lavalamp@spiritual-machines.org) Received: from localhost (localhost [127.0.0.1]) by mail.digitalfreaks.org (Postfix) with ESMTP id CF7DE17B3E; Wed, 24 Jan 2007 16:43:12 -0500 (EST) Received: from mail.digitalfreaks.org ([127.0.0.1]) by localhost (mail.digitalfreaks.org [127.0.0.1]) (amavisd-maia, port 10024) with ESMTP id 64522-13; Wed, 24 Jan 2007 16:43:11 -0500 (EST) Received: from mail.digitalfreaks.org (mail.digitalfreaks.org [216.151.95.156]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.digitalfreaks.org (Postfix) with ESMTP id A250617B32; Wed, 24 Jan 2007 16:43:11 -0500 (EST) Date: Wed, 24 Jan 2007 16:43:11 -0500 (EST) From: "Brian A. Seklecki" X-X-Sender: lavalamp@arbitor.digitalfreaks.org To: slony1-general@gborg.postgresql.org, freebsd-ports@freebsd.org, Vivek Khera , Oleg Gawriloff Message-ID: <20070124163435.F18034@arbitor.digitalfreaks.org> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.2 Cc: Subject: Apache-Style Profiles for FreeBSD ports/databases/slony/* X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 24 Jan 2007 22:11:14 -0000 http://digitalfreaks.org/~lavalamp/slon.in Since ShMem can't be split across different PgSQL instances on the same machine (even with Jails), hard PgSQL separation is required (thus domains in network auth mechanisms). For Slony, there's a 1:1 set of processes per authentication credentials (db connect string), so on systems where a single PgSQL instance exists but credentials are split up to serve multiple clients with autonomous table/view/replication sets, multiple instances (PID files, configs, db connect strings, etc.) must run and coexist without overlapping. Thus, unambiguously stolen from the Apache apache22.sh.in. Uses all the rc.subr(8) hooks. This will need %%PREFIX%% substitution to make its way back into the ports tree. Also I do some more aggressive sanity checking on configs/variables than the Apache version. May be slightly redundant, but we're talking about DBA work here. >:} Love, l8* -lava (Brian A. Seklecki - Pittsburgh, PA, USA) http://www.spiritual-machines.org/