Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

stackoverflow points me "belongs-on-serverfault" on this, so crossposting.

I am frustrated of not having a good Linux GUI administration and development tool for PostgreSQL.

pgAdmin III is buggy and unusable piece of... hmm, software, compared to Windows-only PostgreSQL Maestro and EMS PostgreSQL manager.

phpPgaAmin does not looks promising.

EMS PostgreSQL manager can work under Wine, but such setup have a number of issues.

Requirements are:

  1. Table data editing and browsing for large tables (1M+), able to jump by FK or some master-slave editing, GUI filtering and so on.
  2. ER diagrams with in-place schema editing
  3. Schema editing and browsing with all useful GUI support
  4. Schema changes log to put into DB versioning (migrations script).
  5. Tabbed interface to be able to work with a number of tables and SQL queries at once.

And so on.

Any ideas?

share

locked by HopelessN00b Dec 5 at 11:12

This question exists because it has historical significance, but it is not considered a good, on-topic question for this site, so please do not use it as evidence that you can ask similar questions here. This question and its answers are frozen and cannot be changed. More info: help center.

closed as not constructive by Bryan, voretaq7 Apr 11 '13 at 19:52

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance.If this question can be reworded to fit the rules in the help center, please edit the question.

    
Out of curiosity what have you found to be buggy in pgAdmin? It doesn't hit your wish list 100% but it is fairly solid in my experience. –  Gavin M. Roy May 22 '09 at 16:25
    
Today it crashes, well, suddenly closes with that cool fly out compiz effect, when I try to delete row, probably referenced by FK. Well, I assume there are no plenty of bugs. –  user3370 May 22 '09 at 18:09
    
What version of pgAdmin are you running? I've used it under Windows and Linux (even under compiz!) and haven't had problems. Just curious. –  Avery Payne May 22 '09 at 19:13
    
1.8.4 ========= –  user3370 May 23 '09 at 1:52
    
I've used several versions of PgAdmin on windows and OS X, and I've seen crashes in both. They're fairly infrequent, (I've seen maybe a dozen in roughly two years) but they do happen. –  Frank Farmer Jun 4 '09 at 22:11

8 Answers 8

Try DBvisualizer from Minq Software ... http://www.minq.se/products/dbvis/

It's universal. It is Java based, and uses JDBC drivers to access just about any DB platform. It's a very mature product, and has commercial and freebie. I liked it so much, I splurged for the licensed copy!

share

I use Navicat. They have a lite version that you can download for free that supports not only postgres, but MySQL as well. You can do things like copy tables from one database to another which is not supported under pgadmin3. Plus, it's more visually appealing, which is nice.

share

TOra might be worth looking at. It's technically "Toolkit for Oracle", however it can also handle MySQL and PostgreSQL.

share
    
I've already read "Community Guide to PostgreSQL GUI Tools" –  user3370 May 23 '09 at 1:53

Squirrel-SQL is a Java based SQL client. Anything with JDBC is supported. The 3.x branch introduced a Tabbed UI.

share

Mergeant is a project to build an open source database app based on GNOME technology.

share

In the past I've used pgAccess, which wasn't flashy but it did the job. It looks like the last release was five years ago, so it might not be the right answer.

share

Recommendations

(1) VMware Workstation, Windows, and EMS' toolkits I really like EMS tools for Postgresql, and would virtualize in order to get access.

(2) Look at this list of Postgres GUI tools here

(3) A cross platform tool I used previously and liked was Aqua Data Studio

share

I use for linux free tool Valentina Studio http://www.valentina-db.com/en/valentina-studio-overview It works on three OS: MAC, WIN, LIN. It works as with mySQL/mariaDB, so with PostgreSQL, SQLite and Valentina DB.

share
    
A little summary of what it does? The link might break at any time... –  vonbrand Apr 11 '13 at 19:45