IT Central Station is now PeerSpot: Here's why
Buyer's Guide
Open Source Databases
June 2022
Get our free report covering PostgreSQL, Oracle, MariaDB, and other competitors of EDB Postgres Advanced Server. Updated: June 2022.
610,229 professionals have used our research since 2012.

Read reviews of EDB Postgres Advanced Server alternatives and competitors

System/Security Engineer at a tech services company with 10,001+ employees
Real User
Top 5
Free, well-documented, and works very well
Pros and Cons
  • "The main value is that it is open source, which means it is free. Our organization has the initiative to go to open source to cut down on cost. Oracle costs us $6 million a year right now, which is killing us, and Postgres costs nothing. So, there is a big push to go to Postgres."
  • "They need to have a better graphical interface. There is a tool called pgAdmin 4 that they use, which is free. It is written in Java, and it is slow. They need to have a better product that is similar to Toad for Oracle, but, of course, it is hard to get something that's really great and free. Other than that, it is great."

What is our primary use case?

We use it for inventory control.

How has it helped my organization?

We are able to use it on many servers and incur no cost impact, whereas Oracle charges you by the number of cores that are on each individual server, whether you use those cores or not.

What is most valuable?

The main value is that it is open source, which means it is free. Our organization has the initiative to go to open source to cut down on cost. Oracle costs us $6 million a year right now, which is killing us, and Postgres costs nothing. So, there is a big push to go to Postgres.

It is a great product, and it just works. 

What needs improvement?

They need to have a better graphical interface. There is a tool called pgAdmin 4 that they use, which is free. It is written in Java, and it is slow. They need to have a better product that is similar to Toad for Oracle, but, of course, it is hard to get something that's really great and free. Other than that, it is great.

For how long have I used the solution?

I have been using this solution for three years.

What do I think about the stability of the solution?

It is better than Oracle. It is a great product.

What do I think about the scalability of the solution?

It scales horizontally, so it is great. You can do whatever you want with it. We probably have 10,000 users. In terms of their role, they buy products, put them in the inventory, and distribute them.

It is being used quite heavily. The idea is to get rid of Oracle and replace Oracle with Postgres.

How are customer service and support?

It doesn't have any support because it is open source. They provide you with the documentation that's free, and you get everything except help. You're on your own, which is okay. I and one other person came up to speed on this, and we're basically the subject matter experts (SMEs).

EnterpriseDB (EDB) is a company that provides technical support, but we decided not to do that.

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

We used Oracle. We're currently in the process of migrating from Oracle to Postgres, and we're doing it because of cost.

Postgres is a superior product, and it is free. Oracle's support is really terrible, so you're not really getting any support from Oracle.

How was the initial setup?

It was very straightforward and easy. It is very well documented.

We can deploy a server in about three or four hours. We use a primary and a standby server, so we have two servers in the cluster.

What about the implementation team?

My partner and I read the books and then just did it. I am on the development side. They get the new products in, and I and this other person evaluate them and learn them. We probably have three people in operations who are handling Postgres on the production side.

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

It is free. In terms of operating costs, it basically needs the same platform on which Oracle runs.

Which other solutions did I evaluate?

We evaluated EnterpriseDB (EDB) Postgres, which is a paid product, whereas Postgres is open source. We decided that it was better to go with a free product.

What other advice do I have?

I would absolutely recommend this solution if you're concerned about cost. It seems easy and straightforward.

I would rate it a 10 out of 10. It is really great. It works amazingly well.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
Buyer's Guide
Open Source Databases
June 2022
Get our free report covering PostgreSQL, Oracle, MariaDB, and other competitors of EDB Postgres Advanced Server. Updated: June 2022.
610,229 professionals have used our research since 2012.