• Photos
  • Schedule
  • Talks
  • Speakers
  • Contacts
  • F.A.Q.
  • Profile
  • En Ru

    Alexander Alekseev

    Alexander Alekseev Postgres Professional

    7 July

    Talk

    How data is stored in PostgreSQL and how to recover it using pg_filedump

    In this talk I would like to tell you about how different data types (int, varchar, etc) are physically stored in PostgreSQL, how NULL support is implemented and why this knowledge is useful in practice. Also you will learn how your data could be restored using new possibilities of pg_filedump utility, even if PostgreSQL instance is not starting and tables names and their schema are unknown.

    In this talk I would like to tell you about how different data types (int, varchar, etc) are physically stored in PostgreSQL, how NULL support is implemented and why this knowledge is useful in practice. Also you will learn how your data could be restored using new possibilities of pg_filedump utility, even if PostgreSQL instance is not starting and tables names and their schema are unknown.

    Back to the list of talks

    Buy tutorial:

    Price:
    Enter your e-mail and we will send you payment details soon.