pg_dump, pg_dumpall, pg_restore --filter

Recorded source states and original language descriptions. Missing version evidence stays unknown.

The source snapshot records transitions for PostgreSQL 8.1–18. The historical matrix records independent cells for 7.4–18. Neither records support for PostgreSQL 19 or 20; newer versions remain unknown. These source claims are distinct from runtime measurements.

Backup, Restore, & Data Integrity

Description

Allow pg_dump, pg_dumpall, and pg_restore to specify include/exclude objects in a file using the --filter option.

Selected version: PostgreSQL 18

Yes

20	19	18	17	16	15	14	13	12	11	10	9.6	9.5	9.4	9.3	9.2	9.1	9.0	8.4	8.3	8.2	8.1	8.0	7.4
Unknown	Unknown	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown

Compare versions

Original documentation links

Recorded legacy identifiers: 437

Complete source facts and provenance

yaml · center · 1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd

{
  "Key": "pg_dump-pg_dumpall-pg_restore-filter",
  "SourceKind": "yaml",
  "SourceDatabase": "center",
  "SourceTable": "featurematrix.yaml",
  "SourceKey": "pg_dump, pg_dumpall, pg_restore --filter",
  "SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
  "Name": "pg_dump, pg_dumpall, pg_restore --filter",
  "NameLocale": "en",
  "GroupKey": "backup-restore-data-integrity",
  "GroupName": "Backup, Restore, \u0026 Data Integrity",
  "GroupLocale": "en",
  "Ordinal": 15,
  "GroupOrder": 10,
  "Facts": {
    "feature": {
      "description": "Allow [pg_dump](https://www.postgresql.org/docs/current/app-pgdump.html), [pg_dumpall](https://www.postgresql.org/docs/current/app-pg-dumpall.html), and [pg_restore](https://www.postgresql.org/docs/current/app-pgrestore.html) to specify include/exclude objects in a file using the `--filter` option.",
      "name": "pg_dump, pg_dumpall, pg_restore --filter",
      "versions": {
        "17": "Yes"
      }
    },
    "group": "Backup, Restore, \u0026 Data Integrity",
    "versions": {
      "max": 18,
      "min": 8.1
    }
  },
  "Cells": [
    {
      "Version": "10",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "11",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "12",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "13",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "14",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "15",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "16",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "17",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "17",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "18",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "17",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "8.1",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "8.2",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "8.3",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "8.4",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "9.0",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "9.1",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "9.2",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "9.3",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "9.4",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "9.5",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "9.6",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    }
  ],
  "Texts": [
    {
      "Locale": "en",
      "Title": "pg_dump, pg_dumpall, pg_restore --filter",
      "BodyHTML": "\u003cp\u003eAllow \u003ca href=\"https://www.postgresql.org/docs/current/app-pgdump.html\" rel=\"nofollow\"\u003epg_dump\u003c/a\u003e, \u003ca href=\"https://www.postgresql.org/docs/current/app-pg-dumpall.html\" rel=\"nofollow\"\u003epg_dumpall\u003c/a\u003e, and \u003ca href=\"https://www.postgresql.org/docs/current/app-pgrestore.html\" rel=\"nofollow\"\u003epg_restore\u003c/a\u003e to specify include/exclude objects in a file using the \u003ccode\u003e--filter\u003c/code\u003e option.\u003c/p\u003e\n",
      "SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
      "ContentHash": "afb858849fb208607ba42f96ed40d55abebee072990bfa6d4858dbe21060a943",
      "Payload": {
        "description": "Allow [pg_dump](https://www.postgresql.org/docs/current/app-pgdump.html), [pg_dumpall](https://www.postgresql.org/docs/current/app-pg-dumpall.html), and [pg_restore](https://www.postgresql.org/docs/current/app-pgrestore.html) to specify include/exclude objects in a file using the `--filter` option.",
        "name": "pg_dump, pg_dumpall, pg_restore --filter",
        "versions": {
          "17": "Yes"
        }
      }
    },
    {
      "Locale": "zh-Hans",
      "Title": "pg_dump、pg_dumpall、pg_restore --filter",
      "BodyHTML": "\u003cp\u003e\u003ccode\u003epg_dump\u003c/code\u003e、\u003ccode\u003epg_dumpall\u003c/code\u003e 和 \u003ccode\u003epg_restore\u003c/code\u003e 新增 \u003ccode\u003e--filter\u003c/code\u003e 选项，可按规则包含或排除对象。\u003c/p\u003e\n",
      "SourceHash": "071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50",
      "ContentHash": "31ba005ceda4bfdf752fedf0a5b9b1278dcf52bd20c661477fc12b20cb6bf1e6",
      "Payload": {
        "description": "`pg_dump`、`pg_dumpall` 和 `pg_restore` 新增 `--filter` 选项，可按规则包含或排除对象。",
        "name": "pg_dump、pg_dumpall、pg_restore --filter"
      }
    }
  ],
  "GroupTitles": {
    "en": "Backup, Restore, \u0026 Data Integrity",
    "zh-Hans": "备份、恢复和数据完整性"
  },
  "LegacyIDs": [
    "437"
  ]
}

Complete source data JSON