tableam: Add pg_dump support

Enterprise / PostgreSQL - Andres Freund [] - 6 March 2019 17:54 EST

This adds pg_dump support for table AMs in a similar manner to how tablespaces are handled. That is, instead of specifying the AM for every CREATE TABLE etc, emit SET default_table_access_method statements. That makes it easier to change the AM for all/most tables in a dump, and allows restore to succeed even if some AM is not available.

This increases the dump archive version, as a tables/matview's AM needs to be tracked therein.

Author: Dimitri Dolgov, Andres Freund Discussion:

3b925e905d tableam: Add pg_dump support.
src/bin/pg_dump/pg_backup_archiver.c | 57 +++++++++++++++++++++++++++++++++-
src/bin/pg_dump/pg_backup_archiver.h | 6 +++-
src/bin/pg_dump/pg_dump.c | 22 +++++++++++--
src/bin/pg_dump/pg_dump.h | 1 +
src/bin/pg_dump/t/ | 60 ++++++++++++++++++++++++++++++++++++
5 files changed, 142 insertions(+), 4 deletions(-)


  • Share