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

Ticket 128: Hot Standby and Streaming Replication

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: Ticket 128: Hot Standby and Streaming Replication
Date: 2010-02-02 23:11:13
Message-ID: 4B68B111.7040203@lelarge.info (view raw or flat)
Thread:
Lists: pgadmin-hackers
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.

If we want to got a bit further, the only idea I had was to allow the
user to see objects' properties but deny to change them. We can also
deny the use of the maintenance window and the restore one. As we don't
already do that when a user doesn't have the priviledge to do so, I
suppose we won't do that. At least for this release. I'm really
interested to implement this in a future release.

Any comments? on the patch and on this "idea".


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

Attachment: ticket128_v1.patch
Description: text/x-patch (3.7 KB)

Responses

pgadmin-hackers by date

Next:From: Dave PageDate: 2010-02-03 09:26:22
Subject: Re: location of query favourites.xml
Previous:From: Guillaume LelargeDate: 2010-02-02 23:02:42
Subject: Re: location of query favourites.xml

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