From owner-freebsd-rc@FreeBSD.ORG Sun Mar 11 08:52:31 2012 Return-Path: Delivered-To: rc@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 2A40A106566B; Sun, 11 Mar 2012 08:52:31 +0000 (UTC) (envelope-from utisoft@gmail.com) Received: from mail-bk0-f54.google.com (mail-bk0-f54.google.com [209.85.214.54]) by mx1.freebsd.org (Postfix) with ESMTP id 5450E8FC17; Sun, 11 Mar 2012 08:52:29 +0000 (UTC) Received: by bkcjc3 with SMTP id jc3so2721178bkc.13 for ; Sun, 11 Mar 2012 00:52:29 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:sender:in-reply-to:references:from:date :x-google-sender-auth:message-id:subject:to:cc:content-type :content-transfer-encoding; bh=rqt388d83eo8/5UnQv7mdZw/1t8nBuEKyXoXNbZP7ZU=; b=JpYk765ycH5JxKUftbYdFcpJFUJZcUG2Fbw0K+eD8ZSvGM5U3wNvDFBFiDefHN341E kDSP2dXi+qiTCDs6AnBoLwaBXLmkFa4iDHjgCOcnkQAC+6cN5lqbAi+bPUUOPFJCZaNb ixhWuqi67PWDg9ZJnSqwhOAjJURPdyOxs0RCSXCwIKFBvzxHm8mKT7pPe5bVu44ADvhj f/yMa/F0viXcTwxlquwTVJDr5lWPsTLhD2p/r6cNydVkdLDUuoQAOJPaKf0JN5xLSjVi 8ai2z0oeHnD+Gf8vHuapgEL1AS086IwRCO/vON/sQ3lukEsxE5YxKjYXpChMRS2ouZg7 +nDw== Received: by 10.204.145.155 with SMTP id d27mr3281957bkv.36.1331455949204; Sun, 11 Mar 2012 00:52:29 -0800 (PST) MIME-Version: 1.0 Sender: utisoft@gmail.com Received: by 10.204.202.142 with HTTP; Sun, 11 Mar 2012 00:51:59 -0800 (PST) In-Reply-To: <4F5C5C96.8030505@FreeBSD.org> References: <86r4x4dv1r.fsf@red.stonehenge.com> <4F57D10D.1030501@FreeBSD.org> <86aa3sdqu9.fsf@red.stonehenge.com> <4F5C5C96.8030505@FreeBSD.org> From: Chris Rees Date: Sun, 11 Mar 2012 08:51:59 +0000 X-Google-Sender-Auth: ksNcDvgKKJmLGJp0eQrqPBpr0Tw Message-ID: To: Matthew Seaman Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Cc: rc@freebsd.org, Jason Helfman , "Randal L. Schwartz" Subject: Re: need a shim between postgresql and pgpool startup X-BeenThere: freebsd-rc@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: "Discussion related to /etc/rc.d design and implementation." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 11 Mar 2012 08:52:31 -0000 On 11 March 2012 08:04, Matthew Seaman wrote: > On 11/03/2012 07:02, Jason Helfman wrote: >> When are you going to run >> pgpool without a pgsql server? Why not have a dependeny on pgsq on pgpoo= ll, >> and require it in >> rc? > > Um.. running pgpool on a different server than the actual postgresql > instance is a pretty common practice actually. =A0Given it can manage > things like fail-over or distributing clients between replicated database= s. > >> Am I off-base, or would there be instances where you would run pgpool >> outside of an environment >> running pgsql-server? > > Ah, but was not the problem in this case. =A0The problem is pgpool > starting up right after pgsql in the rcorder sequence, and getting > confused because postgresql still hadn't finished initializing itself > and wasn't ready to answer queries yet, even though its rc-script had > returned. > > However your question is valid -- I can't see that there's any means of > ensuring that pgpool would start after a local postgresql instance built > into the pgpool rc script. =A0'REQUIRE postgresql' seems a bit strong, > given there's no need to have postgresql installed on the same machine. > Should there be one however, then the ordering is desirable. =A0Hmmm... > maybe a DATABASES script to provide a sequencing point, similarly to > LOGIN or NETWORKING ? REQUIRE does not actually mean require; it means AFTER. Chris