Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Hot Standby utility and administrator functions

From: Emmanuel Cecchet <manu(at)frogthinker(dot)org>
To: Simon Riggs <simon(at)2ndQuadrant(dot)com>
Cc: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>, pgsql-hackers(at)postgresql(dot)org, pgadmin-hackers(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: [HACKERS] Hot Standby utility and administrator functions
Date: 2008-10-27 16:53:37
Message-ID: 4905F211.4060807@frogthinker.org (view raw or flat)
Thread:
Lists: pgadmin-hackerspgsql-generalpgsql-hackers
Simon Riggs wrote:
> On Mon, 2008-10-27 at 11:42 -0400, Robert Treat wrote:
>
>   
>> On Monday 20 October 2008 05:25:29 Simon Riggs wrote:
>>     
>>> I'm looking to implement the following functions for Hot Standby, to
>>> allow those with administrative tools or management applications to have
>>> more control during recovery. Please let me know if other functions are
>>> required.
>>>
>>> What else do we need?
>>>
>>>       
>> Is it possible to give the master/slave knowledge about each other?
>>     
>
> Yes, but for what reason?
>
> The project I'm working on is Hot Standby, not streaming replication.
> That will link things together better than they are now, so I'd probably
> rather not prejudge/duplicate that.
>   
I think this could make sense in the case of a network partition (split 
brain).
If we need to perform a reconciliation after a partition we will need to 
know when a slave has switched to master and what transactions have been 
processed on each side.
Another use case is probably to implement failback once the former 
master has been restarted to just send the diff since failover happened.
Actually to complement pg_last_recovered_xact_xid(), 
pg_last_completed_xact_xid() or pg_last_recovered_xact_timestamp(), I 
would like to have something like pg_xact_xid_status(txid) that would 
return something of a xid_status type that can be completed, recovered 
or not_found with a timestamp that would only be meaningful if the 
status is recovered or completed.

Regards,
Emmanuel

-- 
Emmanuel Cecchet
FTO @ Frog Thinker 
Open Source Development & Consulting
--
Web: http://www.frogthinker.org
email: manu(at)frogthinker(dot)org
Skype: emmanuel_cecchet


In response to

pgsql-hackers by date

Next:From: Jonah H. HarrisDate: 2008-10-27 17:04:57
Subject: Re: SQL/MED compatible connection manager
Previous:From: Pavel StehuleDate: 2008-10-27 16:48:11
Subject: Re: WIP: default values for function parameters

pgadmin-hackers by date

Next:From: Robert TreatDate: 2008-10-27 17:08:51
Subject: Re: [HACKERS] Hot Standby utility and administrator functions
Previous:From: Simon RiggsDate: 2008-10-27 16:12:18
Subject: Re: [HACKERS] Hot Standby utility and administrator functions

pgsql-general by date

Next:From: Robert TreatDate: 2008-10-27 17:08:51
Subject: Re: [HACKERS] Hot Standby utility and administrator functions
Previous:From: Luca FerrariDate: 2008-10-27 16:43:08
Subject: empty table explain...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group