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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers pgsql-general pgsql-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

Browse pgadmin-hackers by date

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

Browse pgsql-general by date

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

Browse pgsql-hackers by date

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