Skip to main content
TrustRadius
EDB Postgres Advanced Server

EDB Postgres Advanced Server

Overview

What is EDB Postgres Advanced Server?

The EDB Postgres Advanced Server is an advanced deployment of the PostgreSQL relational database with greater features and Oracle compatibility, from EnterpriseDB headquartered in Bedford, Massachusetts.

Read more
Recent Reviews

TrustRadius Insights

Users of the EDB Postgres software have found immense value in its RPO and RTO features, which enable quick switchover and failover in …
Continue reading
Read all reviews
Return to navigation

Pricing

View all pricing
N/A
Unavailable

What is EDB Postgres Advanced Server?

The EDB Postgres Advanced Server is an advanced deployment of the PostgreSQL relational database with greater features and Oracle compatibility, from EnterpriseDB headquartered in Bedford, Massachusetts.

Entry-level set up fee?

  • No setup fee

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services

Would you like us to let the vendor know that you want pricing?

45 people also want pricing

Alternatives Pricing

What is Microsoft Access?

Microsoft Access is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools.

What is Teradata Vantage?

Teradata Vantage is presented as a modern analytics cloud platform that unifies everything—data lakes, data warehouses, analytics, and new data sources and types. Supports hybrid multi-cloud environments and priced for flexibility, Vantage delivers unlimited intelligence to build the future of…

Return to navigation

Product Demos

edb_filter_log demo

YouTube

Session - 6 Database Maintenance using REINDEXING in EDB Postgres Advanced Server Part-5

YouTube

Session 15 : Installation of EDB Postgres Advanced Server on Windows Platform- Version 12

YouTube
Return to navigation

Product Details

What is EDB Postgres Advanced Server?

EDB Postgres Advanced Server Technical Details

Operating SystemsUnspecified
Mobile ApplicationNo
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(5)

Community Insights

TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!

Users of the EDB Postgres software have found immense value in its RPO and RTO features, which enable quick switchover and failover in live projects. This has been particularly appreciated by users who prioritize high availability and minimal downtime. Additionally, the Edb postgres server has significantly improved productivity for users by efficiently handling large amounts of data and providing robust security features. As a result, users have been able to store, manage, and scale their data workloads seamlessly, while also building custom functions and maintaining data integrity.

Another key use case of this product is its ability to replace expensive legacy databases. Many users have successfully migrated their databases to the EDB Postgres software, redirecting the savings towards new customer engagement applications. This cost-effectiveness has been a major factor in encouraging users to shift their workloads to this platform, especially when compared to Oracle databases. Moreover, the software offers simple integration and compatibility, flexibility with query languages, and reliable performance for building secure databases.

In addition to the above benefits, users have experienced faster migration of databases with fewer rewrite problems using this software. It also facilitates easier retrieval of data from databases while ensuring compliance with data redaction security features. For those interested in database monitoring and management, the software provides convenient server detection, excellent policy management capabilities, real-time reports, and a solid dashboard. Users have also found it useful for centralizing company information by successfully migrating multiple databases.

Overall, the EDB Postgres software is widely used for various purposes such as storing address and spatial information, hosting analytical dashboards, developmental activities for multiple clients, learning various tools in users' careers, and even storing mission-critical data in production environments. Its high availability, high performance, manageability, advanced security features like data redaction, and integrations for reporting and replication make it well-suited for a range of use cases across different industries.

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.

Buggy Version Releases: Some users have expressed disappointment with the software due to frequent bugs in new releases that are not properly tested, leading to a negative user experience. These issues have caused frustration and hindered smooth operation for some customers.

Overwhelming Customization Options: Several reviewers have found the customization options to be overwhelming, recommending minimal customization to avoid difficulty navigating through the settings and configurations. This complexity has been cited as a barrier for some users who prefer a streamlined and intuitive interface.

Difficult Diagnostics Process: Users have mentioned that identifying bottlenecks during diagnostics can be time-consuming due to the presence of low-level system and session wait events, making it challenging to pinpoint performance issues accurately. This has resulted in delays in problem resolution and impacted overall system efficiency for certain users.

Users have made several recommendations for EDB Postgres Advanced Server based on their experiences. The most common ones include installing EDB Postgres Advanced Server due to its open-source, secure, and free nature. It is regarded as a smart choice for RDBMS and NoSQL developers. Users also recommend giving it a try because of its strong user community and great customer service. They find it worth using for its improved DBA and developer compatibility. Additionally, EDB Postgres Advanced Server's ability to be deployed anywhere, consistent database backup, and instant recovery are highlighted as advantages. Users emphasize that asking for assistance from the support team during data migration can save time and trouble. Furthermore, EDB Postgres Advanced Server is commended for boosting DB performance and having excellent and reliable customer service. Users appreciate its intuitive user interface and functions for developers. Those looking for premium support for Postgres are recommended to use EDB Postgres Advanced Server. In-house consulting with EDB is also recommended for a fantastic experience.

Reviews

(1-2 of 2)
Companies can't remove reviews or game the system. Here's why
Jonah Dempcy | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
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.
  • 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.
  • 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.
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.
  • Postgres Plus Advanced Server is quite complex and may take longer to implement certain things than simply using PostgreSQL depending on developer familiarity with the platform.
  • Getting up to speed can be daunting so again, there is an upfront cost in time spent learning the platform, besides the potential for extra time spent on a feature-by-feature basis.
  • The cost of Postgres Plus Advanced Server should be weighed against simply using PostgreSQL to decide which is the best solution for your business needs.
We chose Postgres Plus Advanced Server because we had the finances to do so and needed the robust featureset, along with the power to optimize our performance and integrate with the development tools of our choosing. We audited a number of options, exploring potential solutions at various levels of robustness and decided that this was our best option moving forward.
Jamey Hanson | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
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.
  • 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.
  • 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.
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.]
  • Simplified Oracle conversions because most of the PL/SQL does not need to be changed. This has allowed organizations that we support to do much of the conversion work themselves.
  • Allowed use of a single tool with mixed data types. For instance, no need to use a JSON-only product or a full-text-search tool because those are built in to PPAS.
  • Multiple customers added geo-spatial capabilities to their applications because PostGIS is simple and included.
  • Oracle Server
PPAS proved better for our customer's data-centric apps than Oracle in all but a few edge cases (encryption at rest and multi-TB database-tier backups) because it is simpler to install/maintain, runs nearly all Oracle-syntax SQL as well as ANSI SQL.
PPAS has much more JSON capabilities (full CRUD vs. read-only in Oracle), simpler geospatial, simpler / more stable replication and datatypes that match developer expectations, such as BOOLEAN and ENUMs.
Return to navigation