Community insights

TrustRadius Insights for EDB Postgres Advanced Server are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.

Pros

Easy Setup and Management: Many users have found EDB Advance Server to be easy to set up and manage, with some stating that it was a breeze to migrate from Oracle. Users also praised its ability to support complex architectures with high availability, making it convenient for their needs.

Excellent Customer Support: Several users appreciated the support system provided by EDB, mentioning that their tickets were responded to almost instantly every time. They found the customer service to be responsive and reliable.

Cost-effective and Open Source: Users liked that EDB Postgres Server is open source and readily available for use. They mentioned that it is cheaper than most other database servers in the market, providing good value for the price.

Reviews

2 Reviews

Robust and Somewhat Daunting But Worth the Effort

Rating: 10 out of 10

Incentivized

May 17, 2017

Use Cases and Deployment Scope

We built a software service for online education providing metadata about courses offered ranging from MOOCs to private vendors. This entire service architecture ran on a PostgreSQL backend which required monitoring, optimization, replication, and other features to maintain service level agreements with the consumers of our service, which was intended for web and mobile clients. We used Apache Solr integrated with the PostgreSQL back end and needed advanced monitoring and optimization to ensure blazing fast searches. Postgres Plus Advanced Server gave us the suite of tools we needed including the ability to easily hook in from the client language of our choice as well as manage, optimize and maintain the utmost security in our database platform.

Pros

Developer tools including debugging, JSON and XML support, libraries for preferred languages and good examples all facilitated integration and development. Robust features for developers.
Security is top notch and supports far beyond what we required for our project, which is a good thing.
Performance, throttling, monitoring and optimization are all top notch and helped us keep response times low and save on bandwidth and hosting costs.

Cons

Documentation is excellent but spread out across many resources and can take a while to wade through—would benefit from having more intro level, getting started guides for various languages.
Ruby support is excellent but more Ruby examples and beginner-level documentation would be nice.
It is sometimes hard to find a community of users on StackOverflow so a larger community, and a dedicated forum with active members to answer questions and work through issues would be nice.

Likelihood to Recommend

It's great if you are using or wish to use PostgreSQL and need the added performance optimization, security features and developer and DBA tools. If you need compatibility with Oracle it's a must-have. There are many developer features that greatly assist dev teams in integrating and implementing complex middleware. It's great for optimizing complex database queries as well as for scaling. I would recommend Postgres Plus Advanced Server for any software development team that is hitting the limit of what PostgreSQL is capable of and wants to improve performance, security, and gain extra developer tools.

Jonah Dempcy

Web & Mobile Developer in Engineering at Bluefire Productions (1-10 employees)

Vetted Review

4 years of experience

View profile

PostgreSQL Plus Advanced Server says yes to NoSQL

Rating: 10 out of 10

Incentivized

February 2, 2016

Use Cases and Deployment Scope

We started recommending Postgres Plus Advanced Server (PPAS) to customers as a lower-cost alternative to Oracle Enterprise Edition, which it is. Now we also use PPAS for the simple and stable multi-master replication as well as the JSON capabilities native to PostgreSQL. We also have customers who use PostGIS, the geospatial add-on.

Pros

PPAS Oracle compatibility, especially the PL/SQL syntax, has made migrating database-tier code very simple. Most Oracle packages do not need to be changed at all and those that do are generally for simple reasons like a reserved word in PPAS that is allowed in Oracle.
PPAS xDB, the multi-master replication tool, is simple and - most important - does not break with network or other interruptions. We have been able to configure and forget, which our customers could never do with other multi-master tools.
Most people had no idea that PPAS and PostgreSQL have full CRUD support for JSON. They think you need a specialized product and/or that JSON is read-only. Every organization that I have worked with is evaluating adding JSON to their relational model.

Cons

There are too many custom add-ons that should be part of the default installation. For example, PostGIS - the geospatial tool, foreign-data-wrappers, XML & HSTORE data types, UUIDs and other pieces are not included by default.
The marketing and related material is too focussed on technology and not enough on capability. For example, you would not know that full CRUD on JSON is supported unless you read all the material - that is a big deal, but they seem to miss it.
The backup and recovery tools are not as good as Oracle's and they should be improved.

Likelihood to Recommend

Very well suited to applications mixing relational with NoSQL and/or complex data types, such as network analysis, JSON, key-value-pair, etc. Excellent if you have multiple programming languages in use (Python, Perl, R, etc.) because PPAS supports so many languages natively.

Not well suited if you need encryption at rest, compressed data or very large database-tier backups. [Large backups should be done at the storage tier if possible.]

Jamey Hanson

Senior Software Engineer in Information Technology at Freedom Consulting Group, Inc. (51-200 employees)

Vetted Review

2 years of experience

View profile

Loading Reviews List....

Robust and Somewhat Daunting But Worth the Effort

Rating: 10 out of 10

Incentivized

May 17, 2017

Use Cases and Deployment Scope

Pros

Developer tools including debugging, JSON and XML support, libraries for preferred languages and good examples all facilitated integration and development. Robust features for developers.
Security is top notch and supports far beyond what we required for our project, which is a good thing.
Performance, throttling, monitoring and optimization are all top notch and helped us keep response times low and save on bandwidth and hosting costs.

Cons

Documentation is excellent but spread out across many resources and can take a while to wade through—would benefit from having more intro level, getting started guides for various languages.
Ruby support is excellent but more Ruby examples and beginner-level documentation would be nice.
It is sometimes hard to find a community of users on StackOverflow so a larger community, and a dedicated forum with active members to answer questions and work through issues would be nice.

Likelihood to Recommend

Jonah Dempcy

Web & Mobile Developer in Engineering at Bluefire Productions (1-10 employees)

Vetted Review

4 years of experience

View profile