There are many aspects and considerations when securing PostgreSQL. This talk will cover some examples of the dangers associated with typical default installations, along with built-in features and extensions available to mitigate them. It will focus on the recently published DISA PostgreSQL STIG. PostgreSQL is the first completely open source database to receive a published STIG.View presentation
Joe Conway PostgreSQl Engineer,
Joe Conway is an innovative leader with broad experience in a wide array of disciplines and extensive international business exposure. He has been involved with the PostgreSQL community since 1998, presently as a PostgreSQL Committer, Major Contributor, and Infrastructure Team member. He is also the author and maintainer of a PostgreSQL procedural language handler for the R language, PL/R. Joe is currently VP PostgreSQL Engineering at Crunchy Data Solutions and a Board Member at the United States PostgreSQL Association (PgUS).
Very technical presentation about uncommon techniques of query optimization (outside of adding indexes/changing database configuration).View presentation
Maxim Boguk Chief DBA,
Maxim Boguk is a Chief DBA and a co-Founder of Data Egret. A firm, specialising in all things PostgreSQL from database maintenance to system administration support. He has been in the industry for over 15 years and is an experienced Slonik trainer. Maxim lives and works in Australia and enjoys having a break from it all surfing and piloting light airplanes.
Before PostgreSQL 10 'Logical Replication', built-in streaming replication was all time favourite HA solution. It was working quite well to fulfil the need to replicate master to have a replica. Introduction of hot streaming replication added another feather to its cap and opens the way to use ideally sitting replica for read only queries. But, there are many use-cases where it is not a good fit. With this talk, we will discuss real life use cases where logical replication is best fit and physical replication (streaming replication) does not suffice. We will showcase its need and how to achieve it with a quick demo.View presentation
Rajni Baliyan PostgreSQL DBA,
Rajni currently works as a PostgreSQL DBA and engages in pre-sales for database solution at Fujitsu Australia Software Technology. She started her career as Oracle DBA 7 years back and on the way of solving Database problems she got the curiosity to learn other RDBMS like PostgreSQL and SQL server. PostgreSQL attracted her the most and being an Oracle DBA it was not difficult for her to pick it up. Rajni was encouraged to clear PostgreSQL Professional certificate together with Oracle and SQL Server professional certificates.
Many projects involve something resembling job or message queuing. This talk will look at: the pros and cons of using a plain old relational database for this type of workload rather than specialized technology; approaches and designs; special considerations for PostgreSQL and potential improvements.View presentation
Thomas Munro Programmer,
Thomas Munro is a member of the Database Server team at EnterpriseDB where he works on Postgres Plus Advanced Server and PostgreSQL. He has made a number of contributions to PostgreSQL including adding new features, fixing bugs and reviewing patches. He intends to keep doing that. Before becoming an open source database hacker he worked on Unix, C, C++ and database systems in the fintech industry.
How can we get High Availability? How do we scale PostgreSQL? How do we link databases together? Review of open source technology covering replication - physical and logical, Foreign Data Wrappers as well as Postgres-BDR and Postgres-XL and other roadmap items.View presentation
Simon Riggs CTO,
Simon Riggs is the Founder and Chief Technology Officer of 2ndQuadrant. He is also a major developer and committer of the PostgreSQL project. Simon has contributed major features in each of the last 6 versions of PostgreSQL. His work includes recovery and replication performance and monitoring as well as designs for many other features. Simon has worked as a Database Architect for 20 years with high-end solutions experience and certifications on Oracle Teradata and DB2.
There are plenty of ways to contribute to PostgreSQL and some of the ways are may not be known to many people. This topic is to cover most of the ways that are available to contribute to PostgreSQL database by individuals and companies. Many people feels contribution to PostgreSQL is difficult and it is possible only to the people who have knowledge on database, language and etc. This topic is to cover all the ways of contribution to PostgreSQL.View presentation
Hari Babu Kommi Senior Software Development Engineer,
Hari Babu is a Senior Software Development Engineer in Fujitsu Australia Software Technology and is working with both open source PostgreSQL and Fujitsu Enterprise Postgres. I actively participates in the development of PostgreSQL, both developing with PostgreSQL and developed an extension to improve the performance of the queries in hybrid database model.
Keeping your data in more than one place is vital for business continuity, and databases are no exception. Backups are great, but they won't help you when your normally-connected EU, US and Australian operations all want to continue operating during a major WAN outage. This is where multi-master replication systems come into their own - but they also come with often overlooked costs and downsides. Bi-Directional Replication (BDR) for PostgreSQL can help solve some users' availability challenges in a globally distributed environment... if it's applied correctly. Multi-master is not magic high availability secret-sauce that can be applied to every problem, no matter what some major vendors' sales teams would like you to believe. Learn about when to use - and not to use - multi-master replication in general, and BDR in particular.View presentation
Short talk. Pay attention, take notes and hold your questions...you will have the chance to get more details over drinks!View presentation
Gabriele Bartolini Head of Global Support,
A long time open-source programmer and entrepreneur, Gabriele has a degree in Statistics from the University of Florence. Gabriele is the Head of Global Support at 2ndQuadrant and managing director of the Italian office as well as an active member of the international PostgreSQL community and local ITPUG. His commitment is to consistently contribute to the growth of 2ndQuadrant and it’s members through nurturing a lean and devops culture. Gabriele lives in Prato, a small but vibrant city located in the northern part of Tuscany, Italy. His second home is Melbourne, Australia, where he studied at Monash University and worked in the ICT sector. His hobbies include “calcio” (football or soccer, depending on which part of the world you come from) and playing his Fender Stratocaster electric guitar. But his major passion is called: Elisabeth - his sweet 1-year old daughter!
Gary Evans Software Engineer,
Gary currently works for Fujitsu Australia in the PostgreSQL Services and Support team, where he works with Fujitsu Customers to help them get the best out of PostgreSQL and Fujitsu Enterprise Postgres. His software development background utilising Microsoft and open source technologies adds to the diversity of the services team; allowing a rich pool of resources when designing solutions for Fujitsu customers.
Robert Lechte Software Engineer,
Python coder, data massager, open sorcerer, opinion haver, union thug, peanut butter enthusiast, Postgres fanboy. Robert created the data warehousing for New Zealand's supercomputing infrastructure (proof that even the smallest countries can sometime have big data) and then worked for the Digital Transformation Agency in Sydney. He relocated in Melbourne last April to work for the union movement. Robert likes talking about software and he recently presented at PostgresOpen Conference that was held in San Francisco at the beginning of September