Start a new topic

Show all Db in postgresql

[This topic is migrated from our old forums. The original author name has been removed]

Hi, In demo version of dbvisualizer, when i connect to a database. I can see all database on the postgres server not only the one in URL. The other database (not referenced in url) are not accessible but visible If i use the full version, i can only see the database referenced in url. Can you mix this two behavior, see all database in full version and list object if i have the good credential on it. It's boring to create for every database a connection ;). Thank you

Hi guys,


I just wanted to let you know that we have released DbVisualizer 9.5 today with support for the feature you asked for. Please upgrade to the latest official version. Easiest is that you open Help->Check for Update in DbVisualizer to perform the upgrade.


An alternative is that you download from our web site: 


http://www.dbvis.com/download/


Best Regards,

Hans

[This reply is migrated from our old forums.]

Re: Show all Db in postgresql
Hi, We just launched the BETA testing of the upcoming 9.5 version. This version supports having a single database connection in DbVisualizer and from it access multiple PostgreSQL databases. It would be great if you can give it a test and verify. http://www.dbvis.com/download/beta/ For more information about the news in the BETA version: http://www.dbvis.com/doc/relnotes/index.jsp?showheader=false&showtoc=false&version=9.5-BETA We plan to go public with 9.5 in a few weeks. Regards Roger
[This reply is migrated from our old forums.]

Re: Show all Db in postgresql
Hi, We just launched the BETA testing of the upcoming 9.5 version. This version supports having a single database connection in DbVisualizer and from it access multiple PostgreSQL databases. It would be great if you can give it a test and verify. http://www.dbvis.com/download/beta/ For more information about the news in the BETA version: http://www.dbvis.com/doc/relnotes/index.jsp?showheader=false&showtoc=false&version=9.5-BETA We plan to go public with 9.5 in a few weeks. Regards Roger
[This reply is migrated from our old forums.]

Re: Show all Db in postgresql
Hi Tobia, This will most likely be part of the next feature version. Best Regards, Hans
[This reply is migrated from our old forums. The original author name has been removed]

Re: Show all Db in postgresql
Hello Any news? One vote from us too. We will soon have tens of databases in a single PostgreSQL server and it would surely be useful to have an automatic list under the server icon.
[This reply is migrated from our old forums.]

Re: Show all Db in postgresql
Hi Thomas, I have registered your vote. This is something we will look into again for the next feature release. Best Regards, Hans
[This reply is migrated from our old forums. The original author name has been removed]

Re: Show all Db in postgresql
Hi, We use this tool for years very intensive and successful (currently about 27 year licenses DbVisualizer Pro). The feature "Show all PostgreSQL-DBs" is very important for us, because we use in production currently about 100 PostgreSQL databases. I am therefore voting here also for this feature! Best regards, Thomas
[This reply is migrated from our old forums.]

Re: Show all Db in postgresql
Hi, This has been moved up on the list and we'll be looking into it for an upcoming version. There is no date set yet. Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: Show all Db in postgresql
Dbvis devs, Yeah... the tool seems great but this is a really annoying limitation. I would buy the tool definitly if this was corrected. Cheers!
[This reply is migrated from our old forums. The original author name has been removed]

Re: Show all Db in postgresql
Please add my vote for this feature. In my view, way of implementing this feature is of secondary importance - comparing to implementing the feature (one way or another) as soon as possible. Regards, Mario
[This reply is migrated from our old forums.]

Re: Show all Db in postgresql
Thanks Jonas. I will add your suggestions to the ticket. Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: Show all Db in postgresql
I'm glad to see that this issue gets some attention. One drawback of the pgadmin approach is that settings are done on the cluster or server level and no settings (among them credentials and search_path) can be set on a database level. If I may suggest, I would like a solution where the levels 'Databases' and the one with the database name could be dropped from the browsing tree, like for e.g. Oracle. The levels do provide very little extra information. Like this: * "connection name" ** Schemas *** information_schema *** mydata *** public (default) ** DBA Views The ability to query and present the databases could be integrated it the connection making wizard or an new tab on the connection level named something like 'all databases'. Here, an tool to quickly define a new connection could be a nice extra feature. Another place could be as an item under the 'DBA Views'. Regards, Jonas Edited formatting: Jonas Sundman on 2015-jan-22 10:39
[This reply is migrated from our old forums.]

Re: Show all Db in postgresql
Scott, I will add your vote for this enhancement. As said in a previous post, this is something we will look into soon. Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: Show all Db in postgresql
I'm wondering when this feature is planned. Being part of the postgres community, I can describe how pgAdmin does this, Essentially, pgAdmin connects to whatever database is listed in the connect string, then, it runs something similar to: select datname from pg_database; Then, it lists all of the databases in the drop-down tree. If you click one to connect, it'll actually make a new connection to the dbserver, just to that database. This is a highly-highly critical feature for me. I manage a LOT of postgres instances, all with multiple databases. This is a really, necessary feature for any tool that wants to be go-to for Postgres admins.
[This reply is migrated from our old forums. The original author name has been removed]

Re: Show all Db in postgresql
Please do add it as soon as possible. Cheers, Avelino