BEGIN:VCALENDAR VERSION:2.0 PRODID:-//Pentabarf//Schedule 0.3//EN CALSCALE:GREGORIAN METHOD:PUBLISH X-WR-CALDESC;VALUE=TEXT:PostgreSQL devroom X-WR-CALNAME;VALUE=TEXT:PostgreSQL devroom X-WR-TIMEZONE;VALUE=TEXT:Europe/Brussels BEGIN:VEVENT METHOD:PUBLISH UID:5803@FOSDEM17@fosdem.org TZID:Europe-Brussels DTSTART:20170205T110000 DTEND:20170205T115000 SUMMARY:Beyond Trust - PostgreSQL Client Authentication DESCRIPTION:
This talk explores client authentication in PostgreSQL, ranging from "trust" to SSL certificates and enterprise authentication systems like GSSAPI (Kerberos). We will discuss security and compliance implications, but also the performance impact and operational aspects as password changes.The presentation also includes typical usage scenarios and practical configuration advice.
CLASS:PUBLIC STATUS:CONFIRMED CATEGORIES:PostgreSQL URL:https:/fosdem.org/2017/schedule/2017/schedule/event/postgresql_client_auth/ LOCATION:H.1309 (Van Rijn) ATTENDEE;ROLE=REQ-PARTICIPANT;CUTYPE=INDIVIDUAL;CN="Christoph Moench-Tegeder":invalid:nomail END:VEVENT BEGIN:VEVENT METHOD:PUBLISH UID:5804@FOSDEM17@fosdem.org TZID:Europe-Brussels DTSTART:20170205T120000 DTEND:20170205T125000 SUMMARY:Tour de Data Types DESCRIPTION:Ever wondered what might be the best data type for a certain use case? Is it better to use INTEGER or BIGINT, and should you use TIMESTAMP or is it better to use TIMESTAMPTZ? When is the last time you migrated a legacy database and wondered what to use as replacement for VARCHAR2 or CHAR(255)? How to store IP addresses or geographical data, does that fit into VARCHAR or is there something more suitable?
PostgreSQL 9.6 comes with around 40 different data types preinstalled. This talk looks beyond INTEGER and VARCHAR and dives into some of the lesser known PostgreSQL data types. Use cases and examples show which data type is a good fit for a certain situation.
CLASS:PUBLIC STATUS:CONFIRMED CATEGORIES:PostgreSQL URL:https:/fosdem.org/2017/schedule/2017/schedule/event/postgresql_data_types/ LOCATION:H.1309 (Van Rijn) ATTENDEE;ROLE=REQ-PARTICIPANT;CUTYPE=INDIVIDUAL;CN="Andreas Scherbaum (ads)":invalid:nomail END:VEVENT BEGIN:VEVENT METHOD:PUBLISH UID:5891@FOSDEM17@fosdem.org TZID:Europe-Brussels DTSTART:20170205T130000 DTEND:20170205T135000 SUMMARY:AMENDMENT Bringing the Semantic Web closer to reality: PostgreSQL as RDF Graph Database DESCRIPTION:An investigation into how Python's RDFLib and SQLAlchemy can be used to leverage PostgreSQL's capabilities to provide a persistent storage back-end for Graphs, and become the elusive practical RDF triple store for the Semantic Web (or simply help you export your data to someone who's expecting RDF)!
Please note that this talk replaces "Replication & Recovery in PostgreSQL 10.0" which was to be given by Simon Riggs.
CLASS:PUBLIC STATUS:CONFIRMED CATEGORIES:PostgreSQL URL:https:/fosdem.org/2017/schedule/2017/schedule/event/postgresql_semantic_web/ LOCATION:H.1309 (Van Rijn) ATTENDEE;ROLE=REQ-PARTICIPANT;CUTYPE=INDIVIDUAL;CN="Jimmy Angelakos":invalid:nomail END:VEVENT BEGIN:VEVENT METHOD:PUBLISH UID:5806@FOSDEM17@fosdem.org TZID:Europe-Brussels DTSTART:20170205T140000 DTEND:20170205T145000 SUMMARY:Evolution of Fault Tolerance in PostgreSQL DESCRIPTION:PostgreSQL is an awesome project and it evolves at an amazing rate. The talk will focus on evolution of fault tolerance capabilities in PostgreSQL throughout its versions.
The talk will cover the topics listed below:
There are several ways of how to look at fault tolerance. In this sense PostgreSQL provides different means of achieving fault tolerance and dependability either out of the box solutions or using extensions depending on what are the user’s priorities about their system. General fault tolerance in PostgreSQL is improving over time and I expect this trend to continue.
CLASS:PUBLIC STATUS:CONFIRMED CATEGORIES:PostgreSQL URL:https:/fosdem.org/2017/schedule/2017/schedule/event/postgresql_fault_tolerance/ LOCATION:H.1309 (Van Rijn) ATTENDEE;ROLE=REQ-PARTICIPANT;CUTYPE=INDIVIDUAL;CN="Gülçin Yıldırım":invalid:nomail END:VEVENT BEGIN:VEVENT METHOD:PUBLISH UID:5807@FOSDEM17@fosdem.org TZID:Europe-Brussels DTSTART:20170205T150000 DTEND:20170205T160000 SUMMARY:Infrastructure Monitoring with Postgres DESCRIPTION:The revolt against SQL continues at a steady but considerably slower pace. Bespoke database software seems to crop up daily in the name of performance or functionality. This talk will examine the ever growing field of monitoring systems and their respective databases, and look in depth as to how Postgres can be used in a number of these places. Systems of this nature are typically tasked with collecting and storing metrics from your infrastructure, drawing pretty graphs, and nagging you when things break.
Forms of data stored by these systems are nothing to be afraid of - they often include:- Time series metrics - the history of a measurement over time, e.g. temperatures- Logs - unstructured text emitted by applications, operating systems and hardware- Events - schema-less but well structured notifications
An assertion of this talk is that for a majority of use cases, Postgres is more than capable of storing all of this data. We will attempt to replace numerous well known pieces of software with just one Postgres database. Of course we are told to use the right tool for the job, but having to learn and operate a single tool is a huge operational advantage.
We’ll get quite technical in this talk, take a look the data models and access patterns required, and how this can be fitted into the general purpose environment of Postgres. Additionally, it is always constructive to look at what can be problematic, and not just focus on the positives, and why many turn to other bespoke solutions.
CLASS:PUBLIC STATUS:CONFIRMED CATEGORIES:PostgreSQL URL:https:/fosdem.org/2017/schedule/2017/schedule/event/postgresql_infrastructure_monitoring/ LOCATION:H.1309 (Van Rijn) ATTENDEE;ROLE=REQ-PARTICIPANT;CUTYPE=INDIVIDUAL;CN="Steven Simpson":invalid:nomail END:VEVENT BEGIN:VEVENT METHOD:PUBLISH UID:5808@FOSDEM17@fosdem.org TZID:Europe-Brussels DTSTART:20170205T160000 DTEND:20170205T165000 SUMMARY:An overview of PostgreSQL's backup, archiving and replication DESCRIPTION:The PostgreSQL documentation explains in detail how to do backup and replication, maybe too detailed for beginners or "part-time" DBAs.
On the other hand, there are some common misconceptions about data safety.
The talk gives a comprehensive, yet brief overview of the different approaches to perform backup/restore, point-in-time recovery and replication, advising on what to use in different scenarios.
Some typical misconceptions and pitfalls are addressed as well.
CLASS:PUBLIC STATUS:CONFIRMED CATEGORIES:PostgreSQL URL:https:/fosdem.org/2017/schedule/2017/schedule/event/postgresql_backup/ LOCATION:H.1309 (Van Rijn) ATTENDEE;ROLE=REQ-PARTICIPANT;CUTYPE=INDIVIDUAL;CN="Gunnar Bluth (Nick)":invalid:nomail END:VEVENT END:VCALENDAR