Andrew Dunstan
PostgreSQL Architect at 2ndQuadrant
About
Andrew has been contributing to PostgreSQL since 2002 and has been a committer since 2005. He has contributed in a many areas, including configuration and logging enhancements, dollar quoting, CSV import and export, improvements to plperl, the Windows port, rewriting the initdb and pg_ctl scripts in C, parallel pg_restore and more recently JSON features and fast column addition. He created and maintains the PostgreSQL Buildfarm.
- prerequisites for running Barman
- t...
- what SSL provides - encryption and authentication
- levels of SSL verification
- client certificates and server certificates
- use of self-signed certificates for testing
- creation and use of Certificate Authorities
- use of intermediate Certificate authorit...
If you have an update or insert intensive application, please join us.
presented by Tom Kincaid and Andrew Dunstan
Teams that deploy an insert or update intensive application with Postgres need to understand the topic of tuple freezing. In proper planning this important aspect of the Postgres MVCC architecture, can result in prolonged performance spike or an outage. Unfortunately, may people struggle with the concept of tuple freezing. Hence, DBAs and Developers become confused about how to design applica...
more Ops and AdministrationPlanning for when disaster happens
presented by Andrew Dunstan
A backup solution is an essential part of almost any Disaster Recovery Plan. Barman is a mature, well maintained, open source, continuous backup solution for PostgreSQL. This talk will explain the various options for running Barman, and how using it you can have robust protection against data loss from system failure or corruption. Topics will include
presented by Tom Kincaid and Andrew Dunstan
Proper Vacuum operations is an important function of any Postgres deployment. Vacuum is at the core of many Postgres operational items. Having a Postgres deployment properly tuned for vacuum is critical for all successful Postgres production instances.
Unfortunately, may people struggle with the concepts behind vacuum and auto-vacuum. Hence, DBAs and Developers become extremely confused abou...
more Fri 20 2019 Ops and Administrationpresented by Andrew Dunstan
This talk provides an introduction to setting up PostgreSQL and pgbouncer to use SSL securely and effectively. It will cover
Everything else you need for a successful deployment
presented by Andrew Dunstan
PostgreSQL is not deployed in a vacuum, it relies on many other elements. This talk focuses on all the things that aren't PostgreSQL that you need to make your use of it easy and successful. We'll talk about tools for administration, for monitoring, for backups, for high availability, for debugging, for disaster recovery. We'll also talk about the elements of a management plan for a successful ...
more Thu 21 2019 Ops and Administrationpresented by Andrew Dunstan
Stored procedures have arrived with PostgreSQL version 11. Come see what has been implemented, and how procedures differ from functions. We will discuss some use cases for procedures such as migrating from other database management systems and manipulating data.
Thu 21 2019 DevelopmentHow to do the best for both the community and yourself or your company.
presented by Andrew Dunstan
This talk will focus on the various ways that individuals can contribute to the survival and development of PostgreSQL. This can include provision of time, resources and money in a variety of ways. Sometimes the community can be a little difficult for newcomers to get to grips with. We will discuss how people in different roles, including developers, translators, documenters, and testers c...
more Fri 20 2018 Development