No upcoming presentations...

    Backups are a critical part of any enterprise database solution but they are often done poorly or skipped altogether, which can lead to data loss in the event of hardware failure or some other disaster. With the proper tools and procedures data loss can be minimized or entirely avoided, saving valuable enterprise data and time.

    In this talk we'll cover database backup best practices and how ...

    @ CHINA 2020 And PGConf.Asia 2020

    Nov 20 2020

    Backup and Restores

    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 fine...

    @ PGConf US 2017 [PgConf.US]
    Development

    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 mor...

    @ PGConf US 2016 [PgConf.US]
    Operations

    There are many advantages to maintaining full build scripts for your database. They allow you to create your database from scratch, run unit tests, and serve as a useful reference to the current state of the database. However, in production full build scripts are only run once per database. After that it is an endless sequence of update scripts. How do you to keep the full build and update scri...

    @ PGConf NYC 2014 [PgConf.US]
    Developer