Re: Feature Request: pg_replication_master() - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Feature Request: pg_replication_master()
Date
Msg-id 50DB561E.4010106@agliodbs.com
Whole thread Raw
In response to Re: Feature Request: pg_replication_master()  (Robert Treat <rob@xzilla.net>)
Responses Re: Feature Request: pg_replication_master()
List pgsql-hackers
> I'm not sure that my POV exactly matches up with Tom's, but on the
> last point, I strongly agree that the use of the trigger file makes it
> trivial to integrate Postgres warm standby management into 3rd party
> tools. I'm not against coming up with a new API that's better for
> postgres dedicated tools, but I think you're going to really make it
> harder for people if you eliminate the trigger file method for coming
> out of recovery.

Huh.  My experience integrating PostgreSQL with Puppet or SALT 
infrastructures is that they don't understand trigger files, but they do 
understand configuration+restart/reload.  Before we get off on an 
argument about which is better, though, here's an important question: 
how difficult would it be to make the trigger file optional, but still 
effective?

That is, I personally don't care if other people use trigger files, I 
just hate to be forced to use them myself.  Is it possible to support 
both options without making either the code or the API hopelessly confusing?

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com



pgsql-hackers by date:

Previous
From: Greg Smith
Date:
Subject: Re: buffer assertion tripping under repeat pgbench load
Next
From: Heikki Linnakangas
Date:
Subject: Re: Feature Request: pg_replication_master()