Resources
:White PapersLibrary
Replacing Oracle with Postgres: How To Successfully Migrate Your Legacy Databases
This white paper focuses on the most popular source and target for database migrations: moving from Oracle to Postgres. Oracle is the #1 legacy database, and its extremely onerous license policies are driving the majority of migration demand.
Tech Guide: How the EDB Postgres STIGs Can be Used to Secure Your PostgreSQL Database
“PostgreSQL's speed, security and robustness make it suitable for 99% of applications, so it's a great starting place for any application.” This suitability is one of the main reasons why PostgreSQL has become so popular. PostgreSQL’s inherent security features are why organizations are able to use it with confidence.
Tech Guide: How to build a local EDB Red Hat repository without direct internet access
If you are installing EDB on RHEL7 machines, RPMs are the way to go. There are many reasons for this, a few of which are using consistent installation paths and that it is the standard way to install on RHEL derivatives.
Postgres-BDR Always On Architectures
This whitepaper describes the blueprint for Always On architectures for PostgreSQL. These architectures reflect EDB’s recommended practices and help customers achieve highest possible service availability in multiple different configurations, ranging from single-location architectures all the way to complex distributed systems that protect from hardware failures and data centre failures. The architectures leverage Postgres-BDR’s multi-master capability and leverage its ability to achieve 99.999% availability including maintenance operations.
6 Critical Questions to Boost Your Cloud Database Performance
Cloud databases and database-as-a-service (DBaaS) solutions can offer significant advantages over the on-premise databases in terms of agility with which databases can be provisioned in the cloud, savings in terms of capital expenditures, and reduction in IT staff to manage the infrastructure and databases. However, there are new challenges that one must be aware of and ask the right questions before considering the cloud database.
The End of the Reign of Oracle RAC: Postgres-BDR Always On
A discussion of what it means to be ‘Always On,’ what the obstacles are, and how bidirectional replication and Postgres-BDR (TM) creates a PostgreSQL replication alternative to proprietary replication software, such as Oracle® Real Application Cluster (RAC).
Postgres-BDR: The Next Generation of PostgreSQL High Availability
This white paper introduces the BDR technology and the Postgres-BDR Always On architecture—focusing on high availability, where BDR provides unparalleled protection from infrastructure issues, combined with near zero-downtime maintenance and management capabilities.
Infographic: 5 Things to Include on Your PostgreSQL Security Checklist
Securing data is mission-critical for the success of any enterprise, as well as for the safety of its customers. This PostgreSQL Security Checklist infographic presents a framework and a series of recommendations to secure and protect a PostgreSQL database.
PostgreSQL Integration Tree - Infographic
See how PostgreSQL integrates with the various elements in your tech stack.
5 Möglichkeiten, mehr aus PostgreSQL herauszuholen
PostgreSQL ist heute für Unternehmen eines der gängigsten Open-Source-Datenbankmanagement-Systeme (DBMS). Mit seiner Skalierbarkeit, Leistung und Erweiterbarkeit bietet es die Voraussetzungen dafür, die meisten Workloads, Use-Cases und Architekturen im jeweiligen Unternehmensmaßstab zu bewältigen. In diesem E-Book werden fünf wichtige Aspekte vorgestellt, die IT-Managern und DBAs dabei helfen, PostgreSQL-Implementierungen besser zu nutzen und das Beste aus Postgres herauszuholen. Die folgenden Abschnitte geben Tipps und Hinweise, wie Sie Ihr Projekt zum Erfolg führen.
Running PostgreSQL Database in a Cloud Native Environment with Kubernetes
PostgreSQL has become the open source relational database of choice for many people and organizations. For any application developer that wants to easily develop, debug, and test software against a PostgreSQL database, a big question is: How can Postgres be installed in Kubernetes?
The Expert's Guide to Integrating PostgreSQL
Over the last decade, open source databases have won the hearts and minds of developers and database operators across the globe. When you double-click on the open source trends, you will clearly see that PostgreSQL® has become the database of choice. The reasons are obvious: innovation, reliability, cost, and support of a wide range of platforms. This white paper takes a detailed look at the integration of PostgreSQL® with the enterprise tech stack to help accelerate development and the move to production.
5 solutions pour booster votre usage de PostgreSQL : Guide pour les responsables informatiques et les DBA
PostgreSQL est le système de gestion de base de données (SGBD) open source par excellence pour les entreprises d’aujourd’hui, notamment parce que sa scalabilité, ses performances et ses capacités d’extension lui permettent d’adresser la très grande majorité des cas d’usages en s’adaptant aux architectures rencontrées à l’échelle de toute entreprise, quelle qu’elle soit.
Bewährte Sicherheitspraktiken für PostgreSQL
Dieses Whitepaper stellt einen Rahmen und eine Reihe von Empfehlungen zur Sicherung und zum Schutz einer PostgreSQL-Datenbank vor. Wir diskutieren ein mehrschichtiges Sicherheitsmodell, das sich mit physischer Sicherheit, Netzwerksicherheit, Host-Zugriffskontrolle, Datenbankzugriffsverwaltung und Datensicherheit befasst. Obwohl alle diese Aspekte gleich wichtig sind, konzentrieren wir uns auf PostgreSQL-spezifische Aspekte der Sicherung einer Datenbank und der darin enthaltenen Daten.
Configuring and Tuning PostgreSQL and EDB Postgres Advanced Server - Guide for Windows Users
These recommendations for tuning for EDB Postgres Advanced Server (EPAS) and PostgreSQL represent a starting point. Benchmarks and other measurements are required for proper tuning. This document is not intended to be an exhaustive list of configuration settings or recommendations, only the most important parameter settings that are not already the default values.
Configuring and Tuning PostgreSQL and EDB Postgres Advanced Server - Guide for Linux Users
These recommendations for tuning for EDB Postgres Advanced Server (EPAS) and PostgreSQL represent a starting point. Benchmarks and other measurements are required for proper tuning. This document is not intended to be an exhaustive list of configuration settings or recommendations, only the most important parameter settings that are not already the default values.
Security Best Practices for PostgreSQL
This white paper presents a framework and a series of recommendations to secure and protect a PostgreSQL database. We discuss a layered security model that addresses physical security, network security, host access control, database access management, and data security. While all of these aspects are equally important, the paper focuses on PostgreSQL specific aspects of securing the database and the data.
5 Fragen Zu Hochverfügbarkeit Im Datenbankumfeld
Die Minimierung von Ausfallzeit im Datenbankumfeld ist von entscheidender Bedeutung für Unternehmen, die 24/7-Betrieb haben und kontinuierlichen Zugriff auf geschäftskritische Daten gewährleisten müssen. Die Anwendungsfälle von Datenbanken mit Hochverfügbarkeit reichen von Finanzdienstleistern bis zu Telekommunikationsanbietern, aber das gewünschte Ergebnis ist immer das gleiche: eine höchstzuverlässige Datenbank, die Ausfallzeiten minimiert.
5 Questions A Se Poser Pour Rendre Vos Bases De Donnees Hautement Disponibles
La haute disponibilité des bases de données est essentielle pour les applications critiques de toute entreprise nécessitant un accès 24h/24, 7j/7. Les cas d’usage relatifs à la haute disponibilité peuvent varier entre une entreprise du secteur financier ou du secteur des télécommunications, mais le résultat escompté est le même : une base de données extrêmement fiable qui minimise les temps d’arrêts.
5 Questions To Ask When Designing Highly Available Databases
High availability databases are essential to organizations depending on mission-critical, 24/7 access. If you’re tasked with designing a highly available database, we detail five questions you need to consider before taking action.
Performance Comparison of MongoDB vs. PostgreSQL
This report was produced by Ongres and compares the performance of PostgreSQL and MongoDB. It features in depth analysis along with the supporting data and source code for three different benchmarks: Transaction - A custom benchmark that models an airline reservation system Sysbench - For OLTP workloads, considers both in-memory and 2TB datasets JSON-based OLAP - Measures performance on four custom-written queries
6 Things a Developer Should Know About Postgres
In this tech guide, we describe six things that a developer should know about in terms of how easy it is to install, work with, and deploy Postgres as well as the unique capabilities and wide range of features that Postgres offers.