Skip to main content
TrustRadius
PostgreSQL

PostgreSQL

Overview

What is PostgreSQL?

PostgreSQL (alternately Postgres) is a free and open source object-relational database system boasting over 30 years of active development, reliability, feature robustness, and performance. It supports SQL and is designed to support various workloads flexibly.

Read more
Recent Reviews

TrustRadius Insights

PostgreSQL has a wide range of use cases across various industries and organizations. It is commonly used as a primary data storage …
Continue reading

Professional and Free

8 out of 10
May 14, 2021
Incentivized
PostgreSQL open source relational data management system takes on a task behind a critical and important application running in our …
Continue reading
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Return to navigation

Product Demos

PostgreSQL for Beginners - Demos on pgbouncer

YouTube

PostgreSQL demo with CPP on Ubuntu Linux

YouTube

Spring Boot + Vue.js example | Spring Data JPA + REST + PostgreSQL CRUD Demo

YouTube

ASP.Net Core Web API con Docker Compose, PostgreSQL y EF Core

YouTube

Demo: Replicating Oracle Database to PostgreSQL - TechXperts

YouTube

postgresql conf demo

YouTube
Return to navigation

Product Details

What is PostgreSQL?

PostgreSQL Video

What is PostgreSQL?

PostgreSQL Integrations

PostgreSQL Technical Details

Operating SystemsUnspecified
Mobile ApplicationNo

Frequently Asked Questions

PostgreSQL (alternately Postgres) is a free and open source object-relational database system boasting over 30 years of active development, reliability, feature robustness, and performance. It supports SQL and is designed to support various workloads flexibly.

Reviewers rate Support Rating highest, with a score of 9.3.

The most common users of PostgreSQL are from Mid-sized Companies (51-1,000 employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(324)

Community Insights

TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!

PostgreSQL has a wide range of use cases across various industries and organizations. It is commonly used as a primary data storage solution for traditional relational data in customer-facing systems, serving as a reliable and scalable option. Additionally, PostgreSQL is utilized as a NoSQL data store with JSON and JSONB data types, offering flexibility and versatility for developers. Users appreciate its near-complete ANSI SQL language implementation, making it handy for data extraction and analytics. PostgreSQL is also valued for its ease of integration or migration with AWS Redshift, enabling seamless data transfer between platforms. Moreover, it serves as a dedicated and per-application data storage engine, catering to the diverse needs of different business units. Whether it's for data analytics, reporting, ad-hoc data storage and retrieval, or building high-traffic API services, PostgreSQL proves to be a stable and cost-effective solution for various use cases.

Reliability and Performance: Users have consistently praised PostgreSQL for its reliability and performance, with many reviewers stating that they have experienced no downtime or issues related to the database. Some users also mentioned that PostgreSQL's performance is exceptionally fast, providing them with great speed in their operations.

Ease of Use and Flexibility: Many users find PostgreSQL easy to use and appreciate the availability of good open-source tools to work with it. Reviewers have highlighted that constructing queries in PostgreSQL is straightforward and that it integrates well with all development languages, making migration easy. The flexibility of PostgreSQL's user/role management system has also been praised by users, as it allows for easy control over access to tables.

Wide Industry Adoption and Community Support: Several reviewers acknowledge that PostgreSQL has achieved wide industry adoption, making it easier to integrate into a stack and hire knowledgeable developers. The availability of a huge online community for support was highly appreciated by users. Additionally, many users mentioned the extensive documentation available for PostgreSQL, along with the ease of finding examples, which further contributes to community support.

Complicated Installation and Setup: Many users have found the installation and setup process of PostgreSQL to be complicated, especially for Mac users. They have mentioned the need to learn new commands and have recommended blog posts for guidance.

Difficult Syntax of SQL: Users have expressed difficulty in understanding the syntax of SQL in PostgreSQL, which they find different and hard to grasp. This may be a reason why the software is not widely adopted.

Lack of Clear Benefits: Users have mentioned the lack of clear benefits for choosing PostgreSQL over other products. They feel that there are better alternatives available with more extensive features, documentation, and community support.

Based on user reviews, PostgreSQL is recommended for its ease of use, fast execution, and compatibility with other PostgreSQL users. Users also find its functionality, friendly SQL operations, and good GUI feature beneficial. It is suggested as an alternative to other complex query language platforms.

Reviewers highly recommend PostgreSQL for its scalability, robustness, and reliability. They believe it is the best relational database with great popularity among developers. It is suggested for work, learning, career purposes, as well as small and medium development projects. Users also mention its suitability for incremental development and cost reduction.

PostgreSQL is praised as a world-class and free database with a vibrant community that provides great support. Reviewers recommend it for its cost-effectiveness and suitability as a free relational database. It is suggested as the default database choice for developers, including testing and staging environments. The growing community around PostgreSQL is seen as an advantage.

Other notable recommendations include the speed, security, and reliability of PostgreSQL. It is considered suitable for querying large amounts of data and prioritizing security. Users emphasize the importance of familiarizing oneself with SQL, utilizing the documentation, and keeping up with the latest versions of PostgreSQL. They suggest having database experts on the team for production use.

Additionally, users suggest using PostgreSQL for lightweight installations, optimal database management, building reporting engines, data analysis with good security features at an affordable price, and implementation in systems with array support.

Some users request improvements such as easier configuration processes for Windows users or adding real-time database support or developing another database app. Online resources are recommended for training and support when learning PostgreSQL.

Overall, users find PostgreSQL to be a complete and easily accessible database system with multi-version concurrency support that offers a reliable solution for various needs.

Attribute Ratings

Reviews

(1-25 of 53)
Companies can't remove reviews or game the system. Here's why
vijay bhopalwani | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
PostgreSQL is an Open Source Database that is used for mainly Relational database Systems. We are mainly using this database because of the microservice structure. And in microservices, we have a lot of databases and also it's open source so that is good for our organization. And it's an object-relational database the performance of the database is pretty good.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We use postgreSQL in instances where we need an isolated database to support a microservice architecture, or an isolated system. It allows us to leverage a simple and inexpensive database option where a larger scale enterprise configuration would be over engineering. We commonly use it for build automation systems in our organization.
Aurpa Fiza | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
PostgreSQL is the most advanced and versatile DB system available and is well documented. It’s cool, and there is a lot of diversity among the people who help with it. PostgreSQL has a project (phAdmin) that allows us to carry out tasks using a friendly graphical user interface, making it an incredible database manager. It has a command-line interface for Linux and Windows that is simple to use. In addition, Golang and Python and their frameworks, such as Django for Python, can be integrated. A comprehensive documentation website makes learning about all of its features easy.
June 22, 2021

PostgreSQL Review

Anson Abraham | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Using PostgreSQL in all aspects of the company. Using it for our front-end platform to display data. Using PostgreSQL as part of our pipeline looking up reference data. Also using it for reporting purposes as well. The data we have is structured, but with some unstructured data, the jsonb datatype support, also helps us considerably to store dynamic data generation. Helps us scale out our platform.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We are using PostgreSQL as a database for our microservices application. Since microservice is light by nature, performance is never a problem.
We have a lot of microservices applications since PostgreSQL is free, we could use as many database instances as we need without massive cost increase.
The main thing that we like is PostgreSQL supports the JSON column and query which is really useful in our use case.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
PostgreSQL database is being used across the whole organization by different departments for different services/micro-services. It addresses one important business problem that is cost. We migrated from Oracle to PostgreSQL to save license cost without compromising on RDBMS requirements.
Erlon Sousa Pinheiro | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Currently, we are using PostgreSQL to support some DevOps operations, mainly related to monitoring (as a Zabbix database server) and configuration management (it is the database used by our Puppet/PuppetDB environment). We use it as a regular deployment as well as a Database as a service (on AWS RDS).
Moris Mendez | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
In our department PostgreSQL is used as the main database that supports our transactional systems, reaching a consensus for the use of a single database throughout the organization requires a joint effort that leads to a feasibility study and implementation that determine the best way forward to unify the use of a single database platform.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
PostgreSQL is one of the databases we use for our systems and products. Most of our IT systems run on PostgreSQL, such as issue tracker and wiki. We also use PostgreSQL to store analytic data which would then be fed to analytic and reporting tools to generate graphs and dashboards.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We use Postgres for a variety of applications, from high availability/high traffic API services to simpler CRUD style single-page applications. It fulfills a need for a low-cost relational data store that has been tested and proven to work. Its use of common SQL is known by many engineers so the learning curve is very low.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Postgre[SQL] is awesome, as it ha[s] lots of distinct things in itself. It is [a] highly extensible object relation database. We are using this for our current applications like Virtual Class and StudyShot purposes. We are storing larger pools of servers for virtual class purposes, which uses Postgre[SQL] as backend server. These applications are organization-wide products. Overall, Postgre[SQL] is superb in larger queries, where it is solving our day-to-day business problems in complex programs. Its performance and security both are satisfactory. Postgre[SQL] have features to extend which is a very good [quality].

It [is] platform independent, so we need not to worry about [having a] specific environment. Very good support for replication also relieves us from [the] data lost burden. Its cost for owning and maintaining [in] comparison to SQL server is low so it [suits us well].
Score 8 out of 10
Vetted Review
Verified User
Incentivized
PostgreSQL open source relational data management system takes on a task behind a critical and important application running in our information systems infrastructure. Although we did not like the use of a separate model database for this application because it was different and critical at first, we are very pleased at the moment, it was unnecessary to hesitate.
Valeri Karpov | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
We've used PostgreSQL for years as a tool for our data team. We use MongoDB for operational data, but we pipe MongoDB data into Postgres. If we need a chart for an investor deck or someone has a non-trivial data question, our data team queries Postgres.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
At my current organization, we use PostgreSQL to obtain the most current data of our host system.
This is used by the IT department only, with data obtained from it distributed organizational wide. It allows us to obtain real-time data from our host system, rather than an overnight "batch" load of data.
Mark Mitchell | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
PostgreSQL is currently at the core of everything we do. For our organization we knew that we needed a durable, feature rich and flexible database. We have various storage needs including traditional relational setups with auditing for our quoting and invoicing. Inherited structures for project standards that can adapt as needed. And dynamic JSON based data for unstructured data. With PostgreSQL there hasn't been a data problem we have not been able to solve. It allows us to collect flexible data and migrate it into structured data sets that can be utilized with traditional tooling.
Adolfo Maltez | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
The use of PostgreSQL in our organization has allowed us to scale the number of implementations without worrying about costs associated with licenses.
We use PostgreSQLl for a variety of transactional systems, from remote sites to headquarters.
It allows us to standardize configurations and implementations throughout the organization, accelerating the number of implementations.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We use PostgreSQL as our solutions database, we looked for a full featured database server that will be both reliable, with high performance and supported on our Linux CentOS based platforms. We preferred Open Source solutions as we did not want to increase our solution price.
Highnet Systems' SNS++ Notification Management solution is sold on license on premise solution, as such the customer need platform (Hardware or virtual server), Operating System, Database Server, WEB Server and finality our software. by selecting Open Source platforms we are able to provide our customer with great enterprise level solution at very small cost.
PostgreSQL give us great performance supporting organizations with millions of alerts per day, with complex alert handling solutions. We started using PostgreSQL more than 15 years ago and it is still great solution, with wide industry support, easy management and development tools and because we provide our solutions to big organizations it helps to relay on platform like PostgreSQL that is constantly developed to face both new demands, environments and security risks.
Paul De Audney | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
PostgreSQL is used across a wide number of systems. Ranging from customer-facing primary data storage of traditional relational data to using it more like a NoSQL data store with the JSON & JSONB data types. Analytical workloads in some parts of the business are serviced by PostgreSQL as well.
Don Burks | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
PostgreSQL is the primary datastore for Sphere. All of the mission-critical customer and product data which underpins the product offering is there. PostgreSQL was the right choice because so many of the data models that we use are relational to the customer's user account,.
Vladimir Salnikov | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
I've used PostgreSQL for managing the database for agriculture support system with elements of spatial analysis by PostGIS extension. This was an internal software (not intended for public markets), used by agronomists, management, and shareholders of agricultural holdings in South Russia, Volgograd region. The database includes records about crop rotations, vegetation indices, field observation data, weather data, etc. By this info, used in analytic to achieve better productivity and reduce expenses for common field works, used to grow bulk crops, such as wheat, corn, and sunflower.
Javier Blanque | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
PostgreSQL is used in several Departmental Information Systems across the Bank, from open source systems which operates with the DBMS to in-house developed systems like the one we use for Operational and Technology Risk Assessment, and Asset Management.
We use other DBMSs like MySQL (MariaDB) and Microsoft SQL Server also, so we can compare them against each other.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We in the software engineering department use Postgres to permanently store most of our customer's information that is needed by the app--anywhere from their settings, login information (of course user's passwords are encrypted and salted), to the work they've created in the app. The web app writes to Postgres whenever our users need to update their info and saves their work and reads from the app to display the webpages. What's cool is that Postgres also has great user management, so we also gave read-only access to only a few parts of the database for the finance department who want to know how much the users are using the app to charge them accurately, and also to customer support who wants to see user data in order to help users debug issues.
Balázs Kiss | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
As a company that does a lot of consultation work in software development and database and system administrating on high levels, knowing multiple RDBMS's is essential. PostgreSQL is often required by our partners, and we use it from time to time when the business choice lands on it. Most of the time we like to work with Oracle tools, but PostgreSQL proved itself to be a viable alternative for many use cases.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
It is our primary database engine utilized in the capture, storage, and processing of all company data. We were facing massive licensing fees and large deployment times in order to deploy Microsoft SQL Server at scale. We opted instead to deploy PostgreSQL in replicated pairs (50+ and growing) in a matter of minutes! We were delighted with the ease of use and replication abilities, not to mention the amazing performance.
Return to navigation