PostgreSQL Global Development Group

PostgreSQL

4.5 / 5 61 reviews

Who Uses This Software?

All industries, all sectors, all countries


Average Ratings

61 Reviews
  • 4.5 / 5
    Overall
  • 4 / 5
    Ease of Use
  • 4 / 5
    Customer Service

Product Details

  • Starting Price
    Not provided by vendor
  • Free Version
    Yes
  • Deployment
    Cloud, SaaS, Web
    Installed - Mac
    Installed - Windows
  • Training
    No
  • Support
    24/7 (Live Rep)

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.


PostgreSQL Features

  • Backup
  • Creation / Development
  • Data Migration
  • Data Replication
  • Data Search
  • Database Conversion
  • Monitoring
  • Performance Analysis
  • Queries
  • Relational Interface
  • Virtualization
  • Backup
  • Data Migration
  • Database Conversion
  • Monitoring
  • OLAP
  • Performance Analysis
  • Queries
  • Storage Optimization

PostgreSQL Reviews Recently Reviewed!


Excellent database manager

May 14, 2018
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.

good tool

May 13, 2018
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.

The faster open source DBMS

May 13, 2018
5/5
Overall
3 / 5
Ease of Use
5 / 5
Features & Functionality
3 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
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.

Develop and manage different databases thanks to this software

May 10, 2018
5/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
2 / 5
Customer Support
2 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
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.

Solution competitive to Microsoft SQL.

May 07, 2018
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.

Capterra-loader

Good data base

May 07, 2018
4/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
3 / 5
Customer Support
3 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
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

The best relational database

May 04, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
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.

Capterra-loader

Excellent software to create relational data bases

May 02, 2018
4/5
Overall
5 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
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

Capterra-loader

This is one of the database managers that I use for my applications.

May 02, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: Free license, Ideal for Web technologies, easy to Manage, its SQL syntax is standard and easy to learn, quite powerful with proper configuration.
It is cross-platform and has data replication capabilities.

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.

Capterra-loader

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

Apr 30, 2018
5/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
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.

A nice tool for doing basic SQL queries.

Apr 25, 2018
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.

It is a good DBMS

Apr 24, 2018
4/5
Overall
4 / 5
Ease of Use
3 / 5
Features & Functionality
3 / 5
Customer Support
3 / 5
Value for Money
Likelihood to Recommend: 7.0/10 Not
Likely
Extremely
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.

good for querying

Apr 19, 2018
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.

good for queries

Apr 18, 2018
4/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
4 / 5
Customer Support
4 / 5
Value for Money

Pros: for backend it is the best software. It have many new features like jsonb that allows the working with json objects very comfortable.

Cons: This tool is simple ans easy to use but lacks the gui and is purely command based. user have to write everything agin and again and have no data persistence queruies capability

Best DBMS

Apr 17, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
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

Built a whole digitization production line around Postgres.

Apr 16, 2018
5/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
3 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: - Reliability: we experienced some problems during production, absolutely none of them caused by Postgres
- Future-proof: horizontal scalability provided by third-party tools (Postgres-BDR)

Cons: - Hard to roll back on initial design
- 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.

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

Apr 12, 2018
4/5
Overall
3 / 5
Ease of Use
4 / 5
Features & Functionality
3 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
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.

Capterra-loader

Good database manager but a bit annoying

Apr 11, 2018
4/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
3 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 7.0/10 Not
Likely
Extremely
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.

Capterra-loader

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

Apr 11, 2018
5/5
Overall
5 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
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.

Great Database

Mar 31, 2018
5/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
3 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: It's open source, great performance, it has a tool easy to use to manage standard sql queries and access to database

Cons: Sintax for some complex queries is not easy, configuration is not easy and installation either but it's not designed for an enduser

I love it, it's similar to Oracle but free. Very good graphic interface and options.

Mar 29, 2018
4/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: I really like this database manager because it is easy to use, its graphical interface is comfortable, also the commands through the console are very friendly.

Cons: Sometimes the way to search files through the console is annoying, the version of pgadmin 4 is unstable.

Overall: I love this database manager, it's incredible. is my favorite when it comes to choosing one for my university jobs to which I must add databases...

Capterra-loader

The best database manager.

Mar 29, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
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.

Capterra-loader

Nice to start in the world of relational databases.

Mar 28, 2018
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.

My preferred relational sql database

Mar 26, 2018
5/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
4 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: It's the best open source relation database engine that I've used. It's robust, fast, scalable and it gets improvements continually

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.

Ideal for small or even for big project

Mar 23, 2018
4/5
Overall
2 / 5
Ease of Use
4 / 5
Features & Functionality
3 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 7.0/10 Not
Likely
Extremely
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.

Cons: Default configuration is almost unusable for most use cases.
I cannot used to on built-in commands like \d or \g.
Default CLI PostgreSQL query output should be more readable.

Overall: High-Availability and stability.

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

Mar 22, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
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.

Capterra-loader

PostgreSQL free RDBMS.

Mar 22, 2018
4/5
Overall
4 / 5
Ease of Use
3 / 5
Features & Functionality
4 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 7.0/10 Not
Likely
Extremely
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.

Robust and stable

Mar 16, 2018
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.

easy and stable

Mar 16, 2018
5/5
Overall
3 / 5
Ease of Use
4 / 5
Features & Functionality
4 / 5
Customer Support
4 / 5
Value for Money

Pros: This is good for well standarised implemenetation of sql queries. Even complex datatypes like jsona nd arrays can also be provided

Cons: Installation is not easy process. Cluster is not present. Slow operations like count(),sum() become main concern is reliability inspite of speed.

perfect for system with low specs

Mar 16, 2018
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.

Easy to learn and use

Mar 15, 2018
5/5
Overall
5 / 5
Ease of Use
4 / 5
Features & Functionality
4 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: Fast, extremely scalable, in active development, complies with SQL standards, and can handle large GIS data sets with PostGIS.

Cons: Upgrading minor versions is sometimes a pain with the PostGIS extension. We occasionally have to dump and reload the entire database to get things working without losing data.

easy to use and understand

Mar 14, 2018
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 ..

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

Mar 12, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
4 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
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

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

Mar 10, 2018
4/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
2 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
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

Capterra-loader

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

Mar 08, 2018
3/5
Overall
4 / 5
Ease of Use
3 / 5
Features & Functionality
3 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
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.

Most reliable, feature rich RDBMS for Enterprise workloads

Mar 08, 2018
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.

Easily the best cost/performance ratio on the market

Mar 07, 2018
5/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
3 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
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.

Very compact and stable sql database engine.

Mar 07, 2018
4/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
3 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 7.0/10 Not
Likely
Extremely
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.

Capterra-loader

Nice DB Management Tool

Mar 06, 2018
4/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
3 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 7.0/10 Not
Likely
Extremely
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.

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

Mar 05, 2018
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.

Capterra-loader

Good structured Database

Jan 15, 2018
4/5
Overall
5 / 5
Ease of Use
4 / 5
Features & Functionality
3 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
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.

Scalable

Jan 10, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
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!

Open source object-relational database management system for Web Developers

Jan 09, 2018
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.

I love Postgres! I would recommend it to anyone!

Dec 07, 2017
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
4 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
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.

Capterra-loader

Postgres is the most effective Open source Database

Dec 04, 2017
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

Capterra-loader

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

Dec 04, 2017
5/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
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.

Capterra-loader

Great quality of software, very productive

Nov 21, 2017
4/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
3 / 5
Customer Support
3 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
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

Used in grad level data science courses

Nov 14, 2017
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

Capterra-loader

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

Nov 13, 2017
4/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
4 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
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

Great choice for small and medium organizations.

Nov 09, 2017
4/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
4 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
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.

PostgreSQL is te best DBMS out there.

Nov 09, 2017
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
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.

Capterra-loader

Postgres is simple and to the point.

Nov 07, 2017
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
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.

Runs a large database containing a millions of records without breaking

Sep 12, 2017
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money

Pros: I can say that it's really hard to go wrong in recommending PostgreSQL to anyone with even a small amount of technical knowledge.

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

The best software for database administration.

Jul 12, 2017
5/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
4 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
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

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

Jun 07, 2017
5/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
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

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

Jun 07, 2017
4/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
4 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
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

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

Jun 07, 2017
4/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
3 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
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.

Love your relational database again!

Apr 20, 2017
5/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: Easy to install, high performance, hold many kinds of data fields, highly reliable

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

PostgreSQL - Powerful Database with ease of use and portability

Jan 11, 2017
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
4 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: A strong and powerful alternative to many other popular DB's.

Overall: During different database evaluation for a Project, I found "PostgreSQL" to be a strong relational database, what I was looking for an Oracle like DB, to support all the features that are supported by Oracle, here I found that alternates for most of the options available in other DB were available.

Also, the admin features were pretty straight forward and a lot of support was available online which made it even easier to use.

great DB option for SQL based DB seeker

Dec 06, 2016
5/5
Overall
3 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
4 / 5
Value for Money

Comments: Bullet-proof DataBase with big scalability. It's SQL-based so very easy to use and lots of people are familiar with its syntax, yet provides more features than mySQL

Simply the Best RDS

Nov 11, 2016
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money

Comments: if you need a RDS look no further as postgres is simply the best relational database around. its a no brainer. its free and has the best features you could ask for including jsonb and upsert.