Date: Sun, 11 Mar 2012 08:51:59 +0000 From: Chris Rees <crees@freebsd.org> To: Matthew Seaman <matthew@freebsd.org> Cc: rc@freebsd.org, Jason Helfman <jgh@freebsd.org>, "Randal L. Schwartz" <merlyn@stonehenge.com> Subject: Re: need a shim between postgresql and pgpool startup Message-ID: <CADLo83-teiN3usVf60PwV9-4qUVO2DC2DGfTzpO_gM9pF7zfUA@mail.gmail.com> In-Reply-To: <4F5C5C96.8030505@FreeBSD.org> References: <86r4x4dv1r.fsf@red.stonehenge.com> <4F57D10D.1030501@FreeBSD.org> <86aa3sdqu9.fsf@red.stonehenge.com> <CAMuy=%2BiSCjS5ogPhV5NRu0v2Vw6Wh1JwTJhXvvZ%2B9dR4ZBdjtA@mail.gmail.com> <4F5C5C96.8030505@FreeBSD.org>
next in thread | previous in thread | raw e-mail | index | archive | help
On 11 March 2012 08:04, Matthew Seaman <matthew@freebsd.org> 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CADLo83-teiN3usVf60PwV9-4qUVO2DC2DGfTzpO_gM9pF7zfUA>