--- title: pgAdmin Reviews meta_title: 'pgAdmin Reviews 2026: Details, Pricing, & Features | G2' meta_description: Filter 73 reviews by the users' company size, role or industry to find out how pgAdmin works for a business like yours. aggregate_rating: rating_value: 4.1 review_count: 73 scale: '5' date_modified: '2026-07-12' parent_category: name: IT Infrastructure url: https://www.g2.com/categories/it-infrastructure --- # pgAdmin Reviews **Vendor:** pgAdmin **Category:** [Other IT Infrastructure Software](https://www.g2.com/categories/other-it-infrastructure) **Average Rating:** 4.1/5.0 **Total Reviews:** 73 ## About pgAdmin pgAdmin is a comprehensive, open-source administration and development platform for PostgreSQL, the world's most advanced open-source database. Designed to meet the needs of both database administrators and developers, pgAdmin offers an intuitive graphical interface that simplifies the management, querying, and analysis of PostgreSQL databases. Its cross-platform compatibility ensures seamless operation on Windows, macOS, and Linux systems, making it a versatile tool for diverse development environments. Key Features and Functionality: - Cross-Platform Support: Operates on Windows, macOS, and Linux, providing flexibility across different operating systems. - Comprehensive Database Management: Enables users to create, manage, and query all PostgreSQL objects through an intuitive graphical interface. - Powerful Query Tool: Features syntax highlighting, auto-complete, and graphical EXPLAIN options to optimize query performance. - Multiple Deployment Models: Offers both desktop mode with a dedicated runtime and server mode, supporting multiple users over the web. - Advanced Tools: Includes a schema diff tool for managing differences between schemas, an ERD tool for designing and documenting schemas, and a procedural language debugger supporting pl/pgsql and edb-spl. - Routine Maintenance Utilities: Provides auto-vacuum management, a monitoring dashboard, and on-demand backup, restore, vacuum, and analyze functions. - Extensive Documentation: Offers comprehensive documentation for both the pgAdmin application and PostgreSQL, facilitating ease of use and learning. Primary Value and User Solutions: pgAdmin addresses the complexities associated with PostgreSQL database management by offering a user-friendly, feature-rich interface that streamlines administrative tasks and development processes. Its cross-platform support and multiple deployment options cater to a wide range of user preferences and operational requirements. By integrating advanced tools for query optimization, schema management, and routine maintenance, pgAdmin enhances productivity and ensures efficient database performance. This makes it an invaluable resource for database administrators and developers seeking a robust and reliable PostgreSQL management solution. ## pgAdmin Reviews ### 1. Database management tool **Rating:** 4.0/5.0 stars **Reviewed by:** Harrish A. | Harrish, Enterprise (> 1000 emp.) **Reviewed Date:** July 06, 2019 **What do you like best about pgAdmin?** It is very useful to store the data into database and its is very user friendly to import the data into the database. This pgadmin tool is also very easy to execute the scripts and it is easy to create table views, triggers etc. **What do you dislike about pgAdmin?** Exporting the data at the time of backup takes more time. **What problems is pgAdmin solving and how is that benefiting you?** We will store the data, access it easily. Easy query execution tool and also it is a opensource tool and it has the most advanced database management features. ### 2. Easy to manage database **Rating:** 3.5/5.0 stars **Reviewed by:** Mengtian J. | Research Assistant, Enterprise (> 1000 emp.) **Reviewed Date:** September 25, 2019 **What do you like best about pgAdmin?** Good and easy-to-use interface. People with a few technical knowledge all can handle the platform easily. **What do you dislike about pgAdmin?** I personally feel like it does not work well for Mac **What problems is pgAdmin solving and how is that benefiting you?** Manage database - retrieve data, clean data, query data ect. ### 3. The best we' ve got! **Rating:** 5.0/5.0 stars **Reviewed by:** George G. | GIS & Database Developer, Small-Business (50 or fewer emp.) **Reviewed Date:** August 02, 2018 **What do you like best about pgAdmin?** It's free, it is well supported (especially for an open source project), and it has a nice clean GUI. **What do you dislike about pgAdmin?** 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 pgAdmin:** 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 problems is pgAdmin solving and how is that benefiting you?** 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. ### 4. Greate Client Tool for PostgreSQL **Rating:** 5.0/5.0 stars **Reviewed by:** Gulshandeep S. | Mid-Market (51-1000 emp.) **Reviewed Date:** October 23, 2018 **What do you like best about pgAdmin?** pgAdmin is the official client tool for PostgreSQL. It lets you create and manage your databases. It lets you store multiple database connections. You can run SQL, Create database, create tables, insert data, create indexes all using simple steps. Its multi window environment lets you multi-task effectively. Great tool. **What do you dislike about pgAdmin?** If you have a poor internet connection, your database connection will eventually break, and pgAdmin will crash. **What problems is pgAdmin solving and how is that benefiting you?** We manage our databases using pgAdmin. ### 5. It worked as expected **Rating:** 4.0/5.0 stars **Reviewed by:** John Carranza R. | Programador auxiliar, Small-Business (50 or fewer emp.) **Reviewed Date:** August 13, 2018 **What do you like best about pgAdmin?** The structure of the tables and their content is easy to see at a glance without entering the tables, their columns, and their Constraints. **What do you dislike about pgAdmin?** The speed of connections to the servers, as well as the execution of scripts, especially those that are somewhat large, becomes a very burdensome task from within the application. **Recommendations to others considering pgAdmin:** If you haven't used it, I recommend you start with version 3. Right now, its current version is 4, and while it's true that it's faster than version 3, it's a bit more complex. **What problems is pgAdmin solving and how is that benefiting you?** Configurations for various companies we work with. ### 6. PostgreSQL Admin tool **Rating:** 5.0/5.0 stars **Reviewed by:** Dinesh J. | Mid-Market (51-1000 emp.) **Reviewed Date:** October 02, 2018 **What do you like best about pgAdmin?** pgAdmin is an administrative tool for PostgreSQL,It lets you complete all your administration tasks with ease. You can create tables, schema, indexes, run vacuum, all from a single panel. Its earlier version pgAdmin3 had some bugs like broken connection, but those have been effectively fixed in latest version. Thanks for that. **What do you dislike about pgAdmin?** If your internet connection breaks once, you will need to restart complete pgAdmin, as its window crashes. **What problems is pgAdmin solving and how is that benefiting you?** We admin our Pg databases using pgAdmin. ### 7. excellent system to manage database **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** June 12, 2018 **What do you like best about pgAdmin?** 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 about pgAdmin?** 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 problems is pgAdmin solving and how is that benefiting you?** 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 ### 8. Basic application for postgres administration **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** September 17, 2018 **What do you like best about pgAdmin?** Easy to use, with all the need for administrate a postgresql. With possiblities to search, update, delete and insert new data. Allows to create new database, update or create roles. and tables. It is one of the best free optiones out there to handle your requests on the database administrations. Allows to have more than one connection open to differents databases. Has a really nice integration with postgres types. **What do you dislike about pgAdmin?** Not the best interface and breaks, stop working, lots of times Some times it is difficult to navigate between windows. **Recommendations to others considering pgAdmin:** If you are looking for an easy and fast way to admin your database. This is free **What problems is pgAdmin solving and how is that benefiting you?** Administrate a postgresql database in a easy and fast way. It allows you to create a database in manner of seconds and include tables with all kind of possibles datatypes. ### 9. Fast and simple postgres **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Telecommunications | Enterprise (> 1000 emp.) **Reviewed Date:** October 31, 2018 **What do you like best about pgAdmin?** Currently I used version 4 and I like the way in which I can validate the connections of the users to the databases and the graphics that in the previous version I did not see **What do you dislike about pgAdmin?** This version I notice slower, the section in which one places the querys is as hidden **Recommendations to others considering pgAdmin:** I recommend it, especially for developers and new projects **What problems is pgAdmin solving and how is that benefiting you?** To validate the connections of the end users is excellent, since as DBA the first problem that manifests the end user is not being able to connect to the database, with Pgadmin I can validate and verify these connections and show graphically that they can indeed make a successful connection ### 10. Review of the Pgadmin software **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** December 17, 2018 **What do you like best about pgAdmin?** It is a simple software to use and to administer, with its icno of the sql it is extremely easy to realize the query of insertion, consultation, and elimination of information. **What do you dislike about pgAdmin?** Easy to use connects directly with the postgrsl and easy to mount database **Recommendations to others considering pgAdmin:** Software very easy to use to manage through its graphical environment, I recommend that you use this database manager product. **What problems is pgAdmin solving and how is that benefiting you?** With the pgadmin, you are managing the database of the company's administrative system and the ticket control system. Which is currently used ### 11. Client Software for Postgresql **Rating:** 4.5/5.0 stars **Reviewed by:** Navdeep S. | Small-Business (50 or fewer emp.) **Reviewed Date:** September 05, 2018 **What do you like best about pgAdmin?** pgAdmin allow you to manage and use PostgreSQL database. You can add server groups. access databases, take backup or restore existing backup all from a single tool. You can run all kinds of DML and SQL operations from pgAdmin. You can create table, add table constraint via UI instead of SQL. **What do you dislike about pgAdmin?** There were some issue like Crashing in PgAdmin3 but now have been removed in latest version PgAdmin4., But PgAdmin4 is browser application, i preferred the earlier desktop version. **What problems is pgAdmin solving and how is that benefiting you?** It lets you run sql queries on PostgreSQL Database, ### 12. Superbb Client for Postgresql Server **Rating:** 5.0/5.0 stars **Reviewed by:** Pahul A. | Mid-Market (51-1000 emp.) **Reviewed Date:** August 13, 2018 **What do you like best about pgAdmin?** 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 about pgAdmin?** 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 problems is pgAdmin solving and how is that benefiting you?** Our Primary business software uses postgresql as its backend, and we use Pgadmin to connect with DB server. ### 13. Excellent tool for the administration of postgresql **Rating:** 5.0/5.0 stars **Reviewed by:** ALEXANDER J. | Ingeniero III, Enterprise (> 1000 emp.) **Reviewed Date:** January 18, 2018 **What do you like best about pgAdmin?** 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 about pgAdmin?** 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 pgAdmin:** 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 problems is pgAdmin solving and how is that benefiting you?** 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 ### 14. Postgres DB Adminstartion **Rating:** 3.5/5.0 stars **Reviewed by:** Ratna Kumar B. | Project Engineer, Computer Software, Mid-Market (51-1000 emp.) **Reviewed Date:** February 09, 2018 **What do you like best about pgAdmin?** 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 about pgAdmin?** 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 pgAdmin:** This is the best tool available in the market, if you are considering the database that related to Postgres Database. **What problems is pgAdmin solving and how is that benefiting you?** 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. ### 15. Effective open source stopgap solution **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Medical Devices | Enterprise (> 1000 emp.) **Reviewed Date:** April 26, 2018 **What do you like best about pgAdmin?** Completely open source and free to use, even in an enterprise setting **What do you dislike about pgAdmin?** 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 pgAdmin:** 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 problems is pgAdmin solving and how is that benefiting you?** 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. ### 16. Free tool for administration of PostgreSQL database design and management system **Rating:** 4.0/5.0 stars **Reviewed by:** Carolina C. | Data Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** January 18, 2018 **What do you like best about pgAdmin?** - 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 about pgAdmin?** - 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 pgAdmin:** 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 problems is pgAdmin solving and how is that benefiting you?** 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 ### 17. User friendly management tool for PostgreSQL **Rating:** 4.5/5.0 stars **Reviewed by:** Natalia K. | Python developer/ PHP Developer, Small-Business (50 or fewer emp.) **Reviewed Date:** November 16, 2016 **What do you like best about pgAdmin?** 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 about pgAdmin?** 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 pgAdmin:** 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 problems is pgAdmin solving and how is that benefiting you?** 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. ### 18. Good for postgresql management **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** August 10, 2018 **What do you like best about pgAdmin?** is very intuitive when it comes to managing the database and programming about it **What do you dislike about pgAdmin?** When the connection to the database is lost, it sometimes gets blocked **What problems is pgAdmin solving and how is that benefiting you?** the benefit is the ease of handling postgresql ### 19. Nice DB Management Tool **Rating:** 4.5/5.0 stars **Reviewed by:** Nikhil N. | Applications Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** January 16, 2018 **What do you like best about pgAdmin?** 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 about pgAdmin?** 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 problems is pgAdmin solving and how is that benefiting you?** Software development for electronic assembly machine ### 20. Nice DB Management Tool **Rating:** 3.5/5.0 stars **Reviewed by:** Rafael R. | Junior Developer, Small-Business (50 or fewer emp.) **Reviewed Date:** December 07, 2017 **What do you like best about pgAdmin?** The simplicity and access of its interface **What do you dislike about pgAdmin?** 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 pgAdmin:** Use latest version and without remotelly access, it is a pain sometimes when the connection is slow. **What problems is pgAdmin solving and how is that benefiting you?** Database administration, it is quick and easy to access ### 21. Great tool for PostgreSQL **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Electrical/Electronic Manufacturing | Mid-Market (51-1000 emp.) **Reviewed Date:** October 04, 2017 **What do you like best about pgAdmin?** Secure and easy to use User interface and aswell from c# code **What do you dislike about pgAdmin?** 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 problems is pgAdmin solving and how is that benefiting you?** Software development for electronic assembly machine ### 22. Crashes all the time, much better tools out there for PostgreSql **Rating:** 1.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** October 30, 2017 **What do you like best about pgAdmin?** I like the saving of queries and the ability to have multiple windows open to run concurrent queries **What do you dislike about pgAdmin?** Crash after Crash after CRash , loose queries that took hours to construct **Recommendations to others considering pgAdmin:** Consider the reliability **What problems is pgAdmin solving and how is that benefiting you?** Database for the entire system ### 23. Great tool - not so great UI **Rating:** 3.5/5.0 stars **Reviewed by:** Federico R. | Senior Software Engineer, E-Learning, Mid-Market (51-1000 emp.) **Reviewed Date:** November 16, 2016 **What do you like best about pgAdmin?** 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 about pgAdmin?** 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 pgAdmin:** 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 problems is pgAdmin solving and how is that benefiting you?** 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 Discussions - [Sql sheet](https://www.g2.com/discussions/sql-sheet) - 1 comment, 1 upvote - [View pgAdmin pricing details and edition comparison](https://www.g2.com/products/pgadmin/reviews?page=2§ion=pricing&secure%5Bexpires_at%5D=2026-08-01+22%3A58%3A02+-0500&secure%5Bsession_id%5D=dc93507f-f95d-47a9-a76c-4f907cfff9c5&secure%5Btoken%5D=5b3aad2345cfff45dbf10c90b28cd2d6b295ea8e1210d0366ad86a8aff4a584f&format=llm_user) ## pgAdmin Integrations - [IntelliJ IDEA](https://www.g2.com/products/intellij-idea/reviews) ## Top pgAdmin Alternatives - [AWS Cloud Development Kit (AWS CDK)](https://www.g2.com/products/aws-cloud-development-kit-aws-cdk/reviews) - 4.4/5.0 (130 reviews) - [AWS Schema Conversion Tool](https://www.g2.com/products/aws-schema-conversion-tool/reviews) - 4.3/5.0 (54 reviews) - [IBM Cloud Bare Metal Servers](https://www.g2.com/products/ibm-cloud-bare-metal-servers/reviews) - 4.0/5.0 (28 reviews)