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


Valuable Features

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

Improvements to 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.

Room for 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.

Use of Solution

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

Deployment Issues

No issues encountered.

Stability Issues

No issues encountered.

Scalability Issues

No issues encountered.

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.

Previous Solutions

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.

Initial Setup

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

Implementation Team

We implemented it in-house.

Pricing, Setup Cost and Licensing

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

Other Solutions Considered

  • MySQL
  • SQL Server
  • Sedna XML

Other Advice

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

it_user86943Real User

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

15 May 16
Tomaž BorštnarReal UserTOP 20LEADERBOARD

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

19 May 16
Guest
Why do you like it?

Sign Up with Email