need a shim between postgresql and pgpool startup

[Matthew Seaman]

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 pgpooll,
> 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 databases.

> 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

-- 
Dr Matthew J Seaman MA, D.Phil.
PGP: http://www.infracaninophile.co.uk/pgpkey


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 267 bytes
Desc: OpenPGP digital signature
Url : http://lists.freebsd.org/pipermail/freebsd-rc/attachments/20120311/3bbfb58f/signature.pgp