title

text

Robert Haas
Robert Haas EnterpriseDB
17:00 02 March
45 мин

Avoiding, Detecting, and Recovering From Corruption

PostgreSQL databases can become corrupted for a variety of reasons, including hardware failure, software failure, and user error. In this talk, I’ll talk about some of my experiences with database corruption. In particular, I’ll mention some of the things which seem to be common causes of database corruption, such as procedural errors taking or restoring backups; some of the ways that database corruption most often manifests when it does occur, such as errors indicating inconsistencies between a table and its indexes or a table and its toast table; and a little bit about techniques that I have seen used to repair databases or recover from corruption, including some experiences with pg_resetxlog. This talk will be based mostly on my experiences working with EnterpriseDB customers; I hope that it will be useful to hackers from the point of view of thinking about possible improvements to PostgreSQL, and to end users from the point of view of helping them avoid, diagnose, and cope with corruption.

Материалы к докладу

Видео

Другие доклады

  • Anton Doroshkevich
    Anton Doroshkevich ИнфоСофт
    Teodor Sigaev
    Teodor Sigaev Postgres Professional
    45 мин

    1С ERP Platform + Postgres = ...

    CTO Postgres Professional Teodor Sigaev and 1C ERP platform expert Anton Doroshkevich will discuss the existing maintenance issues for 1C ERP on Postgres and their potential solutions.

  • Ivan Frolkov
    Ivan Frolkov Postgres Professional
    22 мин

    Trying to gain peace of mind by using constraints

    There's a common delusion that constraints should never be used as they affect performance in a negative way, interfere with regular work, and are, all in all, useless. The database is commonly perceived as just a storage without any logic. I'll explain why it isn't so and what this careless approach may lead to.

  • Ivan Panchenko
    Ivan Panchenko Postgres Professional
    22 мин

    Postgres Pro DBMS: what’s new & what’s on the roadmap

    In this talk, you'll learn about Postgres Pro DBMS from the co-founder of Postgres Professional. Ivan will explain the philosophy behind this enhanced variant of PostgreSQL, reveal the differences between Postgres and Postgres Pro and provide the roadmap for the further evolution of Postgres Pro DBMS.

  • Robert Bernier
    Robert Bernier Percona
    45 мин

    pg_upgrade, Advanced Techniques

    When it comes to performing postgres upgrades between major versions the command line utility pg_upgrade is the most popular method used today. But as with all things wonderful, there are caveats. One of the more critical issues is what to do when there's a failure. The purpose of this talk is to present those little covered "tricks" of the trade that allows one to improve and enhance the upgrade experience.

    We'll start out by reviewing its basic mode operation. We'll then learn what makes it so darn fast when upgrading multi-terabyte datacluster in a matter of minutes. Finally, you will be introduced to those feared failures and how to deal with them with confidence and certainty.

    Herein is a summary of the topics in this talk:

    • How pg_upgrade works: the big picture
    • About pgupgrade (comand line invocation)

      • arguments and options

    • The steps performing an upgrade
    • About the replication ROLE

      • with replication
      • with login

    • Upgrade options: COPY vs Hard Link
    • Post-upgrade

      • about performance
      • aboutanalyze
      • repack
      • reindexing

    • When something goes wrong at the point of no return (or is it?)
    • Upgrading the REPLICA
      • default method: pg_basebackup
      • the cool method:
        • - leveraging rsync
        • caveat; about vacuum wraparound