PostgreSQL Review

It is stable, and easy to use but lacks a backup feature.

What is most valuable?

The use of extensions for integration with different databases is valuable.

How has it helped my organization?

Our organization has MySQL, Oracle, PostgreSQL and flat files in our processes, and the use of extensions has facilitated the integration between these processes. Also, it's only 7-8/10 when comparing it to an Oracle database.

What needs improvement?

The use of XQuery besides XPath into PostgreSQL. It would also be nice for them to add some backup features similar to the one that Oracle Recovery Manager has. Also, a tool to query archive files would be a nice addition, and being able to change the execution plan through hints like we do in Oracle. There are some more but these would be my favorite ones.

For how long have I used the solution?

I've got six years experience with PostgreSQL, and 18 with Oracle.

What was my experience with deployment of the solution?

No issues encountered.

What do I think about the stability of the solution?

No issues encountered.

What do I think about the scalability of the solution?

No issues encountered.

How are customer service and technical support?

Customer Service:

I'd rate it as 10/10 as an open source product with an active community.

Technical Support:

I'd say it's good.

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

We initially only used an Oracle database, but we decided to add PostgreSQL as an option because of its similarity to Oracle. Also, it's free and is the best open source database.

How was the initial setup?

It is simple, especially when you know the main components of a database.

What about the implementation team?

We implemented it in-house.

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

We didn't have any setup costs because it is free.

Which other solutions did I evaluate?

  • MySQL
  • SQL Server
  • Sedna XML

What other advice do I have?

I'd say go for it. It is stable, and easy to use but you should get an understanding of it to implement backup strategy.

**Disclosure: I am a real user, and this review is based on my own experience and opinions.
More PostgreSQL reviews from users
...who work at a Comms Service Provider
...who compared it with MySQL
Learn what your peers think about PostgreSQL. Get advice and tips from experienced pros sharing their opinions. Updated: May 2021.
510,882 professionals have used our research since 2012.
Add a Comment
ITCS user

author avatarit_user86943 (Senior Developer with 501-1,000 employees)

Ah. It doesn't have a backup feature? Yes it does.

author avatarit_user140712 (Consultant at a tech consulting company)

Yes, you have many options for backup.

Check some interesting free ones:

- Barman (
- Reliable PostgreSQL Backup & Restore
- PgHoard