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

Re: [HACKERS] Hot Standby utility and administrator functions

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
Cc: 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 17:16:11
Message-ID: 1225127771.3971.26.camel@ebony.2ndQuadrant (view raw or flat)
Thread:
Lists: pgadmin-hackerspgsql-generalpgsql-hackers
On Mon, 2008-10-27 at 13:08 -0400, Robert Treat wrote:

> Was thinking that admin tools that show hot standby information might
> also want to show the corresponding slave information (from the point
> of view of the master). 

Well, the standby might be persuaded to know something about the master,
but not the other way around. The master:standby relationship is 1:Many,
and not restricted in the way things are daisy-chained. So it's more
than just a pair of servers.

All the slaves will say they are the same if you ask them, so you can't
rely on that to identify them. So you need to specify which two servers
you're interested in comparing and how to identify them externally.

-- 
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Training, Services and Support


In response to

pgsql-hackers by date

Next:From: Ron MayerDate: 2008-10-27 17:36:27
Subject: Re: new correlation metric
Previous:From: Tom LaneDate: 2008-10-27 17:14:56
Subject: Re: array_agg and array_accum (patch)

pgadmin-hackers by date

Next:From: Gevik BabakhaniDate: 2008-10-28 10:47:31
Subject: Re: extending functionality strategy
Previous:From: Robert TreatDate: 2008-10-27 17:08:51
Subject: Re: [HACKERS] Hot Standby utility and administrator functions

pgsql-general by date

Next:From: KevDate: 2008-10-27 18:08:35
Subject: array_cat null reasoning
Previous:From: Robert TreatDate: 2008-10-27 17:08:51
Subject: Re: [HACKERS] Hot Standby utility and administrator functions

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