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.