Presented by:

Ae9322b9e1f448a7e92b1743a06bd6f5

Andries Vorster

GoodX Software

Developer / DevOps Manager / Father of 2 / Postgres Fanatic

I love Postgres , it can do just about anything.

I love optimising queries, automating stuff with Postgres.

No video of the event yet, sorry!

Introduction

Explanation of Extension Modules

  • What are contrib modules and where can we find them ?
  • List of contrib modules , a whole list of cool ready to install modules that would make your life easier.
  • Installing Extensions

file_fdw

  • Installation of extension
  • Using extension module
  • Examples

pgstatstatements

  • Installation of extension
  • config of extension
  • using extension
  • Examples

pg_trgm

  • Installation of extension
  • Using new opreators and functions
  • New type indexes that can be created
  • Examples

dblink

  • Installation of extension
  • basic explanation of dblink / dblink_connect / dblink_disconnect
  • Examples

postgres_fdw

  • Installation of extension
  • Creating a foreign server
  • Creating user mappings for the foreign server
  • Creating foreign tables
  • Importing foreign Schemas
  • select/ update / delete possibilities when using postgres_fdw
  • Examples

Q/A

Date:
2019 October 8 11:20
Duration:
40 min
Room:
Ballroom
Conference:
South Africa 2019
Language:
Track:
Ops and Administration
Difficulty:
Medium