March 5th, 2011 by depesz | Tags: , , , , , | 2 comments »
Did it help? If yes - maybe you can help me?

On 16th of February, , Robert Haas committed patch:

pg_ctl promote
 
Fujii Masao, reviewed by Robert Haas, Stephen Frost, and Magnus Hagander.

Commit log is very short, functionality is not really new, but the important thing is that we're getting support for PostgreSQL replication in more “administrative" places, which makes the whole process more streamlined.

Basically this commit adds another way of finishing streaming. Instead of using trigger file, you can now simply do

pg_ctl -D /DATA promote

to change your SR-Slave into standalone Pg.

  1. 2 comments

  2. # Robert Wultsch
    Mar 6, 2011

    Tangential to the topic, do all slaves still need to be rebuilt when a promotion occurs?

  3. Mar 6, 2011

    @Robert:

    AFAIK – yes.

    There are some tricks to avoid it – for example – check http://denishjpatel.blogspot.com/2010/11/possibility-of-graceful-switchover.html

Leave a comment