Audit Logging for PostgreSQL (PGConf US 2016)

Many of us have had auditors ask for information that is difficult to provide with core PostgreSQL. Who made changes to table X in the last six months? When was table Y's DDL last modified and was that during a maintenance window? Who has viewed table Z?

An extension available for PostgreSQL 9.5, pgaudit, seeks to answer these and many other questions by providing more detailed logging and finer control of what is logged than is currently available. This talk will examine pgaudit design and usage before presenting practical examples.

Bio:

David Steele is Senior Data Architect at Crunchy Data Solutions, the PostgreSQL company for secure enterprises. He has been actively developing with PostgreSQL since 1999.

David loves taking on big data challenges. Until recently he was Data Architect at Resonate, an online media company using PostgreSQL to drive its transactional and data warehousing databases. Before that, he helped drive global mobile text messaging at Sybase365.

Audit Logging for PostgreSQL (PGConf.EU 2016)

Many of us have had auditors ask for information that is difficult to provide with core PostgreSQL. Who made changes to table X in the last six months? When was table Y's DDL last modified and was that during a maintenance window? Who has viewed table Z?

An extension available for PostgreSQL 9.5, pgaudit, seeks to answer these and many other questions by providing more detailed logging and finer control of what is logged than is currently available. This talk will examine pgaudit design and usage before presenting practical examples.

Bio:

David Steele is Senior Data Architect at Crunchy Data Solutions, the PostgreSQL company for secure enterprises. He has been actively developing with PostgreSQL since 1999.

David loves taking on big data challenges. Until recently he was Data Architect at Resonate, an online media company using PostgreSQL to drive its transactional and data warehousing databases. Before that, he helped drive global mobile text messaging at Sybase365.

Reviewing PostgreSQL Patches for Fun and Profit (PGConf.EU 2016)

The PostgreSQL community actively encourages patch contribution, but one area where we frequently fall short is finding enough patch reviewers. Patch review is extremely important and also a great way to become familiar with the community and the code base. This talk will walk through how to review a patch even if you are not comfortable coding in C or have never even looked at the PostgreSQL source.

Bio:

David Steele is Senior Data Architect at Crunchy Data Solutions, the PostgreSQL company for secure enterprises. He has been actively developing with PostgreSQL since 1999.

David loves taking on big data challenges. Previously he was Data Architect at Resonate, an online media company using PostgreSQL to drive its transactional and data warehousing databases. Before that, he helped drive global mobile text messaging at Sybase365.

Reviewing PostgreSQL Patches for Fun and Profit (PostgresOpen 2016)

The PostgreSQL community actively encourages patch contribution, but one area where we frequently fall short is finding enough patch reviewers. Patch review is extremely important and also a great way to become familiar with the community and the code base. This talk will walk through how to review a patch even if you are not comfortable coding in C or have never even looked at the PostgreSQL source.

Bio:

David Steele is Senior Data Architect at Crunchy Data Solutions, the PostgreSQL company for secure enterprises. He has been actively developing with PostgreSQL since 1999.

David loves taking on big data challenges. Previously he was Data Architect at Resonate, an online media company using PostgreSQL to drive its transactional and data warehousing databases. Before that, he helped drive global mobile text messaging at Sybase365.

Efficiently Backing up Terabytes of Data with pgBackRest (PostgresOpen 2016)

pgBackRest is open source software developed to perform efficient backup on PostgreSQL databases that measure in tens of terabytes and greater. It supports per file checksums, compression, partial/failed backup resume, high-performance parallel transfer, asynchronous archiving, tablespaces, expiration, full/differential/incremental, local/remote operation via SSH, hard-linking, restore, and more. pgBackRest is written in Perl and does not depend on rsync or tar but instead performs its own deltas which gives it maximum flexibility. This talk by the author will introduce the features, give sample configurations, and discuss design philosophy.

Bio:

David Steele is Senior Data Architect at Crunchy Data Solutions, the PostgreSQL company for secure enterprises. He has been actively developing with PostgreSQL since 1999.

David loves taking on big data challenges. Until recently he was Data Architect at Resonate, an online media company using PostgreSQL to drive its transactional and data warehousing databases. Before that, he helped drive global mobile text messaging at Sybase365.

David's current project is pgBackRest, which will be the subject of this talk.

Audit Logging for PostgreSQL (PGCon 2016)

Many of us have had auditors ask for information that is difficult to provide with core PostgreSQL. Who made changes to table X in the last six months? When was table Y's DDL last modified and was that during a maintenance window? Who has viewed table Z?

An extension available for PostgreSQL 9.5, pgaudit, seeks to answer these and many other questions by providing more detailed logging and finer control of what is logged than is currently available. This talk will examine pgaudit design and usage before presenting practical examples.

Bio:

David Steele is Senior Data Architect at Crunchy Data Solutions, the PostgreSQL company for secure enterprises. He has been actively developing with PostgreSQL since 1999.

David loves taking on big data challenges. Until recently he was Data Architect at Resonate, an online media company using PostgreSQL to drive its transactional and data warehousing databases. Before that, he helped drive global mobile text messaging at Sybase365.

Efficiently Backing up Terabytes of Data with pgBackRest (PGConf US 2016)

pgBackRest is open source software developed to perform efficient backup on PostgreSQL databases that measure in tens of terabytes and greater. It supports per file checksums, compression, partial/failed backup resume, high-performance parallel transfer, asynchronous archiving, tablespaces, expiration, full/differential/incremental, local/remote operation via SSH, hard-linking, restore, and more. pgBackRest is written in Perl and does not depend on rsync or tar but instead performs its own deltas which gives it maximum flexibility. This talk by the author will introduce the features, give sample configurations, and discuss design philosophy.

Bio:

David Steele is Senior Data Architect at Crunchy Data Solutions, the PostgreSQL company for secure enterprises. He has been actively developing with PostgreSQL since 1999.

David loves taking on big data challenges. Until recently he was Data Architect at Resonate, an online media company using PostgreSQL to drive its transactional and data warehousing databases. Before that, he helped drive global mobile text messaging at Sybase365.

David's current project is pgBackRest, which will be the subject of this talk.

Efficiently Backing up Terabytes of Data with pgBackRest (LISA 2015)

pgBackRest is open source software developed to perform efficient backup on PostgreSQL databases that measure in tens of terabytes and greater. It supports per file checksums, compression, partial/failed backup resume, high-performance parallel transfer, asynchronous archiving, tablespaces, expiration, full/differential/incremental, local/remote operation via SSH, hard-linking, restore, and more. pgBackRest is written in Perl and does not depend on rsync or tar but instead performs its own deltas which gives it maximum flexibility. This talk by the author will introduce the features, give sample configurations, and discuss design philosophy.

Bio:

David Steele is Senior Data Architect at Crunchy Data Solutions, the PostgreSQL company for secure enterprises. He has been actively developing with PostgreSQL since 1999.

David loves taking on big data challenges. Until recently he was Data Architect at Resonate, an online media company using PostgreSQL to drive its transactional and data warehousing databases. Before that, he helped drive global mobile text messaging at Sybase365.

David's current project is pgBackRest, which will be the subject of his talk.

Efficiently Backing up Terabytes of Data with pgBackRest (PGConf.EU 2015)

pgBackRest is open source software developed to perform efficient backup on PostgreSQL databases that measure in tens of terabytes and greater. It supports per file checksums, compression, partial/failed backup resume, high-performance parallel transfer, asynchronous archiving, tablespaces, expiration, full/differential/incremental, local/remote operation via SSH, hard-linking, restore, and more. pgBackRest is written in Perl and does not depend on rsync or tar but instead performs its own deltas which gives it maximum flexibility. This talk by the author will introduce the features, give sample configurations, and discuss design philosophy.

Bio:

David Steele is Senior Data Architect at Crunchy Data Solutions, the PostgreSQL company for secure enterprises. He has been actively developing with PostgreSQL since 1999.

David loves taking on big data challenges. Until recently he was Data Architect at Resonate, an online media company using PostgreSQL to drive its transactional and data warehousing databases. Before that, he helped drive global mobile text messaging at Sybase365.

David's current project is pgBackRest, which will be the subject of his talk.

Audit Logging for PostgreSQL (PostgresOpen 2015)

Many of us have had auditors ask for information that is difficult to provide with core PostgreSQL. Who made changes to table X in the last six months? When was table Y's DDL last modified and was that during a maintenance window? Who has viewed table Z?

An extension available for PostgreSQL 9.5, pgaudit, seeks to answer these and many other questions by providing more detailed logging and finer control of what is logged than is currently available. This talk will examine pgaudit design and usage before presenting practical examples.

Bio:

David Steele is Senior Data Architect at Crunchy Data Solutions, the PostgreSQL company for secure enterprises. He has been actively developing with PostgreSQL since 1999.

David loves taking on big data challenges. Until recently he was Data Architect at Resonate, an online media company using PostgreSQL to drive its transactional and data warehousing databases. Before that, he helped drive global mobile text messaging at Sybase365.