Thread: Grouping servers
Hi all, I was at a customer's office wednesday and thursday and they had an interesting request for pgAdmin. I'm not sure it was not already discussed here, so I prefer asking before coding. They'll have to administrate around 150 PostgreSQL servers. They intend to use pgAdmin, but 150 registered servers will probably be a mess in the treeview. We don't have (AFAICT) grouping functionality, folder-like to group servers by <insert here everyone's idea> (geographical for example: one group for all Paris servers, another one for all servers in Marseilles, etc.). Was this already discussed (and maybe rejected)? in fact, I see no reason not to have this (simple) functionality (simple if we stay with one level). Comments? Better ideas? PS: right now, I told them to declare each group in different .reg files (they work on windows). When they need to work on one group, they first register the associated .reg file and then launch pgAdmin... but that's not a really good way to do it. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com
Guillaume Lelarge wrote: > PS: right now, I told them to declare each group in different .reg files (they > work on windows). When they need to work on one group, they first register the > associated .reg file and then launch pgAdmin... but that's not a really good > way to do it. Another workaround is to prefix the server names. "Paris_server1", "Paris_dwserver" and so forth. The list will be long, but servers will be grouped together since the list is in alphabetical order. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com
Guillaume Lelarge wrote: > Hi all, > > I was at a customer's office wednesday and thursday and they had an > interesting request for pgAdmin. I'm not sure it was not already discussed > here, so I prefer asking before coding. > > They'll have to administrate around 150 PostgreSQL servers. They intend to use > pgAdmin, but 150 registered servers will probably be a mess in the treeview. > We don't have (AFAICT) grouping functionality, folder-like to group servers by > <insert here everyone's idea> (geographical for example: one group for all > Paris servers, another one for all servers in Marseilles, etc.). > > Was this already discussed (and maybe rejected)? in fact, I see no reason not > to have this (simple) functionality (simple if we stay with one level). > > Comments? Better ideas? I like it. Even better if it can dynamically create the node when needed, so that you can register servers directly under the "root" node. Then there won't be "an extra click" for those who just have 5-10 servers and don't need the grouping. //Magnus
> We don't have (AFAICT) grouping functionality, folder-like to group servers by > <insert here everyone's idea> (geographical for example: one group for all > Paris servers, another one for all servers in Marseilles, etc.). Cool idea. Now, pgAdmin has a root node named "Servers". It is the first server group. The users should can create more group node under it. The group have some properties, name, desc, and customized order, and so on. ----------------------------------------------- Quan Zongliang quanzongliang@gmail.com CIT JAPAN: http://www.cit.co.jp CIT CHINA: http://www.citbj.com.cn