pgAdmin Reviews & Product Details


What is pgAdmin?

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

Write a Review

pgAdmin Profile Details

pgAdmin Profile Details

Vendor
pgAdmin
Company Website
HQ Location
N/A
Employees on LinkedIn®
1
Show moreShow fewer

pgAdmin Reviews

Filter Reviews
Filter Reviews
Sort by
Ratings
Company Size
User Role
All Industries
Write a Review
1-26 of 26 total pgAdmin reviews

pgAdmin Reviews

Write a Review
Filter By
Connections
Show reviews that mention
1-26 of 26 total pgAdmin reviews
Copy Review URL
CodeLite
Mid-Market
(51-200 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"Pgadmin Graphic environment for postgresql"

What do you like best?

What I like about Pgadmin is the ease and versatility of working with its centralized work environment provided with a set of tools represented by toolbars that allow to perform any activity related to the administration and query of Database. Also its portability, since it is multiplatform and can be installed in the most worked Operating Systems such as Windows and Linux. I also love your Panel to execute queries with online results to perform tests graphically without being aware of the SQL instructions

What do you dislike?

Among the things that I dislike about Pgadmin is that the new version of Pgadmin4, changed the location and structure of the tool panels and for my concept I do not think it has improved its functioning and that is why I prefer to continue working in Pgadmin3, Besides the installation of Pgadmin4 in Linux in any of its distributions is very complicated and failures of dependency, for the moment. Another thing that I do not like about their security is that users who have the role to only consult, can see the structure of tables, indexes and other elements that should not be viewed by all users.

Recommendations to others considering the product:

I would recommend Pgadmin for those companies that handle several databases simultaneously, which allows to better organize and create database queries in a faster way. It is also ideal to be used by programmers without knowledge of the progress instructions from the Postgres console.

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

The main benefit is that we were able to integrate all the Postgres databases in a single environment, no matter what server they are in, where we can manage, create records or perform different database queries in a graphical way and in an easy and efficient way, thus increasing the productivity of the DBA.

Copy Review URL
Coordinador de sistemas
Mid-Market
(201-500 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

" pgAdmin is a management tool for PostgreSQL and derived relational databases, such as the EDB Advan"

What do you like best?

es una herramienta de consulta con resaltado de sintaxis,

es muy rápida para visualización entrada de datos la cual

Asistente de subvención para actualizaciones rápidas de ACL

Depurador de lenguaje de procedimiento (que admite pl / pgsql y edb-spl)

What do you dislike?

it is slower in insertions and updates, since it has intersection headers

, but there is no compulsory aid which consumes more resources. sometimes

the sintaxtis of some of its commands or statements is not intuitive at all.

Recommendations to others considering the product:

umple in its entirety with the ACID Compliant feature. ACID is an acronym for Atomicity, Consistency, Isolation and Durability (Atomicity, Consistency, Isolation and Durability in Spanish). Therefore, it allows transactions to not interfere with each other. This guarantees the information of the Databases and that the data will last in the system.

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

that the previous versions have defects, when you are managing superior versions, that is when a database is managed from a new version to restore a previous version many times error for restoration.

which is desktop, using a runtime purpose built as a server to support multiple users.

Copy Review URL
GIS/Web GIS Developer & Database Administrator
Information Technology and Services
Small-Business
(11-50 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"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 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.

Copy Review URL
Ingeniero III
Enterprise
(1001-5000 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"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 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

Copy Review URL
Python developer/ PHP Developer
Small-Business
(2-10 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"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 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.

Copy Review URL
Project Engineer
Computer Software
Enterprise
(1001-5000 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"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 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.

Copy Review URL
A
Mid-Market
(501-1000 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"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 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

Copy Review URL
Programador auxiliar
Small-Business
(11-50 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"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 problems are you solving with the product? What benefits have you realized?

Configuraciones para varias empresas con las que trabajamos.

Copy Review URL
Technical Lead
Information Technology and Services
Small-Business
(11-50 employees)
Validated Reviewer
Review Source
Copy Review URL

"extremely simple tool for plSQL developers"

What do you like best?

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

What do you dislike?

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

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

Designing an OLTP application for Geographical Information systems and the developers found so easy to code with the help of pgadmin.

It directly connects to the Postgresql servers seamlessly

Copy Review URL
Data Analyst
Enterprise
(1001-5000 employees)
Validated Reviewer
Review Source
Copy Review URL

"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 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

Copy Review URL
Mid-Market
(501-1000 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"PostgreSQL Admin tool"

What do you like best?

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?

If your internet connection breaks once, you will need to restart complete pgAdmin, as its window crashes.

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

We admin our Pg databases using pgAdmin.

Copy Review URL
Mid-Market
(201-500 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"Greate Client Tool for PostgreSQL"

What do you like best?

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?

If you have a poor internet connection, your database connection will eventually break, and pgAdmin will crash.

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

We manage our databases using pgAdmin.

Copy Review URL
Senior Software Engineer
E-Learning
Mid-Market
(501-1000 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"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 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.

Copy Review URL
U
Enterprise
(5001-10,000 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"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 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.

Copy Review URL
Harrish
Enterprise
(5001-10,000 employees)
Validated Reviewer
Review Source
Copy Review URL
Business partner of the vendor or vendor's competitor, not included in G2 scores.

"Database management tool"

What do you like best?

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?

Exporting the data at the time of backup takes more time.

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

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.

Copy Review URL
U
Mid-Market
(51-200 employees)
Validated Reviewer
Review Source
Copy Review URL

"Basic application for postgres administration"

What do you like best?

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?

Not the best interface and breaks, stop working, lots of times Some times it is difficult to navigate between windows.

Recommendations to others considering the product:

If you are looking for an easy and fast way to admin your database. This is free

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

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.

Copy Review URL
Applications Engineer
Mid-Market
(201-500 employees)
Validated Reviewer
Review Source
Copy Review URL

"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 problems are you solving with the product? What benefits have you realized?

Software development for electronic assembly machine

Copy Review URL
Mid-Market
(51-200 employees)
Validated Reviewer
Review Source
Copy Review URL

"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 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.

Copy Review URL
Small-Business
(11-50 employees)
Validated Reviewer
Review Source
Copy Review URL

"Client Software for Postgresql"

What do you like best?

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?

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 are you solving with the product? What benefits have you realized?

It lets you run sql queries on PostgreSQL Database,

Copy Review URL
Junior Developer
Small-Business
(11-50 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"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 problems are you solving with the product? What benefits have you realized?

Database administration, it is quick and easy to access

Copy Review URL
U
Enterprise
(10,001+ employees)
Validated Reviewer
Review Source
Copy Review URL

"Fast and simple postgres"

What do you like best?

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?

This version I notice slower, the section in which one places the querys is as hidden

Recommendations to others considering the product:

I recommend it, especially for developers and new projects

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

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

Copy Review URL
Security engineer
Enterprise
(5001-10,000 employees)
Validated Reviewer
Review Source
Copy Review URL

"Pgadmin database"

What do you like best?

It is very effective for importing the data into it. Good tool for importing and exporting the data, storing.

What do you dislike?

It wil take too much time to load the data and it will consume more time while backup the data

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

Storing the data, importing and it will reduce the manual work. Queries very helpful for begineers

Copy Review URL
A
Mid-Market
(51-200 employees)
Validated Reviewer
Review Source
Copy Review URL

"Review of the Pgadmin software"

What do you like best?

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?

Easy to use connects directly with the postgrsl and easy to mount database

Recommendations to others considering the product:

Software very easy to use to manage through its graphical environment, I recommend that you use this database manager product.

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

With the pgadmin, you are managing the database of the company's administrative system and the ticket control system. Which is currently used

Copy Review URL
A
Small-Business
(11-50 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"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 problems are you solving with the product? What benefits have you realized?

the benefit is the ease of handling postgresql

Copy Review URL
U
Mid-Market
(201-500 employees)
Validated Reviewer
Review Source
Copy Review URL

"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 problems are you solving with the product? What benefits have you realized?

Software development for electronic assembly machine

Copy Review URL
UI
Mid-Market
(201-500 employees)
Validated Reviewer
Review Source
Copy Review URL

"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 problems are you solving with the product? What benefits have you realized?

Database for the entire system

pgAdmin User Ratings

8.5
Ease of Use
Average: 8.4*
7.6
Quality of Support
Average: 8.3*
8.2
Ease of Setup
Average: 8.3*
* Other IT Infrastructure Category
Do you work for pgAdmin?

pgAdmin Categories on G2