Date: Sun, 11 Mar 2012 08:04:38 +0000 From: Matthew Seaman <matthew@FreeBSD.org> To: Jason Helfman <jgh@FreeBSD.org> Cc: rc@FreeBSD.org, "Randal L. Schwartz" <merlyn@stonehenge.com> Subject: Re: need a shim between postgresql and pgpool startup Message-ID: <4F5C5C96.8030505@FreeBSD.org> In-Reply-To: <CAMuy=%2BiSCjS5ogPhV5NRu0v2Vw6Wh1JwTJhXvvZ%2B9dR4ZBdjtA@mail.gmail.com> References: <86r4x4dv1r.fsf@red.stonehenge.com> <4F57D10D.1030501@FreeBSD.org> <86aa3sdqu9.fsf@red.stonehenge.com> <CAMuy=%2BiSCjS5ogPhV5NRu0v2Vw6Wh1JwTJhXvvZ%2B9dR4ZBdjtA@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enigFB93B0C379BB7BA49EDBB291 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable 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 pgpo= oll, > and require it in > rc? Um.. running pgpool on a different server than the actual postgresql instance is a pretty common practice actually. Given 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. The 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. '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. Hmmm... maybe a DATABASES script to provide a sequencing point, similarly to LOGIN or NETWORKING ? Cheers, Matthew --=20 Dr Matthew J Seaman MA, D.Phil. PGP: http://www.infracaninophile.co.uk/pgpkey --------------enigFB93B0C379BB7BA49EDBB291 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2.0.16 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk9cXJwACgkQ8Mjk52CukIxIaACfQuLTR32Wsf7iKwXDS0qGMt/+ KcsAnilp3mqDcHGuKjELfpA6Zdj+xB8t =817S -----END PGP SIGNATURE----- --------------enigFB93B0C379BB7BA49EDBB291--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4F5C5C96.8030505>