Product Details

Vendor Details

PostgreSQL Global Development Group

www.postgresql.org

Founded 1992

United States

About PostgreSQL

Free open source post-relational database system that runs on all major operating systems. PostgreSQL's 25 year development history provides a huge range of features for Developers and DBAs, delivered in a robust software server used world-wide. PostgreSQL is rated in the top 5 databases by DBEngine, above most commercial systems. With millions of deployments in embedded systems, major cloud providers and major on-premise installs, PostgreSQL is the most popular choice for new app development.

- It is stable and reliable, scalable and secure with the correct user management.

- Can work with small and large databases.

- Handles the SQL language.

- Being free software, it is compatible with several graphic tools that help administration and database design. I particularly recommend working with PgAdmin in its latest version for postgres 9.6.6 onwards.

- Easily works as a cluster, can be configured as active-passive or active-active which improves performance

- It allows to perform maintenance, recovery of databases.

- I have tested the installation and use in Windows 7 operating system and Debian version 6 to 8 and works without problems.

- Likewise I have worked in postgres since its version 8.1 to 9.6.6 and a positive change has been noticed and performance improvements, but I insist on the point at which the databases should be fine designed.

Cons: - Many people declare it as slow in insertions and updates compared to others Managers, however, that will depend on how well designed the database is.

- For some, not having support online or with an official help center can be a big disadvantage.

- It is advisable to have command knowledge to work on consoles and terminals to perform a good configuration

Overall: In my very particular opinion I feel comfortable working with Postgres for more than 10 years, it is reliable and safe, the best thing is that it is free, which allows you to save on licenses, it is ideal for any type of development. I totally recommend it

PostgreSQL is powerful and robust, it fits perfectly in large projects

Jul 07, 2018

Aníbal M.

Programador

Used the software for: 2+ years

Reviewer Source

Source: Capterra

5/5

Overall

3
/
5

Ease of Use

5
/
5

Features & Functionality

3
/
5

Customer Support

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: I really like PostgreSQL I have used it several times for large projects in my previous works and in the current one it is used as a database for the web page of the institution, the power of PL / pgSQL is excellent, it allows me to program commercial layers in the database without any problem this improves the response times of the final applications and allows investments in hardware in the database servers instead of in the application, the management of schemes is perfect. It is important to mention that it is free software that implies having a large database without licensing costs. A feature of PostgreSQL is the multiversion concurrency control that allows transactions consistent with time, which provides great performance advantages. PgAdmin is a graphical tool with which I can manage different databases easily and intuitively, execute SQL statements, as well as create backup copies or perform maintenance tasks. Another thing that I like about PostgreSQL is that it is available for many platforms, it is possible to install it from the repositories of the Linux version that I use. It should be noted that the PostgreSQL user community is one of the most active in the market

Cons: There are some things that I do not like about PostgreSQL, permissions allowance per user can be annoying, I have had to work many times on this and it is difficult, it is also relatively slow when I insert and update small databases. The official support does not have telephone or online support, although there are official forums available where users can express their doubts to which other users of the community respond. The syntax of some of your commands or statements may not be intuitive if you do not have a medium level of knowledge in the SQL language. I have had problems migrating from a PostgreSQL version to a higher one. Compatibility is sometimes relative.

Overall: With PostgreSQL I have been able to perform my work satisfactorily on multiple occasions, my bosses and I are happy with the results we have obtained, saving hardware investment costs because we have focused on the database, I hope to have future benefits to the use it in projects for own clients.

Database Manager PostgreSQL

Sep 13, 2018

Maryury P.

DBA Especialista I

Banking, 10,001+ employees

Used the software for: 2+ years

Reviewer Source

Source: Capterra

4/5

Overall

3
/
5

Ease of Use

4
/
5

Features & Functionality

4
/
5

Customer Support

4
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: PostgreSQL allows to control high concurrency, offering security by domain definitions, who can access the database server, the backup copies of the database can be made completely or only a table, according to the request, restorations and tasks maintenance, in addition to replicate in case of disasters.

It also allows to activate triggers to execute in tables or views in special cases or eventualities.

It has a friendly graphical interface for the administrator, through which they can be done from the creation of the database, to execute query querys and updates of the data, if necessary, you can have details with the status tool of the server referring to the queries that are executed in the DB (if there are locks, duration, etc.).

It allows the development of robust and efficient Databases

Cons: There is no online or telephone support. Only official forums are available where users expose their doubts that other users of the community respond to, ademas it consumes many resources

Overall: In my experience using the software I really liked that it allows adding custom functions developed using different programming languages.

The integrity of the data and the referential integrity of the foreign key are maintained. It has allowed me, in an easy and secure way, the asynchronous replication of the databases for an alternative center in case of disasters.

I did not like it is that when I have any doubt about an error presented in the system where the database is working, I can not clarify it because there is no specific place to which, because and com solve the error.

Open source object-relational database management system for Web Developers

Jan 09, 2018

Ashish A.

Software Engineer

Used the software for: 1-2 years

Reviewer Source

Source: Capterra

5/5

Overall

4
/
5

Ease of Use

4
/
5

Features & Functionality

4
/
5

Customer Support

5
/
5

Value for Money

Pros: PostgreSQL or simply Postgres implements the SQL and advanced SQL standard very well. It can handle workloads ranging from small web applications to large data warehousing with many parallel users. Postgres provides a easy to use tool called pgAdmin to interact with and manipulate database. It provides support for complex data types like (multi-dimensional) Array, Json, user-defined types. PostgreSQL provides higher number of connections at cheap price. It support all types of indexing for faster retrieval of data. In my company we replaced our database server from MySQL to PostgreSQL because of PostgreSQL higher db connections connections in cheaper price as compared to MYSQL. It is also available free of cost till 10,000 rows on Heroku.

Cons: PostgreSQL query syntax for some complex queries like array, json, string functions and case operator are bit complicated to write . Installation and configuration of PostgreSQL is not as easy as MySQL. Documentation is not as good as compared to MySQL and it is bit harder to search for help regarding some complex queries and database functions on google. Replication is not yet as well implemented as in MySQL.

Best Database Management System with wide range of Features

Jul 04, 2018

Jugraj S.

Software Engineer

Used the software for: 6-12 months

Reviewer Source

Source: Capterra

5/5

Overall

5
/
5

Ease of Use

5
/
5

Features & Functionality

5
/
5

Customer Support

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: PostgreSQL is one of the best from the range of DBMS i used in my career.

Features like Stored Procedures is one of the reason i prefer this tool. It helps me take off a huge amount of workload from the API server as same data need to format differently for different APIs.

Along with it the availability of builtin functions like JSON functions, Regex Functions etc helps a lot in the data processing field.

Connectors support for various languages is one of the main reason for using this tool. Connection Pooling helps me execute multiple queries without slowing the system and losing any data.

Cons: It is not suitable for beginners. Designing a efficient and effective Database workflow need a skilled DB Admin so a beginner need some time to get to familiar with the system.

Another drawback is its management tool pgAdmin 4. Its a disaster compare to pgAdmin 3.

It is a web App and lags a lot. I face problems in multitasking in version 4 that is not the case with version 3.

Pros: It is fast and reliable, manages inserts and updates of tens of thousands of lines impeccably. PostgreSQL implements SQL standards very well and supports advanced SQL stuff, the PostSQL database works very well with hibernation HPA and we have been using it extensively together with the Spring framework, the consistency is also very good, you will never lose data or lose data. JSON support in the latest version has made things easier for us now, since we do not need to migrate the schema as always before. Finally, the backup methods through pg_dump are easy to use and ensure that you can always back up before any major changes.

Cons: It is not very intuitive, in my opinion, and I think those problems must be solved before I can get the kind of traction that MySQL has, also more open sources admit mysql but not postgres. These are some of the problems with postgres.

Overall: Because range queries are integrated, it is much less effort to query compared to MySQL.

Best database for RoR apps

Jun 22, 2018

Alvaro I.

Director of Web Development

Internet, 51-200 employees

Used the software for: 2+ years

Reviewer Source

Source: Capterra

5/5

Overall

5
/
5

Ease of Use

5
/
5

Features & Functionality

5
/
5

Customer Support

5
/
5

Value for Money

Pros: - Scalability is a key factor in a database and PosgreSQL handle this large amounts of data without breaking a sweat.

- Rich text queries runs smoothly as well.

- The integration with ActiveRector is awesome!!

- I think is the most famous free database in the market right now, so that means that when an error happen you will have a good community that will have your back.

Cons: - There isn't many thing to say about PosgreSQL, I will say that the most traumatic part is the installation but once you have it up and running this should be a walk in the park for a developer to use.

Wanted to use an open source object-relational database for our project and postgres worked well

Jun 30, 2018

ritesh t.

Senior Software Engineer

201-500 employees

Used the software for: 2+ years

Reviewer Source

Source: Capterra

5/5

Overall

5
/
5

Ease of Use

5
/
5

Features & Functionality

5
/
5

Customer Support

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: 1)Easy installation with good user guide

2)Scales pretty well for big applications

3)Support for high availability can be easily implemented by going through the documentation

4)Have yet to find any database related issues in our application since the time application was launched

5)Good Java-sql mapping of data types

6)Works wonders with JPA implementations

7)Postgresql's query optimiser is one of the best i have seen so far

Cons: Again since the software has so much to offer it can be sometime hard to learn all the features.Other than that there is no cons as such

Very good open source database

Aug 23, 2018

Srikanth V.

Sr MTS

Information Technology and Services, 10,001+ employees

Used the software for: 2+ years

Reviewer Source

Source: Capterra

4/5

Overall

4
/
5

Ease of Use

4
/
5

Features & Functionality

4
/
5

Customer Support

4
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: One of the best open source RDBMS database.

Easy to integrate with services and works in high read/writes env.

Advanced features like master slave replication are easy to implement and doesn't take too long for training or implementation.

Used across the software industry, so it has good forums and blogs to support any issues.

Cons: It is very difficult to install postgres on production servers that doesnt have access to internet.

Earlier versions of postgres doesn't support upsert functionality.

Doesn't have a good database client.

Doesn't have a good monitoring mechanism

easy to use and understand

Mar 14, 2018

Albernes G.

progamador

Used the software for: 6-12 months

Reviewer Source

Source: Capterra

3/5

Overall

4
/
5

Ease of Use

3
/
5

Features & Functionality

1
/
5

Customer Support

5
/
5

Value for Money

Pros:

its graphic environment and considerable savings in operating costs: PostgreSQL has been designed to have a maintenance and adjustment lower than the products of commercial suppliers, while retaining all the characteristics, stability and performance. Stability and reliability: There have been no drops in the database

Cons:

That Compared to MySQL is slower in insertions and updates, since it has intersection headers that do not have MySQL Support online: There are official forums, but there is no mandatory help It consumes more resources than MySQL .

Overall:

It can operate on platform specifications, including Linux, Windows, Unix.

Large storage capacity

Good scalability since it is able to adjust to the number of CPU and the amount of available memory optimally, supporting a greater number of simultaneous requests to the database correctly.

It supports the types of data, clauses, functions and commands of standard type SQL92 / SQL99 and extended own of PostgreSQL ..

Runs a 150GB DB containing a quarter million records without breaking a sweat

Jun 07, 2017

Phil S.

Sr. Developer

Computer Software, Self-employed

Used the software for: 2+ years

Source: Capterra

5/5

Overall

4
/
5

Ease of Use

5
/
5

Features & Functionality

5
/
5

Customer Support

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: Pretty much everything, although there are a few features from commercial databases that I'm hoping will make it in. After having used it for several years, and a certain "M" competitor for several years prior, I can confidently say that it's really hard to go wrong in recommending PostgreSQL to anyone with even a small amount of technical knowledge.

Cons: - Setting up replication can be a bit tricky

- There isn't really a good repository for an up-to-date (or per-version) list of common tips, tricks and queries. Often can be some googling to track down what you're looking for

Very reliable database

Oct 18, 2018

Cristiano D.

sistemista / programmatore

Information Technology and Services, 1-10 employees

Used the software for: 2+ years

Reviewer Source

Source: Capterra

5/5

Overall

5
/
5

Ease of Use

5
/
5

Features & Functionality

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: A very powerful RDBMS at the best price point: free

Integrated with spatial extension PostGIS

Very quick and stable, it manages flawlessly hundreds of millions of records

Cons: Table partitioning is limited

Multimaster replicas are available only through a third party distribution

Overall: PostgreSQL is a very reliable, stable and quick RDBMS. In my experience it has no problems managing hundreds of millions of records.

From a DBA point of view, has a very low TCO since once configured it seldomly needs further intervention by the DBA.

It comes with PostGIS plugin, so it is very easy to manage geographical data types

JSON+RDBMS = Perfect Database

Sep 12, 2018

Priyansh S.

Database Manager

Computer Software, 11-50 employees

Used the software for: 2+ years

Reviewer Source

Source: Capterra

5/5

Overall

5
/
5

Ease of Use

5
/
5

Features & Functionality

5
/
5

Customer Support

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: PostgreSQL is a very special kind of database, it lets you store data in tables in rows and columns form, while giving you flexibility to JSON data types to make your application flexible. It provides support for a large number of complex data types say JSON, JSONb, Text Array, Integer Array, thus giving you a very powerful database tool.

Cons: It gives very good performance for the first few million record in database, but after that you will need to write your SQL queries very carefully as performance is not that good.

De facto RDBMS for the Internet

Aug 17, 2018

Morgan C.

CIO

Information Technology and Services, 51-200 employees

Used the software for: 2+ years

Reviewer Source

Source: Capterra

5/5

Overall

4
/
5

Ease of Use

5
/
5

Features & Functionality

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: PostgreSQL is open source. We use it for pretty much every site or system we build. It scales well and needs a minimum of tuning. We only fall back to MySQL when absolutely necessary.

Cons: We still encounter software which can only run on MySQL, especially PHP applications. For those we'll tolerate MySQL but otherwise we would prefer PostgreSQL support.

Overall: We have run many sites on PostgreSQL with Django at high performance. We use NoSQL where appropriate, but in every case we have still used Postgres for the main data store, and used the key value stores for caching and queueing.

PostgresSQL And web development

Aug 17, 2018

Jose G.

Consultor Java Senior

Computer Software, 51-200 employees

Used the software for: 2+ years

Reviewer Source

Source: Capterra

4/5

Overall

5
/
5

Ease of Use

4
/
5

Features & Functionality

4
/
5

Customer Support

4
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: PostgresSQL is a pretty good product as it allows with an easy installation to access the functionalities of a powerful database manager without sacrificing disk space and ram memory. On the other hand, the fact of using standard SQL ansi provides users with a known syntax.

Cons: In my personal experience postgresSQL does not work well with large volumes of data and it can be tedious to use stored procedures.

Overall: I have used PostgresSQL in my Java Web developments with absolute confidence as its results are as expected in terms of data manipulation.

PostgreSQL free RDBMS.

Mar 22, 2018

Denis V.

MS SQL Server DBA

Used the software for: 2+ years

Reviewer Source

Source: Capterra

4/5

Overall

4
/
5

Ease of Use

3
/
5

Features & Functionality

4
/
5

Customer Support

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: In General, a good performance suitable for systems with weak iron. The system as a whole works very steadily. Flexibly customizable functionality plus extensive plugin support. Large community. The presence of integration with ETL solutions pleases us. I would also like to mention the SQL editor, which implements syntax highlighting in different colors, which gives excellent readability of the code. And the most basic and the main thing is that it is a free open source database management system.

Cons: Not very suitable for beginners, requires significant additional time spent on the study. It does not have high availability solutions, nor does it have clustering. Difficult to install and configure. Not very well written documentation.

Overall: This RDBMS can be used in various scenarios, probably more suitable for hosting site data, stable in operation, quickly works with large databases.

It is a fairly complete database manager, with a lot of functionality and a lot of documentation. Be

Mar 22, 2018

Eyamir del Valle U.

Ingeniero en Informática

Used the software for: 2+ years

Reviewer Source

Source: Capterra

5/5

Overall

5
/
5

Ease of Use

5
/
5

Features & Functionality

5
/
5

Customer Support

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: its easy use, the robustness in the implementation of the security of the database. Its great functionality, which allows safe and easy use of data.

Cons: Actually up to now I have not found features that I do not like. The only thing is that sometimes it is a little complicated to get hosting that provide the service for PostgreSQL

Overall: It really is a fairly robust database manager, which allows an excellent data management and a quite complete security implementation, as well as the implementation of procedures that allow to take care of the integrity of the data easily.

A step towards evolution

Sep 14, 2018

Tomas D.

Analista de Base de Datos

Telecommunications, 5001-10,000 employees

Used the software for: 6-12 months

Reviewer Source

Source: Capterra

5/5

Overall

5
/
5

Ease of Use

5
/
5

Features & Functionality

4
/
5

Customer Support

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: I like most about Postgres is its versatility and ease of use, all in a single database engine.

It is robust, versatile, simple and there is a great documentation that can be useful in times of difficulty, in addition to that's free and can be used comfortably in production environments (where exist high demands of data) or for environments where it is not necessary to have a high performance. In my company we use Postgres for environments different (quality, production and development) with excellent result.

Cons: There are really some things that I don´t like about Postgres, I could comment on is that when errors occur, I would recommend that in the different information LOGs the errors are shown by code (error code), as happens with other database engines.

Native JSON data type Support!!

Oct 03, 2018

Nathan M.

Reports Developer

Information Technology and Services, 1001-5000 employees

Used the software for: 2+ years

Reviewer Source

Source: Capterra

5/5

Overall

4
/
5

Ease of Use

5
/
5

Features & Functionality

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: PostreSQL has native JSON and JSONB data type support built in, with some really convenient methods for traversing JSON structures.

Cons: Documentation isn't the greatest - I had to use a lot of trial and error for some of the json convenience methods they've added in.

Overall: This is a great solution for adding in JSON datatype support along side standard data types; allowing for mixing and matching of JSON based queries and standard SQL in the same table/schema. Very powerful when leveraged in web services based applications.

Cons: The CLI is not the best option when your tables have several columns

Overall: Postgres is by far the strongest database relational engine, it's a one package solution, it will hold tons of transactions with no problems, it is highly reliable and high performance based.

We use Postgres to hold the data for both our web app and Mobile apps, we use a web service layer that interacts directly with the data base and it works like a charm.

It will also allow you to store things like JSON objects (JA! Take that MongoDB!) and use those objects and even create search queries based on that data.

Recommendations to other buyers: If you come from MySql world this is by far the best open source db option that you might use

YES

Sep 06, 2018

Levi S.

Senior Software Engineer

Computer Software, 11-50 employees

Used the software for: 2+ years

Reviewer Source

Source: Capterra

5/5

Overall

3
/
5

Ease of Use

5
/
5

Features & Functionality

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: PostgreSQL is powerful, performant, and a snap to integrate with the languages I use.

Cons: The documentation sometimes doesn't make it immediately obvious which version you are looking at. You have to be really careful you aren't using old documentation with a newer version of the product.

Overall: PostgreSQL is my go to for databases for the web development work I do. It has a ton of datatypes that are super useful and has a lot of the features found in the giant (and expensive) competitors. This is a fantastic tool.

Easily the best cost/performance ratio on the market

Mar 07, 2018

Verified Reviewer

Machinery, 11-50 employees

Used the software for: 2+ years

Reviewer Source

Source: Capterra

5/5

Overall

4
/
5

Ease of Use

5
/
5

Features & Functionality

3
/
5

Customer Support

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: Powerful, fast, easy.

PostgreSQL is straightforward to use, powerful, and it's free to install. Hard to beat that.

Cons: The new management interface pgAdmin 4 is a minor disaster. It was designed from the faulty assumption that database developers/administrators want to use a web interface. I'd like to meet these people as I don't know any of them. Fortunately, pgAdmin 3 is still functional and available. With any luck, it will continue to be so.

The best database manager in the market

Jun 11, 2018

Carlos Alberto P.

Especialista de Desarrollo

Used the software for: 2+ years

Reviewer Source

Source: Capterra

5/5

Overall

5
/
5

Ease of Use

5
/
5

Features & Functionality

5
/
5

Customer Support

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: Great distribution of resources for complex queries,highly configurable allowing thus adapting it to the needs of those who implement it, Allows you to set limits on incoming connections to avoid unwanted timeouts by developers

Cons: There are few negative things that can be said about postgresql, however the PGADMIN, which is its graphical interface, has been its achilles heel from version 4.0 onwards, using the console preferably

Cons: Its hard to think of any. You can have it any way you want it; the open source community version which is supported brilliantly on mailing lists, or paid enterprise support if you have ola's/sla's to meet.

Pros: Database with outstanding functions to save information, combination with lots of applications established in various languages of application advancement, compatibility with Windows running systems, Linux, and so on. Easy to incorporate, to save information, to engage with company intelligence software application, permits duplication of information with streammig duplication

Cons: The postgresql database management system has a weak point that does not have high accessibility systems, does not consist of cluster administration, just consists of separated tools

Built a whole digitization production line around Postgres.

Apr 16, 2018

Verified Reviewer

11-50 employees

Used the software for: 2+ years

Reviewer Source

Source: Capterra

5/5

Overall

4
/
5

Ease of Use

4
/
5

Features & Functionality

3
/
5

Customer Support

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: - Reliability: we experienced some problems during production, absolutely none of them caused by Postgres

- The new web-based client PgAdmin 4 is a regression from the old desktop client

Overall: At the time we chose it, we got the speed of MySQQL and the reliability of Oracle for free. Now, it's still working and well maintened.

PostgreSQL is te best DBMS out there.

Nov 09, 2017

Efrain D.

System Administrator

Information Technology and Services, 51-200 employees

Used the software for: 2+ years

Reviewer Source

Source: Capterra

5/5

Overall

5
/
5

Ease of Use

5
/
5

Features & Functionality

5
/
5

Customer Support

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: PostgreSQL is a robust yet very easy to use DBMS. You can trust PostgreSQL to save your data no matter how big it its. It is very well documented and the community that develops it is the best (thanks guys!). In the newer versions it nows supports saving JSON data so you can use it as a NoSQL solution. PostgreSQL is simply the best.

Overall: Having a robust DBMS for our database is great.

Best free open source database which is also available in the Amazon web services as PaaS

Nov 13, 2017

Ravikiran R.

Architect

Used the software for: 2+ years

Reviewer Source

Source: Capterra

4/5

Overall

4
/
5

Ease of Use

5
/
5

Features & Functionality

4
/
5

Customer Support

4
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: Good full text search capabilities

Good UI tool from PG Admin

Good Security features

Good User and group management

Cons: Requires good stability

Good scalability in the enterprise environment

If we put large text, some times response is very slow

Some times auto vaccume takes time

Overall: Free of charge

Open source

Many available plug-ins

Able to usw in AWS as PaaS

Application development in java or php with relational database in postgresql, creation of functions

Jun 28, 2018

Alafia V.

Analista de programas

Used the software for: 2+ years

Reviewer Source

Source: Capterra

5/5

Overall

5
/
5

Ease of Use

5
/
5

Features & Functionality

4
/
5

Customer Support

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: It is a management system for free relational databases very robust, can support many transactions at the same time and works very efficiently

Cons: The installation and configuration is a bit complicated for beginners as the documentation is not very clear when you have a question

Overall: Excellent for managing relational database

a powerfull DBMS, i used in businesses and provides a lots of features.

May 18, 2018

Juan Carlos G.

Profesor

51-200 employees

Used the software for: 2+ years

Reviewer Source

Source: Capterra

5/5

Overall

4
/
5

Ease of Use

5
/
5

Features & Functionality

5
/
5

Customer Support

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: Part of community software, free, adaptable and configurable. The security is very powerful, management user, tablespaces, logs...

Cons: Because is a free sorftware, have multiple choice for support, however many businesses has certifications...

Overall: Although is not Oracle Corp, y prefer use PostgreSQL to management the DB in where work.

It is a good database manager

Jul 06, 2018

Verified Reviewer

Used the software for: 2+ years

Reviewer Source

Source: Capterra

5/5

Overall

5
/
5

Ease of Use

5
/
5

Features & Functionality

4
/
5

Customer Support

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: I like it because it is stable, widely used and that I can develop high-end databases. It also offers features that openly is very useful.

Cons: Against it I see that it is a very good software but they are leaving it as a use for studies and simple things when it can be developed much more.

Overall: I really like the software

The best software for database administration.

Jul 12, 2017

Luis E.

Analyst

Information Technology and Services, 1-10 employees

Used the software for: 2+ years

Source: Capterra

5/5

Overall

4
/
5

Ease of Use

5
/
5

Features & Functionality

4
/
5

Customer Support

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: It allows you to make almost everything to a database, and the way you can make triggers and functions very easy. It have endless posibilites

Cons: You need to set up very carefully the users and permission, otherwise you can end up deleting the base database.

Overall: I learned up how to administrate a data base to the maximum thanks to this software

Most reliable, feature rich RDBMS for Enterprise workloads

Mar 08, 2018

Glyn A.

DBA

Used the software for: 2+ years

Reviewer Source

Source: Capterra

5/5

Overall

5
/
5

Ease of Use

5
/
5

Features & Functionality

5
/
5

Customer Support

5
/
5

Value for Money

Pros: Impressive features that even out perform commercial rivals.

Fault tolerance is second to none.

Very good compliance with SQL standards

Cons: Very little, PostgreSQL isn't used enough in the enterprise. Sickening to see how many businesses rely on MySQL; which fails in almost every use case beyond tiny website.

Good DBMS. Handles a lot of data without loss of performance

Dec 04, 2017

Stanislas J.

Administrateur du SIGB

Used the software for: 1-2 years

Reviewer Source

Source: Capterra

5/5

Overall

4
/
5

Ease of Use

4
/
5

Features & Functionality

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: It is very fast for running queries from bash (logged in by SSH) or within PGAdmin (from a distant client) ; the ability to lauch queries from PHP permits building web-apps using the database very simply.

Cons: Using variables in not as simple as in MySQL. It needs to use plSQL or mixing bash and SQL.

I prefer PgAdmin 3 rather than PgAdmin 4. This new version seems to priorize design rather than ease of use.

Overall: It is a lot more efficient than the old database manager we used before.

Nice DB Management Tool

Mar 06, 2018

Rafael R.

Junior Developer

11-50 employees

Used the software for: 1-2 years

Reviewer Source

Source: Capterra

4/5

Overall

4
/
5

Ease of Use

4
/
5

Features & Functionality

3
/
5

Customer Support

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: The simplicity and access of its interface. it is quick and easy to access. It have a lot of powerfull functionalities and it is compatible with almost every platform out there.

Cons: 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.

Overall: Database administration, it is quick and easy to access so we can manage our data in minutes, saving time fot other activities. Also the security is very good.

Cons: The tools ecosystem around is rather poor. There are some different options each in with its own problems, but there is no consistent tooling ecosystem around the engine.

offers great advantages in terms of performance and that its simple maneuver allows us to define cus

Mar 12, 2018

Verified Reviewer

Used the software for: 1-2 years

Reviewer Source

Source: Capterra

5/5

Overall

5
/
5

Ease of Use

5
/
5

Features & Functionality

4
/
5

Customer Support

4
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: It is free and free, which offers us a large number of advanced options. It has a multiversion concurrency control. This method adds an image of the state of the database to each transaction, allowing us to perform possibly consistent transactions. Postgres does not require the use of blockages. reading when making a transaction which gives us greater scalability. It brings a lot of flexibility to our projects as it allows us to define customized functions through several languages

Cons: the transactions abort completely if a fault is found during its execution, which can cause the loss of information, it is slow in the insertions and the updates since it has intersection headers, the object orientation support is a simple extension that offers benefits such as inheritance, not full support. The current versions of PostgreSQL have a serious security problem that will be fixed in the next versions of the product

Overall: allows us to create databases using different programming languages, PostgreSQL is available for many platforms and offers the source code from the official site. Users can create their own data types, which can be completely indexable thanks to the GiST infrastructure of PostgreSQL

I had a good experience since the first time i used this in my college

Jun 07, 2017

Edward R.

Proyect Leader

Used the software for: 2+ years

Source: Capterra

4/5

Overall

4
/
5

Ease of Use

4
/
5

Features & Functionality

4
/
5

Customer Support

4
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: I like the powerful security levels in this database system despite being open source, and i like work it in different operative systems.

Cons: I think it's not easy to understand how to do database backups and for that reason i don't like do it

Overall: it's a powerful open source database system, and it's a trendy software

This is another of my DBMS for some of our apps and is very stable

Apr 12, 2018

Yezid M.

IT and Network Administrator

Used the software for: 1-2 years

Reviewer Source

Source: Capterra

4/5

Overall

3
/
5

Ease of Use

4
/
5

Features & Functionality

3
/
5

Customer Support

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: This DB server has a powerfull set of functions that has permitted to our DB Admin to generate more efficient reads and writes on it. The fact of having this kind of DBMS available on OpenSource is very good for organizations that needs to save some money in IT platform

Cons: According with us, configuration of PostgeSQL may result complicated, because of this is an advanced DBMS. Interfaces to manage are not simple, at least for me.

Great quality of software, very productive

Nov 21, 2017

Juan Carlos F.

Programador Senior

Used the software for: 2+ years

Reviewer Source

Source: Capterra

4/5

Overall

4
/
5

Ease of Use

5
/
5

Features & Functionality

3
/
5

Customer Support

3
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: All support is available from developers , easy to install in many operative systems, is enough some minimium requirements from your PC.

Cons: Sometimes it's not compatible with some of my databases with previous versions so that is not cool, expensive if you want fully specs.

Overall: All about my work

Best DBMS

Apr 17, 2018

Harpaul S.

Software Engineer

Information Technology and Services, 11-50 employees

Used the software for: 2+ years

Reviewer Source

Source: Capterra

5/5

Overall

5
/
5

Ease of Use

5
/
5

Features & Functionality

5
/
5

Customer Support

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: unlike mysql, PostgreSQL provide supports for both relational as well as json data storage. Provides functionalities of a perfect hybrid database.

Cons: Sometime indexing do not work for complex queries. Also for very heavy like like a few million record, it needs a lot of memory

is a database that is easy to use and very practical, the benefits of working with it are many

Mar 08, 2018

Jorge M.

Ingeniero de sistemas

Used the software for: 6-12 months

Reviewer Source

Source: Capterra

3/5

Overall

4
/
5

Ease of Use

3
/
5

Features & Functionality

3
/
5

Customer Support

4
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: is an object-relational database which allows it to be compatible with user-defined objects, this makes postgresSQL a flexible and robust database, it supports an extensive amount of data types among them, numeric, comma types floating, array, among many more, allows to create a wide functionality through its trigger system (triggers). It has a support for distributed transactions which supports the integration in a distributed system consisting of several resources such as a PostgreSQL database, another Oracle, an IBM MQ JMS message queue and an SAP ERP managed by an application server.

Cons: the transactions abort completely if a fault is found during its execution, which can cause the loss of information, it is slow in the insertions and updates since it has intersection headers, the object orientation support is a simple extension that offers benefits such as inheritance, not full support. The current versions of PostgreSQL have a serious security problem that will be fixed in the next versions of the product.

Overall: It is free license and can be operated on different platforms, including Linux, Windows, Unix, Solaris and MacOS X. It has a multiversion concurrency control which adds an image of the state of the database to each transaction allowing the transferences to be consistent and high performance.

Open-source relational database -- best choice for most use cases!

Mar 05, 2018

Alexander A.

Researcher

Used the software for: 6-12 months

Reviewer Source

Source: Capterra

5/5

Overall

3
/
5

Ease of Use

5
/
5

Features & Functionality

3
/
5

Customer Support

5
/
5

Value for Money

Pros: This is an open-source relational database. One might consider it to be the modern gold standard RDBMS. Nothing really compares. It's much better than MySQL and others. Moreover, the "Postgres ecosystem" is so robust right now, you can really do most things in it. For example, if you want to do GIS, there's an extension for that; timeseries? there's an extension for that.

Cons: Installation of Postgres can be a bit tricky on various operating systems. To be fair, it's gotten better in the last couple of years. There are lots of how-to guides online now.

Cons: Scalability. When it comes to a few million rows of data, postgres becomes really slow. Some other RDBMS perform better at that scale.

Open Source Software

Jun 09, 2018

YagneshKumar P.

Software Engineer

Hospitality, 51-200 employees

Used the software for: Less than 6 months

Reviewer Source

Source: Capterra

4/5

Overall

5
/
5

Ease of Use

4
/
5

Features & Functionality

3
/
5

Customer Support

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: PostgreSQL is one of the best open source software that i like to use, it enables me to create database schema, restore databases, and also execute SQL queries. It it very easy to set-up and start using the web based application, so internet connectivity is a must unlike other SQL software, My Company recently transitioned to use PostgreSQL as a New Hire Training so people have an exposure on how to use execute SQL and more. One of functions i like about it is that, if support advanced SQL queries such as expressions and stored procedures. It also supports advanced data types such as arrays, and user-defined data types.

Cons: At the moment i do not have a negative feedback on PostgreSQL i feel like i like all the features about it.

Overall: The benefits i get using PostgreSQL is the ability to create tables, scehmas, store procedures and then use them to create SQL queries and expressions.

Provides Everything Oracle does.... FOR FREE

Sep 20, 2018

Michael P.

Electrical/Software Engineer

Semiconductors, 5001-10,000 employees

Used the software for: 2+ years

Reviewer Source

Source: Capterra

5/5

Overall

5
/
5

Ease of Use

5
/
5

Features & Functionality

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: IT'S FREE... Awesome for organizing your own relational databases to store any number of records. Very easy SQL language to pick up.

Cons: The Linux way to launch the application is weird.

Develop and manage different databases thanks to this software

May 10, 2018

Verified Reviewer

201-500 employees

Used the software for: 2+ years

Reviewer Source

Source: Capterra

5/5

Overall

4
/
5

Ease of Use

4
/
5

Features & Functionality

2
/
5

Customer Support

2
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: - Unlimited installation: You can not sue a company for installing it on more computers than the license allows.

- It has a graphical interface and makes it much easier for unskilled users

Cons: - Compared to MySQL it is slower in insertions and updates, since it has intersection headers that do not have MySQL.

- Online support: There are official forums, but there is no mandatory help

Overall: We were able to create databases for projects, configure it in different platforms since it is available in almost any Unix, with 34 platforms in the latest stable version, in addition to a native version of Windows in test status.

Excellent database manager

May 14, 2018

Verified Reviewer

501-1000 employees

Used the software for: 2+ years

Reviewer Source

Source: Capterra

4/5

Overall

4
/
5

Ease of Use

4
/
5

Features & Functionality

3
/
5

Customer Support

4
/
5

Value for Money

Pros: Excellent bse data manager for medium and high applications, your work environment is quite simple, you can make high performance migrations, and you have a very fast query memory, you can grow quickly, and dispose of the services efficiently and efficiently. effective.

Cons: It is slower in insertions and updates, the interceptors that manages the database make it very slow and consume resources. It can consume more resources than usual for any manager and does not have very good information on the web.

Great free database option

Sep 13, 2018

Verified Reviewer

Computer Software, 1-10 employees

Used the software for: 2+ years

Reviewer Source

Source: Capterra

5/5

Overall

5
/
5

Ease of Use

5
/
5

Features & Functionality

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: Free

Stable

Reliable

Easy to find solution to the answers online

Cons: UI editor can be improved

Configuration can be more user friendly

The best relational database in the market

May 15, 2018

Josmar J.

Desarrollador de java

501-1000 employees

Used the software for: 2+ years

Reviewer Source

Source: Capterra

5/5

Overall

5
/
5

Ease of Use

4
/
5

Features & Functionality

5
/
5

Customer Support

4
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: - Free version stable and without bugs.

- Almost all the development frameworks have native connectors for it.

- Documentation is very clean.\

- The community of people who use it is huge making it very easy to get help with problems

Cons: - Scaling and big data is very complicated with this and any other relational database.

- Integration with node and json is not natural and these tools are the future in application development.

One of the free database managers most used in the business world.

May 08, 2018

Suhail Z.

Licenciado en Informática y Profesor Universitario

Higher Education, 1001-5000 employees

Used the software for: 2+ years

Reviewer Source

Source: Capterra

5/5

Overall

5
/
5

Ease of Use

5
/
5

Features & Functionality

5
/
5

Customer Support

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: Free database manager, one of the most powerful in the range of the open source database managers. Easy to medium use depending on the knowledge of who uses it. Medium cost compared to other database manager options available in the market. Sufficient support in the network about its use. Compatible with free and proprietary operating system versions. Very versatile its adaptation to different working frameworks. Ideal for medium to large-sized projects.

Cons: Installation is not very easy process. Basic but functional user interface. Slow the database backup and recovery process.

Overall: Widely used as a learning tool in educational environments. Widely used by my students in the development of their school work as students of the Degree in Computer Science. I do not hesitate to recommend it for learning environments.

The best relational database

May 04, 2018

Enrico D.

software developer

Used the software for: 2+ years

Reviewer Source

Source: Capterra

5/5

Overall

5
/
5

Ease of Use

5
/
5

Features & Functionality

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: The non relational function for json is very useful, so postgres can be useful also for not structured data.

The schema allow to maintain the db well-ordered.

The extension postGIS is the best library on a db for spatial data, it have a lot of functionalities and it is easy to use.

Cons: Give the right to the user is no so intuitive.

Set up a cluster is not easy as other system that have include some tool to make it.

One of the best object-relational database management system

Oct 25, 2018

Saurabh A.

Analyst

Financial Services, 51-200 employees

Used the software for: 1-2 years

Reviewer Source

Source: Capterra

4/5

Overall

4
/
5

Ease of Use

4
/
5

Features & Functionality

4
/
5

Customer Support

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: 1)Open source.

2)Scalable.

3)GUI database design and administration tools.

4)Cross platform.

5)Extensive json support.

Cons: 1)Support can be improved.

2)Long learning curve.

Overall: One of the best object-relational database management system

One of the best open source databases available

Nov 09, 2018

Verified Reviewer

Computer Software, 11-50 employees

Used the software for: 1-2 years

Reviewer Source

Source: Capterra

5/5

Overall

3
/
5

Ease of Use

5
/
5

Features & Functionality

5
/
5

Customer Support

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: Postgresql is open source and free and it gets regular updates. The software is the only database as a service which is supported by AWS, Google Cloud, Azure and Heroke - this gives you a lot of options. Super scalable and very flexible. It runs on all major platforms.

Cons: It is difficult to learn and master ... but that speaks to it's power.

The tool set around it is complex - but again this is part of the package. If you want to learn postgres be prepared to work in the command line - that is part of the ecosystem. It is difficult but absolutely worth it.

Cons: It consumes a lot of resources so you need more hardware features to run it.

Without a good configuration it can become insecure.

Overall: Ideal for implementation in web applications.

the most advanced database manager

Jun 08, 2018

Tomás Eduardo R.

Musico I

Used the software for: 2+ years

Reviewer Source

Source: Capterra

4/5

Overall

4
/
5

Ease of Use

4
/
5

Features & Functionality

2
/
5

Customer Support

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: Unlimited and free installation.

Stable and reliable, there have never been any drops in the database.

Through its graphical tool pgAdmin we can manage our databases in an easy way.

Cons: It is relatively slow in insertions and updates in small databases, PostgreSQL is designed for high volume environments.

It does not have online or telephone support.

Overall: its always important to have a database manager that is free and easy to use

Postgres is simple and to the point.

Nov 07, 2017

Tamara J.

Solutions Engineer

Used the software for: 6-12 months

Reviewer Source

Source: Capterra

5/5

Overall

5
/
5

Ease of Use

5
/
5

Features & Functionality

5
/
5

Customer Support

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: There is a huge community of power users online and I feel like I can always get my questions answered with a quick google search.

Cons: There's not really anything that I dont like...maybe if Postgres hosted their own knowledgbase that contained their SQL operators.

Overall: The online community of postgres users is fantastic. I love being able to dive into answers from users who have used the tool more often than I.

The faster open source DBMS

May 13, 2018

Verified Reviewer

Internet, 11-50 employees

Used the software for: 1-2 years

Reviewer Source

Source: Capterra

5/5

Overall

3
/
5

Ease of Use

5
/
5

Features & Functionality

3
/
5

Customer Support

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: PostGreSQL is the fastest and most modern DBMS in the open source market. It's working properly with major tools in web development field. Some patches may be required for example to run Drupal 8 on a customized PostGreSQL instance, but if you stay in the standard, it should run cleanly.

Cons: PostGreSQL is pretty hard to use compared to MySQL, in my opinion. There are some notions that does not exist in MySQL so coming from this tool to PostGreSQL may need some training before being able to use it properly.

Overall: Good performances in big websites using open source software.

PostgreSQL is not for the 'weak'

Sep 05, 2018

Bolade A.

Application Developer

Financial Services, 51-200 employees

Used the software for: 6-12 months

Reviewer Source

Source: Capterra

4/5

Overall

3
/
5

Ease of Use

4
/
5

Features & Functionality

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: If you are a techie, linux user and very concerned about high end data security then Postgresql is your best bet. It has a light and pretty much textual interface that gives you the "let's get straight to business" feel. PostgreSQL syntax is quite different from mysql syntax so there is this peace of mind that comes with knowing that any developer handling your postgresql must be good. it has an overall Great performance and is a right fit for systems with low hardware specifications.

Cons: It has a boring interface and is less colourful or intriguing. It's complex to make postgresql database dump compatible with mysql.

Cons: A little difficult to install on Ubuntu (I always have some kind of problem to solve before I had it up and running), but the docker image is a great workaround for this ( and today I my main choice to use PostgreSQL on Ubuntu)

Opensource RDBMS system

Jul 09, 2018

Piyush G.

Data Scientist

Government Administration, 1001-5000 employees

Used the software for: 2+ years

Reviewer Source

Source: Capterra

5/5

Overall

5
/
5

Ease of Use

5
/
5

Features & Functionality

5
/
5

Customer Support

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: POSTGRESQL is an opensource RDBMS system which makes SQL and advance SQL concepts very effective. Load data very effectively and with speed. It can easily integrate with other tools very easily. I have used it with SAS and It was very good!!

Cons: Hard to learn and you need to have database understanding to work around this tool. Implementing roolback plan is tough on POSTGRESQL.

The best open-source relational-database choice

Jul 01, 2018

Verified Reviewer

Internet, 201-500 employees

Used the software for: 2+ years

Reviewer Source

Source: Capterra

5/5

Overall

4
/
5

Ease of Use

5
/
5

Features & Functionality

5
/
5

Customer Support

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: PostgreSQL implements advanced SQL standards.

It's a great transaction database, which fully implements triggers and functions.

Overall: The best free/open-source object-relational database in the market.

It is an excellent database manager

Jun 20, 2018

Verified Reviewer

51-200 employees

Used the software for: 6-12 months

Reviewer Source

Source: Capterra

5/5

Overall

3
/
5

Ease of Use

4
/
5

Features & Functionality

1
/
5

Customer Support

3
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: He is the most powerful base manager I have ever met, and the best thing about this manager is the storage capacity he has.

Cons: When I have problems or errors with this manager, there is not much documentation to be able to solve the problems and this gives me delays when it comes to working.

Overall: With this manager I have handled most of my databases.

Good data base

May 07, 2018

Luis Raul E.

Co-Founder

Computer Software

Used the software for: 2+ years

Reviewer Source

Source: Capterra

4/5

Overall

4
/
5

Ease of Use

5
/
5

Features & Functionality

3
/
5

Customer Support

3
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: You can have a database with high performance, besides it is an open source technology that is common use with Ruby on Rails, Python or .NET Core

Cons: You need to have some experience to implement it in a production environment or linux server, generally the most common mistake is handle the users.

Overall: I implemented in my own company this database, also I recommend use it

My first experience with SQL many years ago. It was a great tool to learn on.

Aug 01, 2018

Relvin G.

Web Developer

Used the software for: 2+ years

Reviewer Source

Source: Capterra

5/5

Overall

3
/
5

Ease of Use

5
/
5

Features & Functionality

5
/
5

Customer Support

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: it is a great tool for beginners and experts alike to run databases with SQL or learn SQL language with local databases. It is robust, and works fast.

Cons: It has an obvious learning curve for beginners to know about all its quirks and hidden functions. But no other cons that I could find.

Overall: Learned SQL by playing with it and a local DB. Its robust enough to use professionally in large projects.

I consider PostgreSQL like the best open source relational database, it is very robust.

Jun 07, 2017

Howard M.

Research Assistant

Computer Software, 1-10 employees

Used the software for: 2+ years

Source: Capterra

4/5

Overall

4
/
5

Ease of Use

5
/
5

Features & Functionality

3
/
5

Customer Support

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: It has a lot of features and functionalities. It is open source. It has a balanced and clear GUI through pgAdmin

Cons: It is not the database that many language use by default like MySQL, you have to make a couple of additional steps to set the configuration but it worth it.

Overall: Its technical characteristics make it one of the most powerful and robust databases in the market.

Excellent software to create relational data bases

May 02, 2018

Richard E.

Senior Software Development Manager

Used the software for: 2+ years

Reviewer Source

Source: Capterra

4/5

Overall

5
/
5

Ease of Use

4
/
5

Features & Functionality

5
/
5

Customer Support

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: it is free, easy to use, its interface is user friendly and the DBA, it consumes few system resources,

Cons: it is complicated to generate distributed databases, generate a data model graphically, unless you use the enterprise version, if they have a plugin

Overall: a very friendly and simple interface, I use it a lot for government projects and freelance

It is one of the most popular databases

Jul 18, 2018

Susan J. J.

Freelance web developer

Used the software for: 6-12 months

Reviewer Source

Source: Capterra

4/5

Overall

2
/
5

Ease of Use

3
/
5

Features & Functionality

3
/
5

Customer Support

4
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: It allows managing structured and unstructured data. It is full compatible with JSON and is scalable capable of handling terabytes of data

Cons: The documentation is not very extensive. The configuration is a bit confusing and the learning curve is a bit slower than other databases.

is similar to oracle, but low cost with good graphical interface and stability

Apr 30, 2018

María Elena B.

Analista Programador

Used the software for: 1-2 years

Reviewer Source

Source: Capterra

5/5

Overall

4
/
5

Ease of Use

4
/
5

Features & Functionality

5
/
5

Customer Support

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: I like it because its installation is unlimited, it is very economical, it is designed for high volume environments, it has very good graphic design and database management tools, it operates on different platforms such as linux, windows, unix, macOS X and has great storage capacity and good stability.

Cons: at first it is difficult to adapt especially if they are windows users, I recommend using it in linux and the sintaxtis of some of its commands or statements is not intuitive at all.

I used this to create databases in a BI course for about 8 months

May 17, 2018

Nelly R.

Especialista de Proyectos de Desarrollo / Project Specialist

1001-5000 employees

Used the software for: 6-12 months

Reviewer Source

Source: Capterra

4/5

Overall

5
/
5

Ease of Use

4
/
5

Features & Functionality

3
/
5

Customer Support

5
/
5

Value for Money

Pros: The most I like about PostgreSQL is that it's very intuitive, it's easy to create structures (tables, constraints, indexs) and querys thru the graphical query builder that let you relate tables in a graphical envioroment. I like too that is very easy to create a secuence, just set serial type to a field. It's a relational database open source and easy to install. The performance is good, I haven´t had any performance problem using it.

Cons: I have good expiriences using PostgresSql, maybe the only one detail I least like is the syntax error messages, I think could be betther in order to find the problem and fix it.

When I need to use a SQL database, I choose PostgreSQL. None of the others come close to it!

Jul 24, 2018

Alexander C.

Student

Used the software for: 1-2 years

Reviewer Source

Source: Capterra

5/5

Overall

5
/
5

Ease of Use

5
/
5

Features & Functionality

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: I really like that PostgreSQL is open sourced. This makes it so you know that through the many contributions of developers from around the world, PostgreSQL is constantly being improved by developers.

Cons: Unfortunately PostgreSQL's community isn't as big as other SQL databases. Meaning that getting some sort of help from others is a bit harder than one of the larger SQL implementations.

Overall: I use PostgreSQL in many of my personal projects

It is a relational object-oriented database management system, very stable and reliable

Mar 10, 2018

Gilberto G.

Assistant engineer

Civil Engineering, 51-200 employees

Used the software for: 2+ years

Reviewer Source

Source: Capterra

4/5

Overall

4
/
5

Ease of Use

4
/
5

Features & Functionality

2
/
5

Customer Support

4
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: It is a relational object-oriented database management system, very stable and reliable. It has graphic design and database administration tools. There is no cost associated with the software license, it is free. Maintains its speed when handling large amounts of data

Cons: It is a slower system compared to other database management systems in inserts and updates. It does not have online support. It consumes more resources than other systems of its type

Overall: It allows me to handle large amounts of data with simple tools, it is very stable and reliable, There is no cost associated with the software license, it is free

Cons: Coming over from MySQL, some of the CLI could use improvement. It is often difficult to find what commands I need to accomplish tasks

Very easy to use for a Developer's point of view

Apr 11, 2018

Priyabrata S.

Java / iOS Developer

201-500 employees

Used the software for: Less than 6 months

Reviewer Source

Source: Capterra

5/5

Overall

5
/
5

Ease of Use

4
/
5

Features & Functionality

5
/
5

Customer Support

4
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: It support the JSON. With Citus, an open source extension to PostgreSQL, it's now easy to scale out PostgreSQL across multiple nodes and intelligently distribute transactions and SQL queries to get massive parallelism, as well as a much bigger compute, memory, and disk footprint for the database.

Cons: Till have not found anything, except one thing. Sometimes it takes time to run the query. Don't know whether it's because of PostgreSQL or server.

Overall: Very user friendly. Won't take much time if you know SQL. Very useful for a developer.

Postgres is the most effective Open source Database

Dec 04, 2017

Harisha A.

FileNet (ECM) Consultant/Project Lead

Used the software for: 6-12 months

Reviewer Source

Source: Capterra

5/5

Overall

5
/
5

Ease of Use

5
/
5

Features & Functionality

5
/
5

Customer Support

5
/
5

Value for Money

Pros: It's open source. So, its great for startup companies. It is fully SQL compliant. The admin tool PGAdmin is powerful. I am impressed with the custom data types supported by Postgres mainly JSONB.

Cons: We faced problem while using custom data types like JSONB. Inserting data to these type of columns via Hibernate is not straightforward. We referred a couple of articles on that to resolve the issue. https://github.com/thjanssen/HibernateJSONBSupport/tree/master/PostgresJSONB

The best database manager.

Mar 29, 2018

Gregory M.

Developer

Used the software for: 1-2 years

Reviewer Source

Source: Capterra

5/5

Overall

5
/
5

Ease of Use

5
/
5

Features & Functionality

5
/
5

Customer Support

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: It is very powerful and very easy to use, fast and very effective for web development, it is excellent in the implementation of security protocols.

Cons: The only negative opinion that I do not consider a flaw is that it is difficult to start using it for windows users, recommending its use in linux.

good tool

May 13, 2018

Vipallav G.

Team Lead

Computer Software, 1001-5000 employees

Used the software for: 1-2 years

Reviewer Source

Source: Capterra

4/5

Overall

4
/
5

Ease of Use

5
/
5

Features & Functionality

4
/
5

Customer Support

4
/
5

Value for Money

Pros: this tells is reallyu good for managing and stroing relational databases. easily can do query and suports faster indexing.

Cons: cannot search anything from the query resuts. portion of text display is not good .Have to do a lot of scroll to see complete information.

Excellent data manager

May 20, 2018

Verified Reviewer

11-50 employees

Used the software for: 2+ years

Reviewer Source

Source: Capterra

5/5

Overall

5
/
5

Ease of Use

5
/
5

Features & Functionality

3
/
5

Customer Support

3
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: Tool for easy handling of data creation queries, backup and import, I have used it in my java web projects and I have not had any problems so far.

Cons: In the 3 years that I have using postgres I have had no complaints and the interface is simple, easy to use and the response time of this tool has been exceptional

Overall: One of the best data handlers that I have used for applications with a low and high consumption of data transactions.

Nice to start in the world of relational databases.

Mar 28, 2018

Eduardo Manuel R.

Desarrollador de software

Used the software for: 6-12 months

Reviewer Source

Source: Capterra

5/5

Overall

5
/
5

Ease of Use

5
/
5

Features & Functionality

5
/
5

Customer Support

5
/
5

Value for Money

Pros: Free.

It has a large community.

It has an excellent and understandable documentation.

It is very complete, you can create a wide variety of objects available in SQL standards.

Cons: There are many versions that confuse when deciding which is the most convenient to use.

The version of pgAdmin 4 has bugs in the use of memory, and even then, they allow it to download.

postgres is fun to work with databases

May 15, 2018

Verified Reviewer

Used the software for: 6-12 months

Reviewer Source

Source: Capterra

4/5

Overall

3
/
5

Ease of Use

4
/
5

Features & Functionality

5
/
5

Customer Support

3
/
5

Value for Money

Pros: It is light weight

have good indexing

can group our data, sort them and create indexes

follows relational database code rules.

Cons: It have a very basic user interface

searching on this interface cannot be done

for large data the screen takes a lot of time to load the desired data due to lots of scroling

Great DBM with unique features and really great performance for geo-spacial data

Jun 05, 2018

Raul D.

Software Engineer

Used the software for: 6-12 months

Reviewer Source

Source: Capterra

5/5

Overall

4
/
5

Ease of Use

5
/
5

Features & Functionality

3
/
5

Customer Support

4
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: It is free and Open Source. It has a lot of plugins for working with practically all programming languages. It support array type data which is great.

Cons: Front-end side need more improvements in certain features like: Data review, rows limits. It is not to easy for writing store procedures and functions.

powerful, flexible db mgmt

Jul 26, 2018

Randall R.

President

Used the software for: 6-12 months

Reviewer Source

Source: Capterra

4/5

Overall

4
/
5

Ease of Use

5
/
5

Features & Functionality

3
/
5

Customer Support

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: Quality database management tool with expanding functionality and growing community of users. More functionality than MySQL

Cons: Documentation and/or community user support can be a bit spotty for some issues. Fairly steep learning curve as far as setup. Web interface for pgAdmin can be glitchy/slow.

Great Database Managing Software

Aug 13, 2018

Verified Reviewer

Higher Education, Self-employed

Used the software for: 2+ years

Reviewer Source

Source: Capterra

5/5

Overall

4
/
5

Ease of Use

5
/
5

Features & Functionality

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: Easily integrated database manager into other software such as R. I do quite a bit of statistical analysis and having PostgreSQL easily integrated into R is very beneficial

Cons: If I want to import into R I use Linux commands to get my work done. It's not something I have a lot of experience with, but I'm still able to get my work done.

I love Postgres! I would recommend it to anyone!

Dec 07, 2017

Zach L.

Software Engineer

Computer Software, 51-200 employees

Used the software for: Less than 6 months

Reviewer Source

Source: Capterra

5/5

Overall

5
/
5

Ease of Use

5
/
5

Features & Functionality

4
/
5

Customer Support

4
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: I love the ease of the data flow. It is easy to input and easy to read. It makes my life so much easier.

Cons: If they could scale sideways, yet still be a relational database that would be amazing. No one does that though.

Overall: When I use Postgres I am happy. It does what I want, how I want, when I want. You can't get that just anywhere.

perfect for system with low specs

Mar 16, 2018

Shivam G.

Student

Used the software for: 6-12 months

Reviewer Source

Source: Capterra

4/5

Overall

3
/
5

Ease of Use

4
/
5

Features & Functionality

3
/
5

Customer Support

3
/
5

Value for Money

Pros: Fast for system that have low specifications. It is free and open source. Very large community and new versions released frequently. It is a stable product.

Cons: Backup and restore is slow. Very basic ui. habe to remember commands. Clustering is not possible. aggregate functions is slow and tiring.

Very good

May 28, 2018

Verified Reviewer

51-200 employees

Used the software for: 6-12 months

Reviewer Source

Source: Capterra

4/5

Overall

4
/
5

Ease of Use

4
/
5

Features & Functionality

4
/
5

Customer Support

3
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: excellent tool for managing databases, very robust to manage large amounts of data and easy to use for any software development in any language

Cons: the installation of the application is often tedious, the last version must be to be rebooted on low performance hardware

Overall: this software benefits me a lot

Robust and stable

Mar 16, 2018

Aman J.

Student

Used the software for: Less than 6 months

Reviewer Source

Source: Capterra

4/5

Overall

4
/
5

Ease of Use

4
/
5

Features & Functionality

4
/
5

Customer Support

4
/
5

Value for Money

Pros: Easy to use and install. Similar to many sql queries and New user can become well acquantied with it easily, Open source and stable.

Cons: Slower in insertions and deletions.No offline documentation is available. Some commands interpretations is not very implicit and initutuve.

Used in grad level data science courses

Nov 14, 2017

Nick C.

Accounts Payable Specialist

Used the software for: 6-12 months

Reviewer Source

Source: Capterra

5/5

Overall

5
/
5

Ease of Use

5
/
5

Features & Functionality

5
/
5

Customer Support

5
/
5

Value for Money

Pros: PostgreSQL is a good relational database that supports user defined data types.

Really nice/helpgul to have documentation publicly available

Cons: PostgreSQL is not widely used so it can be very difficult to get community support

Replication is harder than with MySQL

PostgreSQL

Sep 11, 2018

Verified Reviewer

Investment Management, 501-1000 employees

Used the software for: 6-12 months

Reviewer Source

Source: Capterra

4/5

Overall

4
/
5

Ease of Use

3
/
5

Features & Functionality

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: As a free software, you really can't be upset with the quality. It allows you to perform all of the functions of any other SQL editor.

Cons: The startup can be a bit wonky. It varies between immediate connection, and taking 10 to 15 minutes to connect.

Great choice for small and medium organizations.

Nov 09, 2017

Raul M.

Business application developer

Computer Software, 501-1000 employees

Used the software for: 6-12 months

Reviewer Source

Source: Capterra

4/5

Overall

4
/
5

Ease of Use

4
/
5

Features & Functionality

4
/
5

Customer Support

4
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: Relatively small memory use, good performance and easy to learn and use. Good price for the package.

Cons: The chance to become private like Mysql and others. It can have a better customer support, the server runs on Linux which is not easy for some people.

good for querying

Apr 19, 2018

Abhishek J.

Student

Used the software for: 6-12 months

Reviewer Source

Source: Capterra

4/5

Overall

4
/
5

Ease of Use

4
/
5

Features & Functionality

4
/
5

Customer Support

4
/
5

Value for Money

Pros: it is fast for queries and works better than its counterparts, Have good features to describe indexes and is easy to use.

Cons: The command line is limited and no much gui tool is available to work with it which makes this limited to command line.

Scalable

Jan 10, 2018

Verified Reviewer

Used the software for: Less than 6 months

Reviewer Source

Source: Capterra

5/5

Overall

5
/
5

Ease of Use

5
/
5

Features & Functionality

5
/
5

Customer Support

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: I use postgresql even in my small projects it's very secure fast and in case I have a big project I can scale it.

Cons: The user system is kind of weird when you compare it to other DBMS, but except that I do not have any big issue with postgresql!

A nice tool for doing basic SQL queries.

Apr 25, 2018

Lori J.

Admin Assistant, Data Analyst

Used the software for: Less than 6 months

Reviewer Source

Source: Capterra

4/5

Overall

4
/
5

Ease of Use

4
/
5

Features & Functionality

3
/
5

Customer Support

5
/
5

Value for Money

Pros: I like the fact that it's free and open source, fairly easy to use, and not too complicated. It's a nice basic SQL software.

Cons: It seems a bit dated and not as user-friendly as other softwares. The interface and design could use some work.

Good structured Database

Jan 15, 2018

Shivakant D.

Technical Consultant

Computer Software

Used the software for: 6-12 months

Reviewer Source

Source: Capterra

4/5

Overall

5
/
5

Ease of Use

4
/
5

Features & Functionality

3
/
5

Customer Support

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: The best part of this DB is it comes in various pack at free and enterprise level, so user can use it's in own way

Cons: Sometimes the installation process feel problem as compare to other existing DB like MSQL, OracleDB.

It is a good DBMS

Apr 24, 2018

Verified Reviewer

Used the software for: 6-12 months

Reviewer Source

Source: Capterra

4/5

Overall

4
/
5

Ease of Use

3
/
5

Features & Functionality

3
/
5

Customer Support

3
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: It has many functions that allow queries to be generated in a very efficient and comfortable way on tables.

Cons: The configuration is not easy since it is a little complex tends to confusions and installation either.

Very compact and stable sql database engine.

Mar 07, 2018

Michael B.

IT Manager

Used the software for: 6-12 months

Reviewer Source

Source: Capterra

4/5

Overall

4
/
5

Ease of Use

4
/
5

Features & Functionality

3
/
5

Customer Support

4
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: It is easy to use and integrates with many other software systems. Quick to setup and learn and has good performance.

Cons: If you do not pay for a support package then you are on your own and have to use forums and help manuals to figure things out.

Robust and dynamic database, wonderful for large companies

Jul 12, 2018

Neyza R.

systems analyst

Used the software for: Less than 6 months

Reviewer Source

Source: Capterra

5/5

Overall

5
/
5

Ease of Use

5
/
5

Features & Functionality

3
/
5

Customer Support

4
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: 1. The syntax is standard and easy to learn.

2. The response speed of the database manager is always the same regardless of the size of the data.

3. it is multiplatform.

4. It works on different platforms such as Linux, Windows, Unix, Solaris and MacOS X.

5. It has enough storage capacity.

Cons: 1. Some experience is required to configure it.

2. It consumes more resources than some database managers.

3. It is not really free as some forums say.

Solution competitive to Microsoft SQL.

May 07, 2018

Verified Reviewer

Computer Software, 51-200 employees

Used the software for: 1-2 years

Reviewer Source

Source: Capterra

3/5

Overall

2
/
5

Ease of Use

3
/
5

Features & Functionality

4
/
5

Value for Money

Pros: After complicated instalation it was easy to use, on internet you can find many hints and guides, no problem with learning new features.

Cons: Tuning performance seems to me as a little complicated and not well managed by vendor. Installation of patches was sometimes terrible.

Good database manager but a bit annoying

Apr 11, 2018

Johameli M.

Pasante

501-1000 employees

Used the software for: Less than 6 months

Reviewer Source

Source: Capterra

4/5

Overall

4
/
5

Ease of Use

5
/
5

Features & Functionality

3
/
5

Customer Support

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: PostgreSQL is a good alternative in the open source database it have options to write functions in Python, Java and C. Inclusive its latest releases it has support for JSON.

Cons: We cannot write our own database engine unlike MySQL, if I don't make this result a lot of errors and it's very very exhausting.

Overall: Postgre It's open source and object relational and is fact that installing it on both a Windows and Linux system is easy and fast.

Ideal for small or even for big project

Mar 23, 2018

Thomas R.

IT admin

Information Technology and Services, 51-200 employees

Used the software for: 6-12 months

Reviewer Source

Source: Capterra

4/5

Overall

2
/
5

Ease of Use

4
/
5

Features & Functionality

3
/
5

Customer Support

5
/
5

Value for Money

Likelihood to Recommend:Not LikelyExtremely Likely

Pros: PostgreSQL software have very big and wonderful community which can fast react to security problems.

There are many companies out there which can help you with installation or configuration.