pgAdmin Reviews & Product Details

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.

Seller

pgAdmin

Discussions

pgAdmin Community

Value at a Glance

Averages based on real user reviews.

Time to Implement

3 months

Perceived Cost

$$$$$

View More Pricing Information

Top-Rated Alternatives

AWS Cloud Development Kit (AWS CDK)

4.4/5

(122)

AWS Schema Conversion Tool

4.3/5

(51)

IBM Cloud Bare Metal Servers

4/5

(28)

View All Alternatives

pgAdmin Integrations

(1)

Integration information sourced from real user reviews.

G2 reviews are authentic and verified.

Here's how.

Nikhil K.

I am a Sr. Software Engineer, 5 years of experience in development, use "whereby app" formely known as "Appear" very frequently for solving some of the issues by sharing with peers screen online.

Small-Business (50 or fewer emp.)

10/1/2019

"PGAdmin makes easy to use it - postgres interface for querying "

3.5/5

What do you like best about pgAdmin?

Different options to get insert/Create/Update scripts of the table as well as taking backup of the table from the PGAdmin interface or directly exporting query result into csv file, which saves a lot of time and save query into file using save button. Review collected by and hosted on G2.com.

What do you dislike about pgAdmin?

Tab Switching of the opened query tool , not allowed for windows users by using "Alt+ Tab" generally .

So its difficult to switch between tabs therefore we need to use the mouse cursor , it takes time while coding. Review collected by and hosted on G2.com.

Verified User in Computer Software

Small-Business (50 or fewer emp.)

7/24/2020

"Simple, but poor in advanced options"

2.5/5

What do you like best about pgAdmin?

Writing and executing queries, good for beginners in PostgreSQL Review collected by and hosted on G2.com.

What do you dislike about pgAdmin?

Sometimes it crashes, poor with advanced options Review collected by and hosted on G2.com.

Carmen H.

Secretarial Assistant

Mid-Market (51-1000 emp.)

7/30/2019

"Pgadmin Postgresql handling"

4/5

What do you like best about pgAdmin?

I love Pgadmin since it is an administrative tool for PostgreSQL, which allows you to complete all your administration tasks with ease such as: Easy to perform maintenance tasks of a Database where you can create and manage data tables, make copies security and restore, import and export data from one database to another, creating users, roles and privileges. The ease of installation is also ideal, it has a very intuitive interface and helps you get quick access to your external databases, something that would be tedious to do it through the Postgresql console. Finally, it offers great facility to audit the services of the Database, monitor the connected users. Review collected by and hosted on G2.com.

What do you dislike about pgAdmin?

There are several details that cause me uneasiness from the security point, for example a user with a Query Role, can visualize the entire structure of the Database, indexes that make it up, and which are the users assigned to each Database , which is dangerous if any user tries to illegally access the Database with another type of Role. Another of the uncomfortable details is when a Database with a lower version is backed up under the .Backup format, and when being restored in a higher version it generates a problem preventing its restoration. Also the error messages are not very clear or descriptive for the non-administrator user, which tends to generate confusion Review collected by and hosted on G2.com.

Recommendations to others considering pgAdmin:

I would recommend it to those organizations or companies that are administering one or several Databases through the Command Environment, since with the Pgadmin Graphical administrator it increases the productivity of its workers, reducing the time dedicated to a Database with respect to the Environment. of Console. I would also recommend it for those companies or people that start with a Database administrator in the Postgress language since it is a very friendly and easy-to-install tool for Windows and Linux systems, which is part of the Postgrsql DBA Day, for administration of an infrastructure database Review collected by and hosted on G2.com.

What problems is pgAdmin solving and how is that benefiting you?

The main benefit from my point of view is that I currently manage and administer several databases which are physically located in different Database servers. With Pgadmin I can centralize all the Databases in a single graphic environment, where I can visualize it in the same set without having to change the console and make connections through command to other servers. With respect to the knowledge of Pgadmin, it presents a learning curve which is short and facilitates the training of analysts who need to enter the process of administering a database. In addition, this institute has a geographic information system and pgadmin facilitates the work of developers, since they have special plug-ins for this type of tasks Review collected by and hosted on G2.com.

Priyabrata N.

Senior Cloud Architect

Enterprise (> 1000 emp.)

11/7/2019

"PG Admin review"

4/5

What do you like best about pgAdmin?

Its very easy to use and user friendly. Making connection is super easy. Review collected by and hosted on G2.com.

What do you dislike about pgAdmin?

We cannot run multiple select statements at once. If we do very hard to diferentiate. Comparing the data between two tables or matching data is very difficult. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Mid-Market (51-1000 emp.)

1/9/2020

"Great tool but not the best"

3/5

What do you like best about pgAdmin?

I have been using pgAdmin for quite a long time, What I really like about this tool is, it is easy to use. Simple UI. Review collected by and hosted on G2.com.

What do you dislike about pgAdmin?

The tool is very heavy, needs a little improvement. Review collected by and hosted on G2.com.

Umair A.

Solution Architect

Enterprise (> 1000 emp.)

11/11/2019

"Amazing tool for postgres database access"

5/5

What do you like best about pgAdmin?

I like its simplicity to install on windows and access the database including local or remote.Further its citext feature is nice and prevent user to handle string in code. Review collected by and hosted on G2.com.

What do you dislike about pgAdmin?

Its new user interface from pgadmin 4 is disturbed a bit. It hangs alot. Review collected by and hosted on G2.com.

SUBHA P.

Technical Lead

Enterprise (> 1000 emp.)

5/10/2019

"extremely simple tool for plSQL developers"

4.5/5

What do you like best about pgAdmin?

Pgadmin is a user interface for Postgresql servers where developers can execute queries

It also has provision to create database,schema,tables,index,sequences etc

It also gives option to take backup at database level,schema and table level with different compression options and restoring is pretty much simple

Maintenance like vacuum,analyze could be done from this pgAdmin

It always give hints on dead rows whenever maintenance needs to be done

Review collected by and hosted on G2.com.

What do you dislike about pgAdmin?

even when roles are restricted they will be able to view schemas and table structures ,only data will be invisible,but structure is always visible Review collected by and hosted on G2.com.

Harrish A.

Harrish

Enterprise (> 1000 emp.)

7/6/2019

Business partner of the seller or seller's competitor, not included in G2 scores.

"Database management tool"

4/5

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. Review collected by and hosted on G2.com.

What do you dislike about pgAdmin?

Exporting the data at the time of backup takes more time. Review collected by and hosted on G2.com.

Mengtian J.

Research Assistant

Enterprise (> 1000 emp.)

9/25/2019

"Easy to manage database"

3.5/5

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. Review collected by and hosted on G2.com.

What do you dislike about pgAdmin?

I personally feel like it does not work well for Mac Review collected by and hosted on G2.com.

George G.

GIS & Database Developer

Small-Business (50 or fewer emp.)

8/2/2018

"The best we' ve got!"

5/5

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. Review collected by and hosted on G2.com.

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" Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.