pgAdmin

(15)
3.9 out of 5 stars

pgAdmin ia database management tool for PostgreSQL that has the look and feel of a desktop application whatever the runtime environment is.

Work for pgAdmin?

Learning about pgAdmin?

We can help you find the solution that fits you best.

Compare pgAdmin to Similar Solutions

pgAdmin Reviews

Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • Industry
Ratings
Company Size
User Role
Industry
Showing 15 pgAdmin reviews
LinkedIn Connections
pgAdmin review by George G.
George G.
Validated Reviewer
Verified Current User
Review Source

"The best we' ve got!"

What do you like best?

It's free, it is well supported (especially for an open source project), and it has a nice clean GUI.

What do you dislike?

It is flimsy. It often crashes on start up and sometimes crashes on queries and backups via the GUI sometimes fail and it's SQL query panel is quite "clunky"

Recommendations to others considering the product

pgAdmin 4 is a great improvement (over pgAdmin 3) on every front and new versions keep rolling out in a fast pace. If you intend to administrate or develop complex PostgreSQL databases you will have to use pgAdmin - and that's a good thing. It will help you immensely. It is intuitive and quite well documented. You must though refrain using the GUI for everything and if you are used to doing everything on your database via the GUI you will soon get frustrated.

What business problems are you solving with the product? What benefits have you realized?

Using pgAdmin I am able to administrate PostgreSQL with speed and ease. Using the dashboard in pgAdmin 4 (server status in pgAdmin 3) I can easily monitor and manage my database as the sessions, the locks, the transactions are all reported with clarity in real-time. The grant-wizard makes administrating an easy task. The comprehensive and intuitive GUI greatly speeds up development.

Sign in to G2 Crowd to see what your connections have to say about pgAdmin
pgAdmin review by ALEXANDER J.
ALEXANDER J.
Validated Reviewer
Verified Current User
Review Source

"Excellent tool for the administration of postgresql"

What do you like best?

Access to postgresql database servers, visualization of all objects in a database, panel to execute SQL statements, backup and restoration of any database object, data visualization, import and export of data from a database database of databases, to other formats, creation of users, roles and privileges to the objects, allows the monitoring of the connected users, as well as the queries that are executed, the locks, providing an online log of all the database activities

What do you dislike?

I would like to include a monitoring of the spaces of the databases and that the sending of alerts to the DBAs can be configured in order to reduce the risks of lowering the service to the clients, however the tool has worked perfectly for us during several years, there is always a renewal of the version by the administration community of pgAdmin with improvements and new facilities, there is the version for installation on machines with debian operating systems,

Recommendations to others considering the product

PgAdmin is a very friendly and easy to install tool for Windows and Linux systems, which is part of the Postgrsql DBA day, for the administration of an infrastructure database.

What business problems are you solving with the product? What benefits have you realized?

We resolved the administration of all postgresql servers with a single tool, since we were able to configure 60 services and manage them from PgAdmin, the installation was made on Windows platforms and also on the Debian platform, and we strongly recommend it for the administration of postgresql, tool of Easy installation and configuration

What Other IT Infrastructure solution do you use?

Thanks for letting us know!
pgAdmin review by Natalia K.
Natalia K.
Validated Reviewer
Verified Current User
Review Source

"User friendly management tool for PostgreSQL"

What do you like best?

PgAdmin is a powerful tool to manage Postgres databases. It is easy to install, it has a very intuitive interface and helps you to get a quick access to your external databases. PgAdmin works equally good on both mac and Linux and has a very extensive functionality. It lets you to do nearly everything you need, such as restore/backup, managing schemas, databases, tables, sequences, functions, users and so on.

What do you dislike?

It crashed a few times when I was working with an external database over ssh and had a slow internet connection.

Recommendations to others considering the product

PgAdmin is a convenient tool to use if you don't feel too comfortable with command line or if you prefer to work with a GUI, as it has pretty much anything you need.

What business problems are you solving with the product? What benefits have you realized?

I mainly use it when i need to check quickly the data in the external database or to do some minor updates. However restores or backups I still prefer to do via command line.

pgAdmin review by Ratna Kumar B.
Ratna Kumar B.
Validated Reviewer
Verified Current User
Review Source

"Postgres DB Adminstartion "

What do you like best?

The best management tool for Postgres DB . The use of the SQL queries , the SQL builder is good. This application allows you to the connect to multiple DB servers. This allows you to the use and interact the databases easily.

What do you dislike?

UI can be more better the the existing version, the class mapping is required.And class Object Oriented and Analysis Design / UML tools is required in this software.

Recommendations to others considering the product

This is the best tool available in the market, if you are considering the database that related to Postgres Database.

What business problems are you solving with the product? What benefits have you realized?

My whole database is manage thru this software, managing the Database is really appreciable. Writing queries, managing sequences and writing procedures, triggers to the tables, when a table gets updated and this will automatically updates the destination database and the specific table.

pgAdmin review by Administrator
Administrator
Validated Reviewer
Verified Current User
Review Source

"excellent system to manage database"

What do you like best?

It is a good system, very stable and reliable for the management and development of relational database oriented to objects and free of open source.

The good thing about postgreSQL is that it is developed by a community that works in a disillusioned way and does not depend on a company or person.

PostgreSQL has several features that make it stand out from other database handlers such as: High concurrency, you can create triggers, Wide variety of native types, you can develop views very broadly.

What do you dislike?

in its new version it is very difficult and complicated to manage, they changed several things and I do not think it has improved, I prefer to continue using pgAdmin III to compare its new versions.

Comparing other database managers is more complicated to develop tables

What business problems are you solving with the product? What benefits have you realized?

I have managed it for several projects developed in java and web that depend on the database and pgAdmin is a good database manager very stable and reliable

pgAdmin review by John C.
John C.
Validated Reviewer
Verified Current User
Review Source

"Funcion como esperaba"

What do you like best?

La estructura de las tablas y su contenido, es facil ver de un vistazo sin entrar en las tablas, sus columnas y sus Constraints

What do you dislike?

La velocidad de las conexiones a los servidores, tanto esto como el hecho de ejecutar los scripts, sobre todo los que son algo grandes, se hace una tarea muy pesada desde dentro de la aplicación

Recommendations to others considering the product

Si no lo has utilizado te recomiendo que empieces por el 3, ahora mismo su versión actual es la 4, y si es verdad que es mas rápida que la 3, pero un poco mas compleja

What business problems are you solving with the product? What benefits have you realized?

Configuraciones para varias empresas con las que trabajamos.

pgAdmin review by Carolina C.
Carolina C.
Validated Reviewer
Review Source

"Free tool for administration of PostgreSQL database design and management system"

What do you like best?

- Multiplatform

- Extensive documentation

- Multiple deployment models: Desktop mode, using a purpose built runtime and server mode, supporting multiple users over the web

- Tools: Powerful query tool with colour syntax highlighting, fast datagrid for display/entry of data, graphical query plan display, grant Wizard for rapid updates to ACLs and supporting pl/pgsql and edb-spl

- Routine maintenance: Auto-vacuum management, monitoring dashboard, backup, restore, vacuum and analyze on demand and SQL/shell/batch job scheduling agent

- Create, view and edit all common PostgreSQL objects: Objects are displayed with their SQL definition, and a user friendly list of properties. Dependent, and dependency objects may also be browsed, and object statistics viewed where appropriate.

What do you dislike?

- The windows animations slow thing's down to much.

- It's a single window application and it doesn't allow me to drag windows

around on my desktop, hide the windows I don't need etc.

- Some screens appear slow to me with a 'loading' icon, even without the windows it takes took long to 'draw' the screen. Where in pgAdmin 3 a lot of items are near instance, in pgAdmin4 it takes time to display.

- Clicking on a table in the tree doesnt do anything in pgAdmin4, in pgAdmin3 it shows me the table definition.

Recommendations to others considering the product

PgAdmin is a good tool to use if you don't have experience with command line or if you prefer to work with a graphical user interface. You can made almost all that you need.

What business problems are you solving with the product? What benefits have you realized?

In my company we can made easy and fast query for any requirement that any instance of the company made. It is designed for viewing, browsing, querying and developing complex PostgreSQL databases.

Also we can store information of vital importance for the company with the security of a robust backup and recovery system that allows us to safeguard our information

pgAdmin review by Federico R.
Federico R.
Validated Reviewer
Verified Current User
Review Source

"Great tool - not so great UI"

What do you like best?

pgAdmin is a tool to quickly glance at your postgres databases. It has advanced capabilities but the bad UI hinders its effectiveness.

What do you dislike?

The UI is not very well integrated and looks out of place.

Error messages are not always clear

The UI makes common actions - like inserting new data - painful.

There is no highlighting or autocompletion when writing raw queries.

Recommendations to others considering the product

pgAdmin is good for basic work and if you're happy to do most of the job with raw queries - but if you're spending a lot of time managing your databases I would look around for alternatives.

What business problems are you solving with the product? What benefits have you realized?

Manage my databases. It saves a few queries, it's mainly useful to quickly glance at data and filter.

It's easy to execute raw queries, so that you can quickly overcome.

pgAdmin review by User
User
Validated Reviewer
Verified Current User
Review Source

"Effective open source stopgap solution"

What do you like best?

Completely open source and free to use, even in an enterprise setting

What do you dislike?

The interface is bulky, the arbitrary SQL composing windows are far too large for the purpose, and there is a complete lack of suggestion or autocomplete functionality

Recommendations to others considering the product

If it absolutely has to be free and absolutely has to work the first time, this is the best way to go. But! There are better and more feature rich applications out there that are free as well.

What business problems are you solving with the product? What benefits have you realized?

The benefits are strong compatibility with ODBC drivers, which has helped migrate a large amount of data from MS Access. This has a ton of performance benefits, and helps us dictate index creation, keeping size down.

pgAdmin review by Nikhil N.
Nikhil N.
Validated Reviewer
Review Source

"Nice DB Management Tool"

What do you like best?

PgAdmin is an effective instrument to oversee Postgres databases. It is anything but difficult to introduce, it has an extremely instinctive interface and encourages you to get a fast access to your outside databases. PgAdmin works similarly great on both macintosh and Linux and has an extremely broad usefulness. It lets you to do almost all that you require, for example, reestablish/reinforcement, overseeing outlines, databases, tables, groupings, capacities, clients et cetera.

What do you dislike?

The UI isn't incorporated and watches strange.

Blunder messages are not generally clear

The UI makes regular activities - like embeddings new information - difficult.

There is no featuring or autocompletion when composing crude questions.

What business problems are you solving with the product? What benefits have you realized?

Software development for electronic assembly machine

pgAdmin review by Pahul A.
Pahul A.
Validated Reviewer
Review Source

"Superbb Client for Postgresql Server"

What do you like best?

PG admin is an awsome client for Postgresql DBMS. You can group server and databases as per your requirements. You can open any number of sql query windows to improve your speed. Also sorting and filtering functions work very well.

What do you dislike?

The only issue i found in Pgadmin is that, when your internet connection is not stable or you are once disconnected from server, all open query windows will be closed, which might result in loss of useful queries.

What business problems are you solving with the product? What benefits have you realized?

Our Primary business software uses postgresql as its backend, and we use Pgadmin to connect with DB server.

pgAdmin review by Rafael R.
Rafael R.
Validated Reviewer
Verified Current User
Review Source

"Nice DB Management Tool"

What do you like best?

The simplicity and access of its interface

What do you dislike?

Minor bugs. Some functions are not relly explained very well, like which are the hotkeys to execute queries, do rollback, etc, sometimes they dont even work.

Recommendations to others considering the product

Use latest version and without remotelly access, it is a pain sometimes when the connection is slow.

What business problems are you solving with the product? What benefits have you realized?

Database administration, it is quick and easy to access

pgAdmin review by Administrator
Administrator
Validated Reviewer
Verified Current User
Review Source

"Good for postgresql management"

What do you like best?

is very intuitive when it comes to managing the database and programming about it

What do you dislike?

When the connection to the database is lost, it sometimes gets blocked

What business problems are you solving with the product? What benefits have you realized?

the benefit is the ease of handling postgresql

pgAdmin review by User
User
Validated Reviewer
Review Source

"Great tool for PostgreSQL "

What do you like best?

Secure and easy to use User interface and aswell from c# code

What do you dislike?

When a cell in row consists of a long xml, it is shown as blank, viewing options is to choose between all, Top 100, Last 100 rows, more options or a way to choose would be easier. deleting multiple rows from UI is hard

What business problems are you solving with the product? What benefits have you realized?

Software development for electronic assembly machine

pgAdmin review by User in Information Technology and Services
User in Information Technology and Services
Validated Reviewer
Review Source

"Crashes all the time, much better tools out there for PostgreSql"

What do you like best?

I like the saving of queries and the ability to have multiple windows open to run concurrent queries

What do you dislike?

Crash after Crash after CRash , loose queries that took hours to construct

Recommendations to others considering the product

Consider the reliability

What business problems are you solving with the product? What benefits have you realized?

Database for the entire system

Kate from G2 Crowd

Learning about pgAdmin?

I can help.
* We monitor all pgAdmin reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. Validated reviews require the user to submit a screenshot of the product containing their user ID, in order to verify a user is an actual user of the product.

Compare pgAdmin to Similar Solutions