From: | Magnus Hagander <magnus(at)hagander(dot)net> |
---|---|
To: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
Cc: | pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org> |
Subject: | Re: Ticket 128: Hot Standby and Streaming Replication |
Date: | 2010-02-03 20:26:09 |
Message-ID: | 9837222c1002031226i4c358f98vbee935c0ea69606a@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
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 :-)
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2010-02-03 21:00:23 | Re: Ticket 128: Hot Standby and Streaming Replication |
Previous Message | Guillaume Lelarge | 2010-02-03 20:22:42 | Re: Ticket 128: Hot Standby and Streaming Replication |