Webinars

Webinars

On-demand

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.

Installing Postgres on Windows

Over the course of the next month, we will be sharing various webinars to help you get started with Postgres. Join us for this session as we show you how to install Postgres on Windows.

EDB Failover Manager - Features and Demo

Join Postgres expert Saurabh Shelar as he goes through the features and a live demo of EDB Postgres Failover Manager (EFM). You don’t want to miss this!

EDB Postgres Failover Manager (EFM) is a high-availability module from EnterpriseDB that enables a Postgres Master node to automatically failover to a Standby node in the event of a software or hardware failure on the Master.

Saurabh will cover key features of EDB Postgres Failover Manager and Demo Failover scenarios.

Highlights Include:
- Tuneable Properties for User Environment

Installing Postgres in Containers

Over the course of the next month, we will be sharing various webinars to help you get started with Postgres. Join us for this session as we show you how to install Postgres in Containers.

Installing Postgres on Linux

Over the course of the next month, we will be sharing various webinars to help you get started with Postgres. Join us for this session as we show you how to install Postgres on Linux.

What's New in Postgres 12

Join Postgres experts Bruce Momjian and Marc Linster as they preview everything new in Postgres 12. You don’t want to miss this!
Highlights include:

- New compatibility features
- PostgreSQL: Table access methods
 -Partitioning improvements


Want to get all the Postgres 12 updates but can’t make the live webinar? Register here and we will send you the slides and recording following the session.

Creating a Multi-Layered Secured Postgres Database

Join EDB’s SVP of Product Development and Support, Marc Linster in this webinar, he discusses the process of creating a multi-layered security architecture for your Postgres database.
During this session, we will cover:

  • Aspects of Data Security
  • Authentication, Authorization & Auditing
  • Multiple Layers of Security

Learn security best practices for managing your Postgres databases.

Democratization of Databases

Join Bruce Momjian, Wednesday, August 14th at 10:00am EST, as he discusses how democratic governments have a long history of success, with some setbacks. This talk explains how democratic principles underpin the success of the open source relational database Postgres.

Highlights include:

  • The strengths of governance structures
  • The history of software governance
  • The efficiency and messiness of democracy and how this all affects Postgres

Best Practices for Monitoring Postgres

When your databases support mission-critical applications, latency and outages can hurt your business. That’s why you need monitoring and management tools to help you keep your enterprise Postgres servers — and the applications they support — consistently available and consistently fast. In this webinar, you’ll learn:

Oracle Migration to Postgres in the Cloud

Join Marc Linster and Kachan Mohitey, Thursday, July 25th at 12pm EST as they show you how to migrate from Oracle to Postgres in the cloud. This hands-on webinar will cover a number of topics including:

  • Identifying good migration candidates
  • Reviewing the key capabilities needed to run Postgres reliably in the cloud
  • Demoing on how to migrate tables, views, stored procedures, data, etc.

 

Live from Postgres Vision 2019

The future is Postgres and the future is now.

Cannot make Postgres Vision 2019? Join us live from the event as we talk to attendees and speakers about the sessions and their insights into the future of Postgres.

Find out why Postgres Vision 2019 is the Enterprise Postgres conference. 

 

Cloud Native Databases Done Right

EnterpriseDB joined Red Hat and GitLab for Carahsoft's Containerized DevOps Webcast Week.

Anybody can containerize a stateless application and deploy it on Red Hat OpenShift. But databases are different, they are stateful - which means a whole new set of challenges for high availability. Steve Egolf, EDB's Senior Solutions Engineer, will outline how EnterpriseDB has solved this challenge by combing the best of open source Postgres with needed enterprise features.  

Exploring 10 Postgres Tips and Tricks

Postgres is a complex piece of software with many facets to explore. Join Bruce Momjian as he explores 10 tips and tricks for using Postgres effectively within your organization. This session will cover a wide array of Postgres topics, including:

  • Hardware monitoring
  • Backend flowcharting
  • Timing query intervals
  • GUC Variables
  • Transactional DDL

Sign up now to learn these valuable tips and tricks from the incomparable Bruce Momjian.