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.
Robust and Somewhat Daunting But Worth the Effort
PostgreSQL Plus Advanced Server says yes to NoSQL
Pricing
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?
46 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 Db2?
DB2 is a family of relational database software solutions offered by IBM. It includes standard Db2 and Db2 Warehouse editions, either deployable on-cloud, or on-premise.
Product Demos
edb_filter_log demo
Session - 6 Database Maintenance using REINDEXING in EDB Postgres Advanced Server Part-5
Session 15 : Installation of EDB Postgres Advanced Server on Windows Platform- Version 12
Product Details
- About
- Tech Details
What is EDB Postgres Advanced Server?
EDB Postgres Advanced Server Technical Details
Operating Systems | Unspecified |
---|---|
Mobile Application | No |
Comparisons
Compare with
Reviews and Ratings
(6)Community Insights
- Business Problems Solved
- Pros
- Cons
- Recommendations
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)- 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.
- 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.
PostgreSQL Plus Advanced Server says yes to NoSQL
- 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.
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 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.