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

Re: Ticket 128: Hot Standby and Streaming Replication

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: Ticket 128: Hot Standby and Streaming Replication
Date: 2010-02-03 21:00:23
Message-ID: 4B69E3E7.5050001@lelarge.info (view raw or flat)
Thread:
Lists: pgadmin-hackers
Le 03/02/2010 21:26, Magnus Hagander a écrit :
> On Wed, Feb 3, 2010 at 21:22, Guillaume Lelarge <guillaume(at)lelarge(dot)info> wrote:
>> 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.
> 
> Hmm. In that case, a way to do it should perhaps be created :-)
> 

This means working on patch for the Streaming Replication. Could be
interesting, but not something I can do right now.


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

In response to

Responses

pgadmin-hackers by date

Next:From: Quan ZongliangDate: 2010-02-04 14:22:37
Subject: Re: import: crash fixed
Previous:From: Magnus HaganderDate: 2010-02-03 20:26:09
Subject: Re: Ticket 128: Hot Standby and Streaming Replication

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