Re: [HACKERS] Remastering using streaming only replication?

2011-09-26 Thread Fujii Masao
On Thu, Sep 22, 2011 at 1:52 AM, Josh Berkus j...@agliodbs.com wrote:
 Fujii,

 I haven't really been following your latest patches about taking backups
 from the standby and cascading replication, but I wanted to see if it
 fulfills another TODO: the ability to remaster (that is, designate the
 lead standby as the new master) without needing to copy WAL files.

Sorry, I could not follow you. I believe that we can remaster even in 9.1.
When the master crashes, we can choose the lead standby by comparing
each standby replay location, and can promote it by pg_ctl promote.

What remaster feature are you expecting we should develop in 9.2?

Regards,

-- 
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


[HACKERS] Remastering using streaming only replication?

2011-09-21 Thread Josh Berkus
Fujii,

I haven't really been following your latest patches about taking backups
from the standby and cascading replication, but I wanted to see if it
fulfills another TODO: the ability to remaster (that is, designate the
lead standby as the new master) without needing to copy WAL files.

Supporting remastering using steaming replication only was on your TODO
list when we closed 9.1.  It seems like this would get solved as a
side-effect, but I wanted to confirm that.

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

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers