Are there any good and free tools for managing a PostgreSQL database?

Question

Before, I have used phpmyadmin to manage an MySQL database, but now I would like to manage a PostgreSQL database. The PostgreSQL database is on a server, but not a webserver, so I don't use PHP.

Are there any good and free tools for managing a PostgreSQL database?

I have tried with pgAdmin III but it was a far from intuitive application to use, compared to phpmyadmin that I have used before. What are PostgreSQL DBAs usually using? do they use graphical tools like pgAdmin III or is it mostly command line tools?

Answer 1

There is Navicat for PostgreSQL and other database platforms.

It has a free lite and a commercial version.

Answer 2

Well, there is phpPgAdmin, if that suits you.

Answer 3

pgAdmin and psql, those are the tools I use. A PHP-script isn't very usefull for database management, too slow and many problems with transactions: What to do when something goes wrong? Commit or rollback? This makes tools like phpmyadmin and phpPgAdmin pretty useless, when the script is done, the database connection will be closed. There is nothing to commit or rollback, your SQL script is already gone.

Learn SQL and any tool that can keep it's databases connections open, will do the job.

Answer 4

I like dbVisualizer, it has a free version that unfortunately is missing some features, you'll have to see if it has enough for you.

also check out stackoverflow for more choices:

• http://stackoverflow.com/questions/105788/good-postgresql-client-for-windows

• http://stackoverflow.com/questions/2532620/good-front-end-for-postgresql-on-windows-or-mac

Answer 5

Coming from Microsoft SQL Server, I really like http://www.sqlmanager.net/products/postgresql/manager/ for managing PostgreSQL.

The free version has most everything you would need to get started.