pgAdmin

4.2
(23)

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.

Find the Right Product

Compare pgAdmin to Similar Solutions

pgAdmin Reviews

Chat with a G2 Advisor
Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • Industry
Ratings
Company Size
User Role
Industry
Showing 23 pgAdmin reviews
LinkedIn Connections
pgAdmin review by José Eriberto B.
José Eriberto B.
Validated Reviewer
Verified Current User
Review Source
content

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

Sign in to G2 to see what your connections have to say about pgAdmin
pgAdmin review by George G.
George G.
Validated Reviewer
Verified Current User
Review Source
content

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

What Other IT Infrastructure solution do you use?

Thanks for letting us know!
pgAdmin review by ALEXANDER J.
ALEXANDER J.
Validated Reviewer
Verified Current User
Review Source
content

"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

pgAdmin review by Natalia K.
Natalia K.
Validated Reviewer
Verified Current User
Review Source
content

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

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

"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 Carranza R.
John Carranza R.
Validated Reviewer
Verified Current User
Review Source
content

"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 SUBHA P.
SUBHA P.
Validated Reviewer
Review Source
content

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

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

"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 Dinesh J.
Dinesh J.
Validated Reviewer
Verified Current User
Review Source
content

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

We admin our Pg databases using pgAdmin.

pgAdmin review by Gulshandeep S.
Gulshandeep S.
Validated Reviewer
Verified Current User
Review Source
content

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

We manage our databases using pgAdmin.

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

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

"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 User
User
Validated Reviewer
Review Source
content

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

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

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

"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 Navdeep S.
Navdeep S.
Validated Reviewer
Review Source
content

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

It lets you run sql queries on PostgreSQL Database,

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

"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 User
User
Validated Reviewer
Review Source
content

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

pgAdmin review by Administrator
Administrator
Validated Reviewer
Review Source
content

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

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

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

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

"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

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