Try our new research platform with insights from 80,000+ expert users
reviewer1442025 - PeerSpot reviewer
Senior Database Administrator Engineer at a comms service provider with 10,001+ employees
Real User
Easy to install, easy to manage, and free
Pros and Cons
  • "It is easy to install and easy to manage. There is no license on it, so it is free. There is high compatibility with Oracle, and there are many tools for the migration of data from Oracle to Postgre."
  • "It still needs to be more mature and have some backup feature. We are normally dealing with Oracle's data, and we have very strong online tools to back up the data and do other things. PostgreSQL still needs to do more in this area as well as in the high availability area. There are many external tools that you can use for PostgreSQL's high availability, but there is no embedded tool within PostgreSQL for high availability. It could have a feature similar to Oracle for working on a distributed system. It can have some scripts to improve the monitoring and some tools to do performance analysis. We have a workaround for most of such requirements except for the support for a distributed system, which is very difficult to have. This area should be included in the core of the database itself."

What is our primary use case?

One use case is that we installed it and built it for a customer so that he has access to the database, and he can create whatever he would like to create on it. 

We have deployed it on-premises and in the cloud.

What is most valuable?

It is easy to install and easy to manage. There is no license on it, so it is free. 

There is high compatibility with Oracle, and there are many tools for the migration of data from Oracle to Postgre. 

What needs improvement?

It still needs to be more mature and have some backup feature. We are normally dealing with Oracle's data, and we have very strong online tools to back up the data and do other things. PostgreSQL still needs to do more in this area as well as in the high availability area. There are many external tools that you can use for PostgreSQL's high availability, but there is no embedded tool within PostgreSQL for high availability.

It could have a feature similar to Oracle for working on a distributed system. It can have some scripts to improve the monitoring and some tools to do performance analysis. We have a workaround for most of such requirements except for the support for a distributed system, which is very difficult to have. This area should be included in the core of the database itself. 

For how long have I used the solution?

I have been using this solution for almost one year.

Buyer's Guide
PostgreSQL
May 2025
Learn what your peers think about PostgreSQL. Get advice and tips from experienced pros sharing their opinions. Updated: May 2025.
856,873 professionals have used our research since 2012.

What do I think about the stability of the solution?

I didn't have any issues, but I think Oracle is more stable.

What do I think about the scalability of the solution?

I didn't have experience with that because we didn't make any changes since we built it. All I have is one server, and I can only have one standby, nothing more. 

How are customer service and support?

We didn't contact them. We didn't face any serious issues that required support.

Which solution did I use previously and why did I switch?

I am also using Oracle Database. The main difference is the scalability. PostgreSQL could be used for small to medium databases but not for a huge production database. I still prefer to have Oracle Database.

How was the initial setup?

The initial setup was straightforward. It did not take too long. It took maybe one hour to do the installation.

What's my experience with pricing, setup cost, and licensing?

It is free. There is no license on it.

What other advice do I have?

Go ahead and implement it. It is a nice product, but keep a backup and try to use it for small to medium projects or companies. Some of the customers are demanding PostgreSQL nowadays, so we will keep on implementing it.

I would rate PostgreSQL an eight out of ten.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer938901 - PeerSpot reviewer
Software Engineer at a computer software company with 10,001+ employees
Real User
Easy to manage, scalable, and stable database system, but needs improvement from a security point of view
Pros and Cons
  • "Scalable, stable, and easy to manage database system, with a straightforward installation."
  • "PostgreSQL is a stable system, but from a security point of view, it still needs improvement."

What is our primary use case?

We use PostgreSQL as a database, e.g. it's where we install the application. We also use it for all types of batch processing, and it also has the batch sequencing engine. We use it for everything, e.g. everything's right there in the database.

What is most valuable?

What I like most about PostgreSQL is its ease of management.

What needs improvement?

They should make PostgreSQL more secure. It's stable, but from a security point of view, it still needs improvement.

For how long have I used the solution?

It's been a few years since I started using PostgreSQL.

What do I think about the stability of the solution?

PostgreSQL is a stable solution. It's also very easy to manage.

What do I think about the scalability of the solution?

PostgreSQL is scalable.

How was the initial setup?

Installing PostgreSQL was straightforward. There were just a few parameters I needed to get through, then the process became straightforward. I was able to do the installation myself.

What about the implementation team?

I did the implementation of PostgreSQL myself, and did not need a vendor or technical team to help me.

What other advice do I have?

PostgreSQL is for personal use, e.g. I've been using it for my applications. It's deployed on cloud.

I'm not from the core database team, so whatever features are currently provided by this solution, I'm happy with them, e.g. PostgreSQL is fulfilling my needs. Our database administrators will be able to provide more information on areas for improvement for this solution, because they know all the ins and outs of the database. I'm using this for my application, and I have not faced any issues with it.

I'm part of a global company, and in our team, we keep recommending PostgreSQL to our client, but increasing the usage of this solution depends on the client, e.g. the one who pays.

We have more than 200,000 users of PostgreSQL.

In my project, I don't need a technical team for the deployment and maintenance of this solution, e.g. I can do it myself, but for other projects, deployment and maintenance could be handled by database administrators.

On a scale from one to ten, I'll rate PostgreSQL seven out of ten.

Which deployment model are you using for this solution?

Public Cloud
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Buyer's Guide
PostgreSQL
May 2025
Learn what your peers think about PostgreSQL. Get advice and tips from experienced pros sharing their opinions. Updated: May 2025.
856,873 professionals have used our research since 2012.
Sundaresan Subramanyan - PeerSpot reviewer
Founder and Managing Director at Analytic Brains Technologies Private Limited
Real User
Open source solution that supports more than one SQL language and improves with each upgrade
Pros and Cons
  • "This is an open-source solution, operates at a high speed, and supports more than one SQL language."

    What is most valuable?

    This is an open-source solution, operates at a high speed, and supports more than one SQL language.

    It integrates with different platforms, the upgrades are quite fast and the solution keeps getting better. 

    What needs improvement?

    This solution could be better integrated with other systems. 

    For how long have I used the solution?

    I have used this solution for four years. 

    What do I think about the stability of the solution?

    This is a stable solution. 

    What do I think about the scalability of the solution?

    This is a scalable solution.

    How are customer service and support?

    We have not needed much help from the customer service team. When we have had questions, we have found the answers on Google. 

    Which solution did I use previously and why did I switch?

    We previously used Microsoft SQL.

    How was the initial setup?

    The initial setup is straightforward and took less than one day. 

    What's my experience with pricing, setup cost, and licensing?

    This is an open-source solution and there is no need to pay for a license.

    What other advice do I have?

    We recommend PostgreSQL for our customers who want an open-source solution.

    I would rate this solution an eight out of ten. 

    Which deployment model are you using for this solution?

    On-premises
    Disclosure: My company does not have a business relationship with this vendor other than being a customer.
    PeerSpot user
    Projects Manager at Emery Investments
    Real User
    Stable, open-source solution that makes scaling a database affordable; could be more user-friendly
    Pros and Cons
    • "It is very scalable and comes with a bonus: no licensing issues as you scale with your databases."
    • "As PostgreSQL is an open-source product, you do have to do a bit more configuration and management yourself."

    What is our primary use case?

    Our primary use case for PostgreSQL is data storage. 

    What needs improvement?

    As PostgreSQL is an open-source product, you do have to do a bit more configuration and management yourself. I would like to see it become more user-friendly. 

    For how long have I used the solution?

    I do not use PostgreSQL regularly but I have been running a project that has been utilizing it for six years. I head a tight-knit group that includes a front end developer, backend developers, and hardware people. They deal with PostgreSQL and I do not have hands-on experience with this solution. 

    What do I think about the stability of the solution?

    PostgreSQL is stable and easy to use. 

    What do I think about the scalability of the solution?

    It is very scalable and comes with a bonus: no licensing issues as you scale with your databases. 

    Currently, 15 people use PostgreSQL at our organization. 

    How are customer service and support?

    I am satisfied with PostgreSQL's technical support. 

    How was the initial setup?

    The initial deployment was fine. If you read through the steps, you should be OK. 

    What's my experience with pricing, setup cost, and licensing?

    The licensing is fine. It is not a paid database license. 

    Disclosure: My company does not have a business relationship with this vendor other than being a customer.
    PeerSpot user
    reviewer1734405 - PeerSpot reviewer
    Head Channel and Capacity at a computer software company with 201-500 employees
    Real User
    Stable, scalable, helpful community support
    Pros and Cons
    • "The solution is scalable, it is very good."
    • "PostgreSQL could improve by adding data warehousing tools."

    What is our primary use case?

    We deployed the Postgre database on CentOS, which is a version of Linux. We have experimented with our replication and other operations. It works perfectly well. We are using the open-source version and do not plan on using any enterprise database.

    What needs improvement?

    PostgreSQL could improve by adding data warehousing tools.

    For how long have I used the solution?

    I have been using PostgreSQL for approximately eight years.

    What do I think about the stability of the solution?

    PostgreSQL is stable.

    What do I think about the scalability of the solution?

    The solution is scalable, it is very good.

    We have approximately 100 users using this solution.

    How are customer service and support?

    There is a lot of community support online to help with many things, such as updates. The online support is very active.

    How was the initial setup?

    The installation is straightforward and simple, it took only half an hour.

    What about the implementation team?

    We did the implementation through an in-house IT engineer.

    We have a team of approximately five engineers that manage the solution.

    What's my experience with pricing, setup cost, and licensing?

    We are using the free version of PostgreSQL.

    What other advice do I have?

    I would recommend this solution to others.

    I rate PostgreSQL a nine out of ten.

    Disclosure: My company does not have a business relationship with this vendor other than being a customer.
    PeerSpot user
    Software Architect at AIOPS group
    Real User
    Top 5Leaderboard
    Stable and scalable but needs better integration
    Pros and Cons
    • "Initial setup is simple."
    • "Integration with other platforms could be improved."

    What is most valuable?

    This solution is very good and efficient in joining big tables. It also provides a lot of options that, from a developer's point of view, can be utilized in a project. 

    What needs improvement?

    In the next release, I would like to see better integration with other platforms.

    For how long have I used the solution?

    I've been using this solution for about three and a half years.

    What do I think about the stability of the solution?

    This solution is stable - I'm not aware of any performance issues.

    What do I think about the scalability of the solution?

    This is a scalable solution.

    How was the initial setup?

    The initial setup is simple - you are only required to download the installation files, which takes just a few minutes.

    What other advice do I have?

    I would rate this solution as seven out of ten.

    Which deployment model are you using for this solution?

    Private Cloud

    If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

    Amazon Web Services (AWS)
    Disclosure: My company does not have a business relationship with this vendor other than being a customer.
    PeerSpot user
    Ruben Conti - PeerSpot reviewer
    Owner at Intersoftware sas
    Real User
    Top 10
    Available, stable and reliable
    Pros and Cons
    • "PostgreSQL is stable. It's available, stable, and reliable."
    • "There are several features I would like to improve that aren't working as expected. It's likely that the latest version is doing something that was missed in the previous versions. For example, the output parameters — the stored procedures — is something new in PostgreSQL that Firebird has already had for a long time."

    What is our primary use case?

    We use PostgreSQL as a database for our ERP system.

    What needs improvement?

    There are several features I would like to improve that aren't working as expected. It's likely that the latest version is doing something that was missed in the previous versions. For example, the output parameters — the stored procedures — is something new in PostgreSQL that Firebird has already had for a long time. We haven't tried the latest version, but they're supposed to add some of the most important things.

    For how long have I used the solution?

    I've been using PostgreSQL for nearly 20 years.

    What do I think about the stability of the solution?

    PostgreSQL is stable. It's available, stable, and reliable.

    How was the initial setup?

    Installing PostgreSQL is not so easy, and the installation takes about one day.

    What other advice do I have?

    I rate PostgreSQL eight out of 10. I would definitely recommend it.

    Which deployment model are you using for this solution?

    On-premises
    Disclosure: My company does not have a business relationship with this vendor other than being a customer.
    PeerSpot user
    reviewer1524594 - PeerSpot reviewer
    Senior Solutions Architect at a manufacturing company with 51-200 employees
    Real User
    Familiar to other solutions, stable, but not use-friendly
    Pros and Cons
    • "The PostgreSQL database is similar to the SQL Server but has a slightly different technology that has similar resources as well. If the customer has the confidence using SQL Server, they will be fairly comfortable using this solution."
    • "PostgreSQL could improve by being more user-friendly. In SQL Server they have a studio where you can easily do management but not in this solution."

    What is our primary use case?

    We use this solution for the back-end database.

    What is most valuable?

    The PostgreSQL database is similar to the SQL Server but has a slightly different technology that has similar resources as well. If the customer has the confidence using SQL Server, they will be fairly comfortable using this solution.

    What needs improvement?

    PostgreSQL could improve by being more user-friendly. In SQL Server they have a studio where you can easily do management but not in this solution. 

    For how long have I used the solution?

    I have been using PostgreSQL within the past 12 months.

    What do I think about the stability of the solution?

    I have found the solution stable.

    What do I think about the scalability of the solution?

    The solution is scalable but it could improve.

    We have approximately 10 users using this solution in my organization.

    How are customer service and technical support?

    We are using the open-source version for eight years. We have to rely on our own skillset to manage it.

    How was the initial setup?

    The installation is easy.

    What about the implementation team?

    We did the implementation ourselves but it is always recommended to use an expert.

    What's my experience with pricing, setup cost, and licensing?

    This solution can offer a cheaper choice for customers since it is open-source.

    Which other solutions did I evaluate?

    I have evaluated SQL Server.

    What other advice do I have?

    If you have a startup company with a normal production environment then this PostgreSQL should be fine. However, if there is a professional environment where there will be some support requirements and mission-critical applications, then they should choose an alternative, such as SQL Server.

    I would recommend this solution to others.

    I rate PostgreSQLa seven out of ten.

    Which deployment model are you using for this solution?

    On-premises
    Disclosure: My company does not have a business relationship with this vendor other than being a customer.
    PeerSpot user