Name: EDB Postgres Advanced Server
Rating: 9.8 (6 reviews)
Author: EnterpriseDB

Help Desk

Web and Video Conferencing

Customer Support

Augmented Reality Development

Development

Alumni Management

Education

Business Intelligence (BI)

Collaboration

Enhanced 911 (E911)

Environmental Health and Safety (EHS)

Manufacturing Execution

Project Portfolio Management

Workflow

Enterprise

Accounting

Finance and Accounting

Applicant Tracking

Corporate Learning Management

Employee Referral

Employer of Record (EOR)

HR Management

Payroll

Talent Intelligence

Talent Management

Workforce Analytics

Workforce Management

Human Resources

AI Governance

Application Lifecycle Management (ALM)

Cloud Storage

Continuous Delivery

Converged Infrastructure

Custom Software Development Services

Data Catalog

Data Center Virtualization

Data Fabric

Fraud Detection

Function as a Service (FaaS)

IT Asset Disposal

IT Asset Management

Integration Platform as a Service (iPaaS)

Managed File Transfer (MFT)

Managed Hosting

Mobile Device Management (MDM)

Network Behavior Analysis

Network Performance Monitoring

Network Traffic Analysis (NTA)

Security Analytics

Software Composition Analysis (SCA)

Threat Intelligence

Unified Endpoint Management (UEM)

Information Technology

A/B Testing

Ad Serving & Retargeting

Affiliate

All-in-One Marketing

App Store Optimization (ASO)

Audience Engagement

Audio Editing

Blogging

Contact Management

Content Management

Creative Collaboration

Email Marketing

Marketing Automation

Social Media Analytics

Social Media Management

Survey & Forms Building

Web Analytics

Marketing

Job Site Management

Project Management

Professional Services

Call Recording

Customer Relationship Management (CRM)

Sales

Cloud Infrastructure Entitlement Management

Data-Centric Audit Protection (DCAP)

Security

Chiropractic

Revenue Cycle Management (RCM)

Simulation

Vertical-Specific

Find top rated software and services based on in-depth reviews from verified users. 400+ software categories including PaaS, NoSQL, BI, HR, and more.

PostgreSQL

PostgreSQL Global Development Group

Amazon Relational Database Service (RDS)

Amazon AWS

Oracle Database

Oracle

Tibero

TmaxSoft

Percona Server for MySQL

Percona

Microsoft SQL Server

Microsoft

Google Cloud SQL

Google

Azure SQL Database

MongoDB

### Database Management
Users generally appreciate the database management capabilities of EDB Postgres Advanced Server. They find the tool to be efficient in handling data migration, schema migration, and data operations. The command-line data migration tool, advanced logical replication for PostgreSQL, and browser-based schema migration tool are highlighted as valuable features. While some users mention the need for certain skills to monitor query performance, overall, the consensus is that EDB Postgres Advanced Server simplifies database management tasks and enhances data collection, management, and analysis processes.

### Performance Optimization
Users generally praise the performance optimization capabilities of EDB Postgres Advanced Server, highlighting its ability to enhance database management and operations. While some users have reported occasional drops in performance, overall, the platform is commended for its high availability and reliability in handling complex architectures. The intuitive user interface and responsive customer service further contribute to the positive user experience with performance optimization on EDB Postgres Advanced Server.

### Replication and Scaling
Opinions vary on the replication and scaling features of EDB Postgres Advanced Server. Some users praise its ability to assist development teams in integrating middleware and scaling database queries efficiently. However, others find it challenging to monitor query performance and experience latency issues during scaling, leading to slower operations. The advanced logical replication for PostgreSQL and browser-based schema migration tool are highlighted as strengths, while the command-line data migration tool receives positive feedback. Despite mixed opinions, EDB Postgres Advanced Server's replication and scaling capabilities seem to offer a blend of benefits and challenges for users.

### Security and Protection
Users widely praise the robust security features and data protection capabilities of EDB Postgres Advanced Server. The consensus among reviewers is that the server excels in safeguarding data through encryption methods, protecting against SQL injection attacks, and ensuring compliance with features like data redaction. Additionally, users appreciate the ease of integration with other tools and the reliable performance it offers in maintaining secure databases.

### Compliance and Auditing
Users appreciate the system's robust compliance and auditing features, particularly its SQL injection protection, session tag auditing, and password policy management. The data redaction security feature is lauded for safeguarding sensitive customer information, enhancing overall compliance efforts. Additionally, the real-time monitoring and reporting capabilities contribute to faster recovery and efficient policy management.

### Data Encryption and Safety
Users generally appreciate the robust data encryption and security features offered by edb postgres server based on the positive reviews provided. The consensus among reviewers is that the encryption methods employed by EDB Postgres Advanced Server effectively protect data from various threats, such as SQL injection and data-driven attacks. Users find the ease of integrating with other tools and the availability of tutorials helpful in implementing and understanding the encryption functionalities. Additionally, the data backup and replication features contribute to ensuring data availability and minimizing the risk of data loss or database failures.

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.

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

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.

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.

Microsoft Access

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.

Db2 Standard Edition

Db2 Advanced Edition

Db2 on Cloud Standard

Db2 on Cloud Enterprise

Db2 Warehouse on Cloud Flex One

Db2 Warehouse on Cloud Flex

Db2 Warehouse on Cloud Flex Performance

Db2 Warehouse on Cloud Flex for AWS

Db2 Warehouse on Cloud Flex Performance for AWS

Db2 on Cloud Lite

EDB Postgres Advanced Server

A relational database is a database structured to recognize relations among stored items of information.

Relational Databases

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

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

edb_filter_log demo

Likelihood to Recommend

EnterpriseDB is the leading worldwide provider of Postgres software and services that enable enterprises to reduce their reliance on costly proprietary solutions and slash their database spend by 80% or more. With powerful performance and security enhancements for PostgreSQL, sophisticated management tools for global deployments and Oracle compatibility, EnterpriseDB software supports both mission and non-mission critical enterprise applications. More than 2,500 enterprises, governments and other organizations worldwide use EnterpriseDB software, support, training and certifications, and professional services to integrate open source software into their existing data infrastructures. Based in Bedford, MA, EnterpriseDB is backed by top-tier venture capitalists and strategic investors like Red Hat and IBM.

EnterpriseDB

Dropbox

Google Analytics

Heroku Platform

MySQL

Dropbox Business

Google Drive

Web & Mobile Developer

Postgres Plus Advanced Server 2017-05-16 13:20:40

NetApp SnapMirror

Senior Software Engineer

Postgres Plus Advanced Server 2016-02-01 19:08:42

TrustRadius is a technology and business research firm based in Austin, Texas. The company is known as a review platform for verified B2B technology and software reviews through a proprietary algorithm and human verification.

TrustRadius

Various languages

Support is excellent

Community of users

Add ons

Data types

Backup and recovery

Getting started

Top notch

Robust features

Response times

Pl sql

Sql syntax

Able to configure

Developer tools

Home

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.

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.

Dropbox for Business, Google Analytics, Google Drive

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 &amp; 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.

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.

EDB Postgres Advanced Server

Overview

What is EDB Postgres Advanced Server?