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.
2 visitors found this review helpful
2 Comments
author avatarSenior Developer with 501-1,000 employees
Vendor

Ah. It doesn't have a backup feature? Yes it does.http://www.postgresql.org/docs/9.1/static/backup.html

author avatarConsultant at a tech consulting company
TOP 20Consultant

Yes, you have many options for backup.

Check some interesting free ones:

- Barman (www.pgbarman.org).
- Reliable PostgreSQL Backup & Restore http://www.pgbackrest.org
- PgHoard https://github.com/ohmu/pghoard

etc

Guest