Postgres EDB
Enterprise grade database built on PostgreSQL offering robust, scalable solutions for enterprises, featuring advanced SQL functionality, high availability, and data security. EDB integrates seamlessly with cloud platforms and supports multi-model data processing. With features like partitioning & replication, EDB optimizes performance for diverse workloads, ensuring reliability and efficiency.
Features
- Seamless migration, integration with world-class open-source relational database
- Optimization tools, indexing, monitoring for enhanced database performance
- Replication, failover, backup/recovery for mission-critical data protection
- Authentication, encryption, RBAC, auditing for robust data security
- Vertical and horizontal scaling for growing workload demands
- Administration, monitoring, performance tuning for streamlined database operations
- Simplified migration, preserving investments with legacy Oracle & DB2 databases
- Multi-language support, integration with popular tools, frameworks for developers
- Flexibility to deploy in public, private, hybrid clouds
Benefits
- Near zero downtime during scheduled maintenance
- High compatibility with Oracle database schema/functionality
- High availablility configurations for business critical services
- Fully managed or self managed options
- 24/7 technical support
- Compatible with open source tooling and extensions
- Available on Microsoft Azure, AWS, and Google Cloud
- Familiar syntax & tooling accelerates transition for Oracle DBAs/developers
Pricing
£0.07 a unit
Service documents
Request an accessible format
Framework
G-Cloud 14
Service ID
3 0 0 9 0 5 7 4 3 8 8 3 8 7 5
Contact
Digital Modus Ltd
G-Cloud Team
Telephone: 0800 088 6080
Email: frameworks@digitalmodus.com
Service scope
- Software add-on or extension
- No
- Cloud deployment model
-
- Public cloud
- Private cloud
- Hybrid cloud
- Service constraints
- EDB can be installed on-premise at customer’s facilities or where the customer decides, including public/private cloud services such as AWS, Azure or GCP.
- System requirements
-
- Minimum 1 GHz processor, 2GB RAM & 512MB HDD
- Windows, Linux or Mac OS
- AWS, Azure or GCP environment
User support
- Email or online ticketing support
- Email or online ticketing
- Support response times
-
Response & Resolution times are dependent on the severity of the issue and the support plan. Severity 1 issues adhere to the following SLAs: 1) Diamond Plan:
Guaranteed response time - 15 Minutes
Standard Escalation time - 30 minutes
Guaranteed Bug Fix - 24 Hours
2) Platinum Plan:
Guaranteed response time - 15 Minutes
Standard Escalation time - 30 minutes
Guaranteed Bug FIx - 24 Hours
3) Gold Plan :
Guaranteed response time - 60 Minutes
Standard Escalation time - 30 minutes
Guaranteed Bug Fix (Resolution Goal) - 48 Hours - User can manage status and priority of support tickets
- Yes
- Online ticketing support accessibility
- WCAG 2.1 AA or EN 301 549
- Phone support
- Yes
- Phone support availability
- 24 hours, 7 days a week
- Web chat support
- No
- Onsite support
- Yes, at extra cost
- Support levels
- All EDB plans include access to our dedicated support team, staffed full-time by PostgreSQL experts with deep and diverse knowledge about PostgreSQL deployments. This includes experience with other proprietary databases, popular open source extensions, and major cloud infrastructure platforms. The support levels depend on which subscription is taken.
- Support available to third parties
- Yes
Onboarding and offboarding
- Getting started
- We have a full onboarding service available, including installation, initial discovery and training.
- Service documentation
- Yes
- Documentation formats
-
- HTML
- Other
- Other documentation formats
-
- Google Docs
- Word
- PPT
- End-of-contract data extraction
-
Extracting data from an EDB Postgres database at the end of a contract is simple and straightforward and can be carried out by the end user without the need of additional services. Users can inspect data visually in the database using tools like such as pgAdmin.
In a few clicks, users can export data into a number of familiar formats such as CSV or JSON. For a complete backup, users can consider using a tools such as called pg_dump, creating a single file containing a full database backup. - End-of-contract process
- If the EDB service is to be closed down, we will work with you to extract your data and then expunge data & decomission the EDB environment. This Service is an option extra and can be costed (based on exact configuration & Data Volumes) towards the end of the contract, Digital Modus make provision to contract all customers 6 months in advance of contract end.
Using the service
- Web browser interface
- Yes
- Supported browsers
-
- Microsoft Edge
- Firefox
- Chrome
- Safari
- Application to install
- Yes
- Compatible operating systems
-
- Linux or Unix
- MacOS
- Windows
- Designed for use on mobile devices
- No
- Service interface
- Yes
- User support accessibility
- WCAG 2.1 A
- Description of service interface
- The EDB Platform provides an administrative and configuration interface as well as command line capabilities for both administrators and developers
- Accessibility standards
- WCAG 2.1 A
- Accessibility testing
- The EDB platform interface has undergone WCAG testing. Evaluation Methods Used: EDB’s policy is to design, develop and test both products and documentation to be accessible. Testing for accessibility includes • automated tests • human tests such as tool-assisted tests, visual inspection, and manual operation • assistive technology tests.
- API
- Yes
- What users can and can't do using the API
- EDB Postgres Enterprise Manager (PEM) offers a host of well documented API calls to to adminster the database. All API endpoints are discoverable protected via token bated authentication. REST API calls can be used for bulk inserting/updating/deleting of records,securely sharing data with 3rd party applications and triggering database housekeeping/maintenance jobs such as backups.
- API documentation
- Yes
- API documentation formats
-
- HTML
- Other
- API sandbox or test environment
- Yes
- Customisation available
- Yes
- Description of customisation
- The service can be customised using our administration and developer tools
Scaling
- Independence of resources
-
Not applicable - EDB can be installed on-premise at customer’s facilities or where the customer decides, including public/private cloud services such as AWS, Azure or GCP.
When installed on a public cloud, resource isolation techniques such as containerization or virtualization can ensure that each user's database workload runs in its own isolated environment. This prevents one user's workload from impacting another's performance
Analytics
- Service usage metrics
- Yes
- Metrics types
-
EDB makes a wide range of metrics from the Postgres instances avaialble to the cloud provider hosting the instaces. These include performance based metrics such as number of index scans initated on a table, queries cancelled due to timeouts or conflicts, replication lag and disk space usage.
Metrics can be represtented as Promethius formats and consumed in a number of observability & monitoring platform such as Grafana Labs or Splunk. - Reporting types
-
- API access
- Real-time dashboards
- Regular reports
- Reports on request
Resellers
- Supplier type
- Reseller providing extra support
- Organisation whose services are being resold
- Enterprise DB Ltd
Staff security
- Staff security clearance
- Conforms to BS7858:2019
- Government security clearance
- Up to Developed Vetting (DV)
Asset protection
- Knowledge of data storage and processing locations
- Yes
- Data storage and processing locations
- United Kingdom
- User control over data storage and processing locations
- Yes
- Datacentre security standards
- Complies with a recognised standard (for example CSA CCM version 3.0)
- Penetration testing frequency
- Never
- Protecting data at rest
-
- Physical access control, complying with CSA CCM v3.0
- Physical access control, complying with SSAE-16 / ISAE 3402
- Physical access control, complying with another standard
- Encryption of all physical media
- Scale, obfuscating techniques, or data storage sharding
- Other
- Other data at rest protection approach
- EDB protects data at rest by encrypting the database files using encryption mechanisms such as Transparent Data Encryption (TDE) or disk-level encryption provided by the operating system. TDE encrypts data before it's written to disk and decrypts it upon retrieval, ensuring data remains encrypted when stored. Additionally, EDB supports encryption of specific columns using the pgcrypto extension, providing granular control over data encryption. Through these measures, sensitive information stored in PostgreSQL databases remains safeguarded from unauthorized access, ensuring confidentiality and integrity at rest.
- Data sanitisation process
- Yes
- Data sanitisation type
- Explicit overwriting of storage before reallocation
- Equipment disposal approach
- In-house destruction process
Data importing and exporting
- Data export approach
- Data export from EDB Postgresql can be executed via various tools, catering to different user preferences and system requirements. Graphical User Interfaces (GUIs) such as pgAdmin or DBeaver offer intuitive point-and-click interfaces for exporting data, providing options for format selection and customization. Command-line tools like pg_dump and psql offer scriptable solutions, ideal for automation and batch processing, with options for fine-grained control over the export process. Additionally, RESTful APIs can be configured to enable programmatic data extraction, facilitating seamless integration with other systems or applications. Each tool offers distinct advantages, catering to diverse user needs and technical environments.
- Data export formats
-
- CSV
- Other
- Other data export formats
- JSON
- Data import formats
-
- CSV
- Other
- Other data import formats
-
- JSON
- PGDUMP
- Wider imports to be discussed
Data-in-transit protection
- Data protection between buyer and supplier networks
-
- TLS (version 1.2 or above)
- Other
- Other protection between networks
- Standard HTTPS TLS/SSL encryption is used for data in transit protection.
- Data protection within supplier network
-
- TLS (version 1.2 or above)
- Other
- Other protection within supplier network
- The service is provided within the clients network or cloud hosting and therfore comploes with the client security protection
Availability and resilience
- Guaranteed availability
- This software is installed into the clients infrastructure and will support the availability of that infrastructure
- Approach to resilience
- Replication and failover processes can be put in place to ensure the resiliency of the software
- Outage reporting
- This service is run on the customers infrastructure and can be supported by either the customer or Digital Modus. If Digital Modus, we will provide email, event and written notification
Identity and authentication
- User authentication needed
- Yes
- User authentication
-
- 2-factor authentication
- Identity federation with existing provider (for example Google Apps)
- Other
- Other user authentication
- Users can authenticate using SSO, SAML/OAUTH2, with delegate authentication to an external LDAP or Active Directory server
- Access restrictions in management interfaces and support channels
- Role-based access control (RBAC) restricts application access based on a user’s role in an organization and is one of the primary methods for access control. The roles in RBAC refer to the levels of access that users have to the application. Users are allowed to access only the information needed to do their jobs. Roles in Postgres Enterprise Manager (PEM) are inheritable and additive, rather than subscriptive. In other words, as a PEM admin you need to grant the lowest level role to the user and then grant the roles the user needs to perform their job.
- Access restriction testing frequency
- At least every 6 months
- Management access authentication
-
- 2-factor authentication
- Identity federation with existing provider (for example Google Apps)
- Username or password
- Other
- Description of management access authentication
-
EDB supports SSO using OAuth, OpenID, Kerberos and SAML. In addition, when there is an authentication mechanism in place, EDB can delegate authentication to an external LDAP so there is no need to define users in the built-in user management system, and the LDAP/AD system would provide the role for the user, which would be used to constrain the user’s access to any database or view.
EDB also supports IAM authentication for users with a supported cloud account in AWS, Azure or GCP.
Audit information for users
- Access to user activity audit information
- Users have access to real-time audit information
- How long user audit data is stored for
- User-defined
- Access to supplier activity audit information
- Users have access to real-time audit information
- How long supplier audit data is stored for
- User-defined
- How long system logs are stored for
- User-defined
Standards and certifications
- ISO/IEC 27001 certification
- Yes
- Who accredited the ISO/IEC 27001
- NQA
- ISO/IEC 27001 accreditation date
- 17/11/2023
- What the ISO/IEC 27001 doesn’t cover
- N/A
- ISO 28000:2007 certification
- No
- CSA STAR certification
- No
- PCI certification
- No
- Cyber essentials
- Yes
- Cyber essentials plus
- Yes
- Other security certifications
- No
Security governance
- Named board-level person responsible for service security
- Yes
- Security governance certified
- Yes
- Security governance standards
- Other
- Other security governance standards
- ISO/IEC 27016
- Information security policies and processes
- Our information security framework encompasses robust policies and processes to safeguard data integrity and confidentiality. Reporting structure involves designated security officers overseeing compliance. Regular audits, employee training, and technology controls ensure policy adherence. Continuous monitoring and updates maintain effectiveness amidst evolving threats, fostering a secure environment.
Operational security
- Configuration and change management standard
- Conforms to a recognised standard, for example CSA CCM v3.0 or SSAE-16 / ISAE 3402
- Configuration and change management approach
- Salesforce has formal processes for placing a system into production. This procedure includes a build checklist, server hardening checklist and pre-production testing. Baseline configurations for servers, network devices, and databases are consistent with industry-accepted CIS (Center for Internet Security) system hardening guidelines. Change control procedures are required by the company’s Change Management Policy and include steps for testing, review, authorization, communication, verification, and back-out procedures. All changes to the infrastructure components are tested in a dedicated environment using production class equipment before being deployed into production. Changes are reviewed and approved by Technical Operations management prior to deployment to production.
- Vulnerability management type
- Supplier-defined controls
- Vulnerability management approach
- Digital Modus utilises industry-standard tools for automated reviews of our solution components. For non-critical patches, we offer swift deployment to customer environments upon availability and remedies for insecure environment configurations. Salesforce employs multiple tiers of vulnerability management, comprising directive, preventive, detective, and responsive controls. Critical infrastructure patches are prioritised for deployment during off-peak hours whenever feasible, ensuring seamless integration without downtime and minimal disruption to customers.
- Protective monitoring type
- Conforms to a recognised standard, for example CSA CCM v3.0 or SSAE-16 / ISAE 3402
- Protective monitoring approach
- Salesforce Shield and Threat Detection team monitors the Salesforce services 24x7 for threats and unauthorized intrusions via the latest technology, industry analysis and tooling, and in collaboration with the Security Incident Response teams. Extensive logging and monitoring is conducted across all Salesforce Services and environments (at application, network and database layers). All suspicious activities are flagged and reported to Salesforce CSIRT for investigation, management, communication, and resolution of security events and incidents in line with the NIST Incident Response model.
- Incident management type
- Supplier-defined controls
- Incident management approach
- Salesforce has a formal Incident Management Process that guides the Salesforce Computer Security Incident Response team in investigation, management, communication, and resolution activities. Salesforce will promptly notify the customer in the event of any security breach of the Service resulting in an actual or reasonably suspected unauthorised disclosure of Customer Data. Notification may include phone contact by Salesforce support, email to the customer's administrator and Security Contact and public posting on trust.salesforce.com. Salesforce.com is a member of the prestigious Forum of Incident Response and Security Teams (FIRST) and complies with the FIRST framework and best practices for incident response.
Secure development
- Approach to secure software development best practice
- Independent review of processes (for example CESG CPA Build Standard, ISO/IEC 27034, ISO/IEC 27001 or CSA CCM v3.0)
Public sector networks
- Connection to public sector networks
- No
Social Value
- Social Value
-
Social Value
- Fighting climate change
- Covid-19 recovery
- Tackling economic inequality
- Equal opportunity
- Wellbeing
Fighting climate change
Digital Modus is committed to spearheading environmental sustainability in the digital professional services realm. Our journey began with a mission to operate as a net-zero business, minimising environmental impact and advocating for global reductions in greenhouse gas emissions. This dedication is ingrained in our core operating principles: We embrace a Cloud-First Approach, leveraging cloud technologies to help clients transition to sustainable, cloud-based solutions, thereby reducing physical infrastructure and energy consumption. Adopting a Virtual Operational Model, we have eliminated the need for physical office spaces, significantly reducing our energy usage while supporting high staff productivity and lowering our carbon footprint. Sustainable Supply Chain Management is a priority, as we meticulously assess suppliers and partners to ensure alignment with our environmental goals. Our Employee Engagement and Training initiatives include CPD Accredited and IOSH Approved Environmental Awareness training for all team members, fostering a culture of active environmental stewardship through staff volunteering activities. Strategic Carbon Management is integral to our efforts, involving measures such as reducing air travel, promoting energy-efficient transportation, and monitoring partners' emission reduction targets. We aim for absolute emission reductions through internal initiatives and consider strategic carbon offsets. Our environmental responsibility is validated by the ISO 14001 Environmental Management System (EMS) Certification, affirming our commitment to responsibly managing environmental impacts. Target Commitments include achieving Net Zero Carbon Emissions by 2027, significant emission reductions through ongoing initiatives and supplier monitoring, and fostering an organizational culture valuing and acting upon environmental responsibilities. Through these principles, Digital Modus not only sets an example in environmental stewardship but also delivers digital solutions aligned with the sustainability goals of the UK public sector.Covid-19 recovery
As a nascent SME employer, Digital Modus has ensured that we met all the Government guidance around safe working through the pandemic period. As we exit the severe impact phase of COVID-19, we are creating additional COVID-19 safe employment. Where possible, we ensure that the employment opportunities we create are suitable for those returning to the workplace after the impact of COVID-19 by offering the flexibility of contracted hours and location. As a professional services consultancy, we have taken the decision to not have a "bricks and mortar" presence, this helps with creating a workplace condition where disease transmission amongst colleagues is minimal. Our employees all work from home when not on site. They are encouraged when being asked to work on-site, to understand the site-specific COVID-19 regulations and to take a view on whether the environment is currently safe to enter. We have regular touchpoints with all employees on their wellbeing and ask that they consider how they might best support our healthcare services through judicious use. We encourage our people to have a sense of community and to engage with their specific community to see what they can do to help by providing community support services and for example regular engagement with neighbours & their local communities.Tackling economic inequality
Digital Modus is committed to tackling economic inequality through a comprehensive approach, leveraging our agility and innovation as a small-to-medium sized enterprise (SME). Emerging during the COVID-19 pandemic, we embarked on a mission to disrupt the UK public sector marketplace with pioneering technologies, thereby generating substantial employment opportunities nationwide. Our remote working model enables us to offer diverse career paths, welcoming individuals from varied backgrounds across the UK. This approach ensures that geographical constraints do not hinder career progression, enriching our talent pool and bolstering local economies. Collaborating with fellow SMEs, we strengthen not only our service portfolio but also contribute to the broader SME sector's resilience. Diversity and inclusivity are core principles, extending to our network of professional service contractors who benefit from sustainable employment and development opportunities. Partnering with SMEs from diverse backgrounds enhances our solutions by incorporating a range of perspectives and ideas, fostering a resilient supply chain. Adhering to the Equality Act 2010, our recruitment, promotion, and compensation processes reflect our unwavering commitment to fairness and equal opportunity. We implement rigorous measures to combat modern slavery in our operations and supply chain, upholding ethical standards throughout our business dealings. Additionally, our workplace prioritizes the well-being of our employees, fostering an inclusive environment where well-being is central to our operations. Digital Modus aims not only to drive economic growth and community development but also to set ethical standards and promote social responsibility in the SME sector. Our efforts are geared towards creating a more equitable society, benefiting both the public sector and society at large.Equal opportunity
Digital Modus is committed to fostering a societal impact through innovative technology and fair and equitable resource deployment. Our core mission is to empower customers across the UK public sector to positively influence social, environmental, and economic dimensions, enhancing the lives of the citizens their services are delivered to. Our recruitment processes are bias-free, focusing solely on skills, qualifications, and experience. This, coupled with our virtual-first approach, fosters a diverse workforce crucial for innovation. We actively encourage applications from individuals with disabilities, aiming to bridge the employment gap by offering skill development and career advancement opportunities. Additionally, we champion flexible working arrangements to accommodate diverse needs, ensuring accessibility and sustainability in careers at Digital Modus. We collaborate with third-sector organisations to diversify our supply chain, enhancing business resilience and backing community initiatives. Each employee has a customised progression path, nurturing personal growth. We value feedback, conducting regular surveys to refine our equality and diversity initiatives, ensuring they meet the evolving needs of our workforce. We reinforce our commitment through clear policies on Recruitment & Selection, Diversity & Inclusion, and Modern Slavery, backed by regular staff training. Our dedication to fostering an inclusive workplace culture is ingrained in our business values. We strive to create an environment where diversity is celebrated, and everyone has equal access to opportunities, ensuring that each individual feels valued and respected. Digital Modus believes that true commitment to diversity and inclusion requires a holistic approach that spans policies, practices, and culture. By implementing these strategies, we not only enhance our operational effectiveness but also contribute to a more equitable society.Wellbeing
As a start-up that was created during the COVID-19 pandemic, we recognize the critical importance of physical and mental wellbeing in the workplace. Digital Modus has implemented comprehensive measures to support our employees' holistic health, fostering a strong culture of care and resilience within our organisation. We prioritise comprehensive wellbeing support, offering platforms and channels for employees to discuss wellbeing topics. Partnering with a service provider, we provide a robust wellbeing assessment tool with insights and resources for effective wellness management. Our Senior Management team actively engages with employees, emphasising the importance of breaks and personal activities for recuperation. In terms of employee benefits, we provide extensive health coverage, including private medical, dental, and health insurance for employees and their families. Additionally, our Employee Assistance Programme offers counselling and support for various concerns. We promote a flexible and family-friendly work environment, offering enhanced leave entitlements and supportive maternity and paternity benefits. Our commitment extends to providing ergonomic workspaces and opportunities for career growth and skill development. We foster inclusivity and engagement, valuing diverse perspectives and maintaining an open work environment. Furthermore, we encourage community engagement through volunteering and social activities, with provisions for paid time off. Continuously seeking feedback, we are dedicated to evolving our policies and practices to better serve our employees. At Digital Modus, we believe that nurturing employee wellbeing is not only beneficial for individual staff members but also crucial for the overall success and sustainability of our business and our customer's success. By implementing these holistic wellness strategies, we ensure that our team remains resilient, engaged, and motivated.
Pricing
- Price
- £0.07 a unit
- Discount for educational organisations
- No
- Free trial available
- Yes
- Description of free trial
- https://www.enterprisedb.com/quick-start-guide-biganimals-demand-free-trial BigAnimal lets you build highly available, distributed applications, move off of Oracle databases - 14 days - $300 credit - PDF on link
- Link to free trial
- http://www.digitalmodus.com/freetrail