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

(126)

AWS Schema Conversion Tool

4.3/5

(53)

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.

Jessica M.

Small-Business (50 or fewer emp.)

10/5/2020

"My company database successfully created as PgAdmin"

5/5

What do you like best about pgAdmin?

And robust software, it has several features and functions for all types of databases. I use vectors, data manipulation, scripts, tables and more without having to use lines of code, directly connected to postgreSQL. PgAdmin provides a graphical interface that is easy to create a database. Review collected by and hosted on G2.com.

What do you dislike about pgAdmin?

Creates incompatibility with outdated versions, needs the need to keep the most current version. It generated a little complexity in the installation, guaranteed support (free software) and because it is very robust it becomes a little heavy. Review collected by and hosted on G2.com.

Recommendations to others considering pgAdmin:

I recommend pgAdmin where I found an easy software to create my database, with an easy and practical interface to execute my songs from my bank and with many functions that facilitate the interaction with postgreSQL and I already from the ready code line. Review collected by and hosted on G2.com.

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

With pgAdmin Create a database without having to make a line of code, with that it facilitated the difficulty of programming and many lines of code sequences, with its interface and connections with postgreSQL it was easy to create my database with several options of iterations and functions for my database. Review collected by and hosted on G2.com.

Ranjith S.

Small-Business (50 or fewer emp.)

8/29/2020

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

"A good database tool for PostgreSQL."

4.5/5

What do you like best about pgAdmin?

1) Ease of use

2) Export to csv is very useful, I use it very often.

3) It has a very good gui

4) The schema and tables of database can be easily viewed from the tool

5) Its open source and free

6) Has good documentation and large community support

7) All administrative tools are available in the web gui

8) Allows import/export between multiple databases

9) Ease of installation

10) Creation of table, constraints directly from the gui Review collected by and hosted on G2.com.

What do you dislike about pgAdmin?

1) Cannot connect to amazon RDS due to a login compatibility issue

2) Crashes and at times uses too much of RAM

3) Not sure why they upgraded from pgAdmin 2 to pgAdmin 4 which is unstable and has a new layout. We all are habituated to version 2 of pgAdmin

4) Network has to be stable to work, it will not reconnect if you have any network issues.

5) To top it, if you looks your net, you will have to restart the complete application. Review collected by and hosted on G2.com.

Recommendations to others considering pgAdmin:

If you are looking to manage postgres its the best tool Review collected by and hosted on G2.com.

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

We are using pgAdmin to connect to the postgres database on the server. Its the best out there for postgres, and I am able to analyze the schema and structure of the database with ease. Since it allows multiple connection, its easier to view all at one shot and compare if required. It serves the purpose of both DBA and developer. The main problem I have with pgAdmin is its stability while using unstable internet connection, otherwise hands-down its the best gui tool for postgres. Review collected by and hosted on G2.com.

Verified User in Computer Software

Small-Business (50 or fewer emp.)

10/4/2019

"GUI provided allows to connect, disconnect, get query tool with ease of use."

5/5

What do you like best about pgAdmin?

The tools allow me to connect to a Postgres database with a good GUI, wherein I can see all database schema and can go down to different objects.

One of the good features is to download the data result of a query in a CSV file, which I use quite frequently. Review collected by and hosted on G2.com.

What do you dislike about pgAdmin?

1. The search of an object from a list of objects, it is not allowed right now. If the search has to be made in these cases, we need to scroll the complete list which is not user-friendly approach at all.

2. The tabs at the top of the query area are not detachable which occupies a lot of space.

3. Backup and Restore of databases are not user-friendly, better to use cmd prompt for the same. Review collected by and hosted on G2.com.

Recommendations to others considering pgAdmin:

Recommended. Easy to use and meets the requirement but there are few improvements areas which can be taken care easily. Review collected by and hosted on G2.com.

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

PGAdmin is a tool used in the organization for connecting the local database.

The best part of the PGAdmin is, it allows us to connect the remote server database schemas. Review collected by and hosted on G2.com.

Verified User in Banking

Mid-Market (51-1000 emp.)

1/30/2021

"Data Analyst Manager using pgAdmin"

4.5/5

What do you like best about pgAdmin?

I like how intuitive and easy to connect to tour DWH is, allowing to query your data by dragging the table’s name into the query’s tool. Review collected by and hosted on G2.com.

What do you dislike about pgAdmin?

Sometimes, it take too long to query and it doesn’t show auto predicted column names. Review collected by and hosted on G2.com.

Verified User in Banking

Mid-Market (51-1000 emp.)

1/27/2021

"Great User Experience"

4.5/5

What do you like best about pgAdmin?

The interface is quite user friendly and that is no charge Review collected by and hosted on G2.com.

What do you dislike about pgAdmin?

sometime slow and sometime it needs more time to login Review collected by and hosted on G2.com.

Verified User in Government Administration

Enterprise (> 1000 emp.)

1/29/2021

"Pg Admin review"

4.5/5

What do you like best about pgAdmin?

See new geometries with the map viewer, options to commit or rollback Review collected by and hosted on G2.com.

What do you dislike about pgAdmin?

Need of more auto populate SQL queries for example. The docking system still not working great. Perhaps implementation of the shapefile loader with pg Admin would be really great too Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Small-Business (50 or fewer emp.)

6/30/2020

"Great DB Tool"

4/5

What do you like best about pgAdmin?

pgAdmin is one of the simplest db tools to use. The interface is nice and clean, it's easy to find how to add connections, query tables, and view statistics on a customizable dashboard. You can also create custom dashboard statistics which is great! Review collected by and hosted on G2.com.

What do you dislike about pgAdmin?

It took some time to get setup running in our DC/OS cluster. Also, as far as I've found (I'm sure there's one if I read the user guide), there isn't an obvious keyboard shortcut (like ctrl/cmd + enter) to just run whatever query you're trying to test out - you have to click the run button. Review collected by and hosted on G2.com.

Verified User in Education Management

Small-Business (50 or fewer emp.)

1/28/2021

"Simple to use."

4/5

What do you like best about pgAdmin?

Simple to use. Easy to download and integrate with other apps like Matlab. Review collected by and hosted on G2.com.

What do you dislike about pgAdmin?

Only supports PostgreSQL. Look into support other items like MySQL Review collected by and hosted on G2.com.

Verified User in Government Administration

Enterprise (> 1000 emp.)

9/18/2020

"Simple yet highly effective"

5/5

What do you like best about pgAdmin?

It does everything that oracle and sql server can do just without the stupidly priced license fee.

I use it on a AWS cloud DB and since starting to use it 6month ago I’m now looking to move away other DBs from oracle/sql server. Review collected by and hosted on G2.com.

What do you dislike about pgAdmin?

Nothing really.

At first it can seem complex as there is many settings. However in their default position they work well and without issue Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Enterprise (> 1000 emp.)

9/18/2020

"Great tool to access your database quickly and increase productivity"

4.5/5

What do you like best about pgAdmin?

It provides multiple options to connect to your database server. It provides very good user interface to see all the related information. It also provides query suggestions which is a very good feature Review collected by and hosted on G2.com.

What do you dislike about pgAdmin?

UI is little laggy the team should work on the UI improvements Review collected by and hosted on G2.com.