# Waiting for PostgreSQL 19 - Add non-text output formats to pg\_dumpall

DevFeed: [Waiting for PostgreSQL 19 - Add non-text output formats to pg\_dumpall](<https://devfeed.tech/articles/waiting-for-postgresql-19-add-non-text-output-formats-to-pg-dumpall-33679.md>)

Original publisher: [Read original article](<https://www.depesz.com/2026/03/17/waiting-for-postgresql-19-add-non-text-output-formats-to-pg_dumpall/>)

Author: depesz

Published: 2026-03-17T10:29:38Z

Content type: article

Language: en

Sources: [select \* from depesz;](<https://devfeed.tech/sources/select-from-depesz.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [backups](<https://devfeed.tech/topics/backups.md>), [Databases](<https://devfeed.tech/topics/databases.md>)

Tags: [backup](<https://devfeed.tech/tags/backup.md>), [backups](<https://devfeed.tech/tags/backups.md>), [compression](<https://devfeed.tech/tags/compression.md>), [maintenance](<https://devfeed.tech/tags/maintenance.md>), [pg-dump](<https://devfeed.tech/tags/pg-dump.md>), [pg-dumpall](<https://devfeed.tech/tags/pg-dumpall.md>), [pg19](<https://devfeed.tech/tags/pg19.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>), [waiting](<https://devfeed.tech/tags/waiting.md>)

## AI overview

The article examines a PostgreSQL 19 patch that adds custom, directory, and tar output formats to pg_dumpall. It describes the resulting files and explains how the formats can support more selective restoration and simpler backups.

## Source excerpt

On 26th of February 2026, Andrew Dunstan committed patch: Add non-text output formats to pg_dumpall pg_dumpall can now produce output in custom, directory, or tar formats in addition to plain text SQL scripts. When using non-text formats, pg_dumpall creates a directory containing: - toc.glo: global data (roles and tablespaces) in custom format - map.dat: ... Continue reading "Waiting for PostgreSQL 19 - Add non-text output formats to pg_dumpall"