Re: Ticket 128: Hot Standby and Streaming Replication

Le 03/02/2010 21:04, Magnus Hagander a écrit :
> On Wed, Feb 3, 2010 at 00:11, Guillaume Lelarge <guillaume(at)lelarge(dot)info> wrote:
>> Hi,
>>
>> I tried both of them yesterday night and tonight to have a look at what
>> could be done on pgAdmin for these features. AFAICT, not a lot.
>>
>> Actually, I have a really small patch that adds some informations in the
>> server panel. This information is quite simple. It tells the user if the
>> selected server is in recovery mode and the last xlog replay location.
>> I'm not sure we can do more. Streaming Replication can be detected if
>> max_wal_senders is greater than zero, but I'm not sure we really need to
>> add this kind of information on the server panel.
>
> It would be interesting to know *which* slaves are connected to a master, no?
>

AFAICT, there is no way to know that automatically in Hot Standby and in
Streaming Replication. If you know some way to get that, I'm really
interested. At first, I had hoped I could at least get the conninfo
string on the slave, but recovery parameters are not available via show.

--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com