How to Design for Database High Availability

Highly available databases are essential to organizations depending on mission-critical, 24/7 access to data. Postgres is widely recognized as an excellent open-source database, with critical maturity and features that allow organizations to scale and achieve high availability.

This webinar will explore:

Discover PostGIS: Add Spatial functions to PostgreSQL - Singapore Time

PostGIS is an open-source, freely available spatial database extension for the PostgreSQL Database Management System. PostGIS adds spatial functions such as distance, area, union, intersection, and specialty geometry data types to PostgreSQL.

New Approaches to Integrating Oracle and Postgres Database Strategies

Given today’s challenging economic environment, managing the costs of your Oracle databases is more important than ever. Open-source alternatives like Postgres are a real option but the migration process is not always as simple as “rip and replace”. For many, it is a question of how to integrate the two databases.

This webinar will explore:

Remote DBA Service: Powering your DBA needs - Singapore Time

The EDB Remote DBA Service allows companies to accelerate Postgres deployment, either on-prem or in the cloud, while reducing risk, saving money and driving faster growth.

This webinar will cover all the benefits of using the Remote DBA Service.

Remote DBA Service: Powering Your DBA Needs, from Compute to Cloud

The EDB Remote DBA Service allows companies to accelerate Postgres deployment, either on-prem or in the cloud, while reducing risk, saving money and driving faster growth.

This webinar will cover all the benefits of using the Remote DBA Service

Public Sector Virtual Town Hall

Join our virtual town hall to hear about the Postgres trends we are seeing in the public sector and some exciting EDB roadmap updates. We will finish with a Live Q&A session with some of our Postgres experts.

Choose the reliable database tool to help your business in this global crisis - Indonesia Time

Most organizations today are struggling to continually operate on a business-as-usual because of the COVID-19 crisis. Luckily, technology enables us to maintain business operations with the use of platforms and tools to ensure business continuity.

Get to know more about how the EDB Postgres platform can help simplify your database operations while working from home. This webinar includes a deep dive discussion on:
* EDB business technologies overview with relevant case studies
* EDB Postgres Failover Manager
* EFM Demo

My Favorite PostgreSQL Books

One of the most frequent questions I get is: How do I get started with PostgreSQL? How steep is the learning curve for an Oracle DBA?

Build Your Next Gen Database with Nutanix and EDB - Hong Kong Time

This joint Nutanix and EDB webinar will provide the details on Nutanix Era and EDB Postgres, the enterprise-class database management system, what role the two organizations play, key configurations to create an operational cluster in an easy way.

EDB POSTGRES et SETRA Conseil : Comment sécuriser vos bases de données PostgreSQL?

Pour participer à ce webinar, vous pouvez vous inscrire dès maintenant à cette session de 45 mn sur le sujet suivant :

  • SETRA CONSEIL et le partenariat avec EDB Postgres

  • Présentation d’EDB Postgres

  • La plateforme EDB Postgres Standard & Advanced Server

  • Sécuriser la disponibilité des données PostgreSQL

Protecting Sensitive Data within EnterpriseDB Postgres Database

Databases by design centrally aggregate data and, in turn, can expose your organization to fraud and data breaches. Fortunately, EnterpriseDB and Thales team together to address this security and compliance concern.

This webinar will provide some level-setting on the current state of database security, outline today’s best-practices, and offer a vision as to where data storage security is heading.

The agenda for this webinar is:
• Overview of EnterpriseDB and Thales
• Database Security Fundamentals

The Magic of Window Functions in Postgres

Window functions are often used to simplify complex queries and for data analytics. They allow analysis that is normally performed in client applications to be more efficiently processed by the database server.

This presentation explains the many window function facilities and how they can be used to produce useful SQL query results.


In this webinar you will learn:

Why you should use native packages to install PostgreSQL on Linux

When it comes to installing PostgreSQL on a Linux distribution, using a native package is considered to be a better choice compared to installing from the source. In this webinar, we will discuss some benefits of using native packages to install PostgreSQL.

Optimizing Performance: Installers are shipped with “the lowest common denominator” and native packages use the OS libraries resulting in performance and maintenance benefits.

How to use postgresql.conf to configure and tune the PostgreSQL server

Tuning your PostgreSQL server plays an important role in making sure you get the most out of your server resources, and running with default parameters is not always enough. Using the PostgreSQL server configuration file postgresql.conf, we can tune the right area and make the most out of the server resources. The postgresql.conf file tuning parameters are classified into different categories including database connections, memory, optimizers, and logging.


In this webinar, you will learn:

Automating Postgres Deployments on AWS and VMware, with Terraform and Ansible

Deploying Postgres on AWS and VMware shouldn’t be a clunky, manual task. In 2020 and beyond, automation and Postgres will go hand in hand.
Highly available, fault-tolerant PostgreSQL database cluster creation and monitoring can now be deployed in a matter of minutes using Terraform and Ansible scripts. In this webinar, you will learn how developers, devOps, and DBAs can automate cloud and on-premise Postgres deployment with the help of Terraform and Ansible.


We will cover:

Conquering Data Migration from Oracle to Postgres

Once you have converted Oracle object definitions and stored procedures, moving the data is the next key stage.
There are three approaches for migrating data: Big-bang, Trickle, and Synchronize. While most migrations can be done using any one of these approaches, some migrations will require a combination of them.

In this webinar, we will cover the below approaches to migrating data from Oracle to Postgres:

- Big bang - One-time data load

- Trickle - One-time data load in parallel

Professionelle Postgres-Überwachung!

Überwachung ist ein entscheidendes Element des Datenbankökosystems und wichtig für die Gesamtleistung der Datenbank. Sie trägt zudem zum guten Zustand Ihrer Datenbank sowie zur langfristigen Stabilität Ihrer Datenbank und Anwendung bei.
Überwachung gestaltet sich jedoch schwierig, wenn man nicht weiß, welche Variablen man überwachen soll und wie das geht.


Folgendes lernen Sie in diesem Webinar:

Oracle to Postgres Schema Migration Hustle

Whether migrating a database or application from Oracle to Postgres, as a first step, we need to analyze the database objects(DDLs), to find out the incompatibilities between both the databases and estimate the time and cost required for the migration. In schema migration, having a good knowledge of Oracle and Postgres helps to identify incompatibilities and choose the right tool for analysis/conversion. In this webinar, we will discuss schema incompatibility hurdles when migrating from Oracle to Postgres and how to overcome them.


How to Monitor Postgres Like a Pro!

Monitoring is a critical element of the database eco-system and for the overall performance of the database. It also helps to ensure that your database is in a healthy state and is contributing to the long term stability of your database and application.

Webinar: Comment & Pourquoi adopter EDB Postgres

Aujourd’hui, de nombreux DSI décident d’adopter des technologies de base de données Open source pour des raisons de coûts, de performance et de flexibilité.

PostgreSQL est l’une des technologies leaders pour ce type de projet grâce à une fiabilité et une intégrité des données qui sont reconnues.

La société EDB Postgres a encore renforcé cette technologie en y ajoutant notamment des fonctionnalités plus avancées pour faciliter les migrations et son usage dans des environnements de production cloud hybride.

Logical Replication in PostgreSQL

PostgreSQL 10 has added built-in logical replication which tackles some of the limitations of physical replication and opens up the possibility of promising new areas of replication. In this webinar, we will introduce the concept of logical replication and demonstrate how one can configure a logical replication in no time.

Programming the SQL Way with Common Table Expression

Join Postgres experts, Bruce Momjian, as he discusses common table expressions (CTEs) and the ability to allow queries to be more imperative, allowing looping and processing hierarchical structures that are normally associated only with imperative languages.

Postgres in Containern Installieren

Begleiten Sie die Postgres-Experten Marc Linster und Gaby Schilders bei ihrer Schritt-für-Schritt-Erklärung zum Installieren von PostgreSQL und EDB Postgres Advanced Server auf EDB Postgres Docker Containern unter Linux.

JSON and JSONPATH in Postgres 12

Join Postgres experts, Marc Linster and Thom Brown, as they discuss jsquery. Jsquery was introduced to allow more sophisticated querying of JSON data with indexing support. However, this was an external project, with no official support. SQL/JSON is now coming in version 12 which will provide very similar functionality.

The Need fo Speed. Strategies to Modernize Your Datacenter

Join Postgres expert, Marc Linster and Nutanix Product Manager, Mehboob Alam as they share strategies for creating agility in the enterprise, explain how to avoid the complexity and cost of legacy IT, and discuss the benefits leveraging the cloud.

This webinar is a joint session between EnterpriseDB and Nutanix, two companies recognized in the Gartner Magic Quadrant for operational database management systems and hyperconverged infrastructure.