2ndQuadrant Webinars

Learn from Globally Renowned PostgreSQL Experts

PostgreSQL Webinars, Postgres Webinars, Webinar

2ndQuadrant’s webinar series highlights important functions and features of PostgreSQL while allowing you to engage with globally recognized PostgreSQL experts. As the largest collective group of contributors in a single organization, 2ndQuadrant’s webinars give you access to learn information first hand from the experts that contributed to the code.

Upcoming Webinars

Migration to PostgreSQL

Date and Time: Wed, June 26, 2019 at 4pm UTC

Topics covered in this webinar will be added later.

Speaker: TBA

Geo spatial application development with PostGIS

Date and Time: Wed, Aug 28, 2019 at 4pm UTC

Topics covered in this webinar will be added later.

Speaker: TBA

Past Webinars

Security and Compliance with PostgreSQL

Date: Wednesday, April 24, 2019

This webinar was built on the previous webinar we held on security and focus on the following topics:

  • Advanced features for security in PostgreSQL
  • PCI compliance
  • Backup security
  • Schema level security
  • Row level security

Speaker: Boriss Mejías | PostgreSQL Consultant at 2ndQuadrant

Missed the session? Watch the recording.

Achieving High Availability with PostgreSQL

Date: Tuesday, February 26, 2019

The webinar covered the following topics:

  • Overview of High Availability concepts
  • High Availability with PostgreSQL streaming replication
  • Setting up a streaming replication cluster, best practices
  • Failover and switchover – Reconfiguring application setup
  • Pros & Cons of Automatic vs Manual failover
  • Backups and High Availability

Speaker: Martín Marqués | Deputy Head of Support at 2ndQuadrant

Missed the session? Watch the recording.

Banking on Postgres – Financial Application Considerations

Date: Tuesday, January 29, 2019

The webinar covered the following topics:

  • Attributes of Financial Databases
  • Selecting Hardware
  • Maximizing Resources
  • Addressing Throughput
  • Incorporating Maintenance
  • High, Higher, Highest Availability
  • Backups, Backups, Backups
  • More

Speakers: Shaun Thomas | Principal Consultant at 2ndQuadrant

Missed the session? Watch the recording.

pglogical and Postgres-BDR Update

Date: Tuesday, January 8, 2019

The webinar covered the following topics:

  • Latest on pglogical and Postgres-BDR
  • Overview of existing features
  • Updates on new features
  • Roadmap

Speakers: Simon Riggs | CEO 2ndQuadrant

Missed the session? Watch the recording.

Introduction to OmniDB

Date: Wednesday, November 28, 2018

The webinar covered the following topics:

  • What is OmniDB?
  • Development – Past & Present
  • Supported DBMS
  • PostgreSQL Support
  • Interface and Features
  • PL/pgSQL debugger
  • Monitoring
  • Plugin System
  • Roadmap

Speakers: Rafael Castro & William Ivanski | PostgreSQL Consultants at 2ndQuadrant

Missed the session? Watch the recording.

PostgreSQL is NOT your traditional SQL database

The webinar covered the following topics:

  • Design choices of PostgreSQL
  • Arrays, Enum, JSON
  • JSONB and GIN
  • Full-Text Search in PostgreSQL
    • tsvector, tsquery
    • Ranking
    • Misspelling
    • Accent support
    • Language support
  • Why choose PostgreSQL?

Speaker: Gülçin Yıldırım Jelínek | Cloud Services Manager at 2ndQuadrant

Missed the session? Watch the recording.

New Features in PostgreSQL 11

The webinar covered the following topics:

  • Introduction to PostgreSQL 11
  • Improvements to partitioning and parallelism
  • Stored procedures
  • JIT compilation
  • Security
  • Plans for PostgreSQL 12

Speaker: Peter Eisentraut | Major PostgreSQL Contributor, 2ndQuadrant

Missed the session? Watch the recording.

Database Security in PostgreSQL

Date: Wednesday, September 12, 2018

The webinar covered the following topics:

  • Introduction to Database Security
  • PostgreSQL Security Architecture
  • PostgreSQL encryption, mandatory access control, roles, privileges, and row-level security
  • SASL Authentication plugins
  • SCRAM-SHA-256 authentication

Speaker: Kirk Roybal | Principal Consultant, 2ndQuadrant

Missed the session? Watch the recording.

Ansible & PostgreSQL

Date: Tuesday, July 10, 2018

The webinar covered the following topics:

  • Overview of Ansible and PostgreSQL
  • Best strategies for mixed cloud and on-premises deployments
  • How to create a variety of cluster types
  • How to deploy AlwaysOn PostgreSQL clusters and perform maintenance updates
  • How to backup servers for mixed on-premises and multi-cloud deployments

Speaker: Tom Kincaid | General Manager North America, 2ndQuadrant

Missed the session? Watch the recording.

Introduction to Postgres-BDR

Date: Wednesday, May 16, 2018

The webinar covered the following topics:

  • Introduction to Postgres-BDR
  • Postgres-BDR Architecture
  • High Availability, Disaster Recovery, Rolling Upgrades, Latency and Geographical Distribution with Postgres-BDR
  • Common use cases for Postgres-BDR
  • Making applications compliant with Postgres-BDR

Speaker: Simon Riggs | CEO 2ndQuadrant

Missed the session? Watch the Recording.

Power of Indexing in PostgreSQL

Date: Wednesday, April 4, 2018

The webinar covered the following topics:

  • Various ways to access data in PostgreSQL
  • Different types of indexes supported by PostgreSQL
  • Internals of BTree and BRIN indexes
  • Overview of GIN and GiST indexes
  • How to find missing and unused indexes

Speaker: Pavan Deolasee | PostgreSQL Developer, 2ndQuadrant

Missed the session? Watch the recording.

Data Integration with PostgreSQL

Date: Tuesday, Feb 13, 2018

The webinar covered the following key topics:

  • What is a Foreign Data Wrapper?
  • How to simultaneously query MySQL, a Flat file, a Python script, a REST interface and a different Postgres Node
  • Stream to Kafka
  • Write data to … MongoDB!?

Speaker: Shaun Thomas | Principal Consultant at 2ndQuadrant

Missed the session? Watch the recording.

Introduction to JSON data types in PostgreSQL

Date: Tue, December 12, 2017

  • What’s the difference between JSON and JSONB?
  • Accessing JSON values
  • When to use JSON, when to use JSONB, and when neither should be used

Speaker: Andrew Dunstan | Principal Contributor of JSON functionality to PostgreSQL

Missed the session? Watch the recording.

About 2ndQuadrant

2ndQuadrant provides PostgreSQL solutions for the Enterprise. Our support engineers have over 100 years of combined code contributions to the PostgreSQL project, making us the only company to contribute enterprise features to all of the last 13 releases.

This is paired with 17+ years of hands-on experience through client engagements and allows us to integrate customized solutions with our customers – making 2ndQuadrant the Gold Standard for PostgreSQL products & services.