Subject: Re: Non-text mode for pg_dumpall

From: Andrew Dunstan <[email-masked]>
Date: Tue, 6 Jan 2026 11:33:38 -0500

On 2026-01-06 Tu 1:26 AM, Mahendra Singh Thalor wrote:
>
>> It's probably harmless, we connect to the databases further down to do actual work. But it's also not nice. The toc.glo seems to have a bunch of extraneous entries of type COMMENT and CONNECT. Why is that? As far as poible this should have output pretty much  identical to a plain pg_dumpall.
>>
>>
> If we don't dump those comments in non-text format, then the output of
> "pg_restore -f filename dump_non_text" will not be the same as the
> plain dump of pg_dumpall.
>
> Here, I am attaching an updated patch for the review and testing.
>
> Note: some of the review comments are still not fixed. I am working on
> those and will post an updated patch.

But these cases are not producing anything like identical output.

here is the diff produced by my standard test case. (I have modified the 
output to unify the resttrict/unrestrict keys)

cheers

andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com
--- textout	2026-01-06 11:22:59.443353974 -0500
+++ restore_out	2026-01-06 11:22:53.249383868 -0500
@@ -1,42 +1,907 @@
 --
--- PostgreSQL database cluster dump
+-- PostgreSQL database dump
 --
 
 \restrict xxxxx
 
-SET default_transaction_read_only = off;
+-- Dumped by pg_dump version 19devel
 
+SET statement_timeout = 0;
+SET lock_timeout = 0;
+SET idle_in_transaction_session_timeout = 0;
+SET transaction_timeout = 0;
 SET client_encoding = 'SQL_ASCII';
 SET standard_conforming_strings = on;
+SET check_function_bodies = false;
+SET xmloption = content;
+SET client_min_messages = warning;
+SET row_security = off;
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- PostgreSQL database cluster dump
+--
+
+
+
+--
+-- Name: DEFAULT_TRANSACTION_READ_ONLY; Type: DEFAULT_TRANSACTION_READ_ONLY; Schema: -; Owner: -
+--
+
+SET default_transaction_read_only = off;
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
 
 --
 -- Roles
 --
 
+
+
+--
+-- Name: dumpRoles; Type: dumpRoles; Schema: -; Owner: -
+--
+
 CREATE ROLE andrew;
 ALTER ROLE andrew WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN NOREPLICATION NOBYPASSRLS;
-CREATE ROLE buildfarm;
-ALTER ROLE buildfarm WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN REPLICATION BYPASSRLS;

+--
+-- Name: dumpRoles; Type: dumpRoles; Schema: -; Owner: -
+--
 
+CREATE ROLE buildfarm;
+ALTER ROLE buildfarm WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN REPLICATION BYPASSRLS;

+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
 
+--
+-- Databases
+--

-\unrestrict xxxxx
 
 --
--- Databases
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
 --
 
 --
 -- Database "template1" dump
 --
 
+
+
+--
+-- Name: CONNECT; Type: CONNECT; Schema: -; Owner: -
+--
+
 \connect template1
 
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "andrew" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "isolation_regression_brin" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "isolation_regression_delay_execution" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "isolation_regression_index" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "isolation_regression_pgrowlocks" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "isolation_regression_postgres_fdw" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "isolation_regression_tcn" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "postgres" dump
+--
+
+
+
+--
+-- Name: CONNECT; Type: CONNECT; Schema: -; Owner: -
+--
+
+\connect postgres
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_amcheck" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_auto_explain" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_bloom" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_bool_plperl" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_btree_gin" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_btree_gist" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_citext" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_cube" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_dblink" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_dict_int" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_dict_xsyn" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_dummy_index_am" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_dummy_seclabel" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_earthdistance" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_file_fdw" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_fuzzystrmatch" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_gin" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_hstore" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_hstore_plperl" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_intarray" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_isn" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_jsonb_plperl" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_lo" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_ltree" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_nbtree" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_pageinspect" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_passwordcheck" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_pg_buffercache" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_pg_overexplain" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_pg_prewarm" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_pg_surgery" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_pg_trgm" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_pg_visibility" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_pgcrypto" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_pgstattuple" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_plperl" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_plpgsql" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_plsample" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_pltcl" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_postgres_fdw" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_seg" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_spgist_name_ops" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_spi" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_tablefunc" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_test_binaryheap" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_test_bitmapset" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_test_bloomfilter" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_test_copy_callbacks" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_test_ddl_deparse" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_test_dsa" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_test_dsm_registry" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_test_extensions" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_test_ginpostinglist" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_test_integerset" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_test_lfind" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_test_parser" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_test_pg_dump" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_test_predtest" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_test_radixtree" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_test_rbtree" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_test_regex" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_test_resowner" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_test_rls_hooks" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_test_shm_mq" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_test_tidstore" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_tsm_system_rows" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_tsm_system_time" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_typcache" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_unaccent" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- Database "regression_xml2" dump
+--
+
+
+
+--
+-- Name: COMMENT; Type: COMMENT; Schema: -; Owner: -
+--
+
+--
+-- PostgreSQL database cluster dump complete
+--
+
+
+
+--
+-- PostgreSQL database dump complete
+--
+
+\unrestrict xxxxx
+
 --
 -- PostgreSQL database dump
 --
@@ -59,14 +924,73 @@
 SET row_security = off;
 
 --
--- PostgreSQL database dump complete
+-- Name: template1; Type: DATABASE; Schema: -; Owner: buildfarm
 --
 
+CREATE DATABASE template1 WITH TEMPLATE = template0 ENCODING = 'SQL_ASCII' LOCALE_PROVIDER = libc LOCALE = 'C';
+
+
+ALTER DATABASE template1 OWNER TO buildfarm;
+
 \unrestrict xxxxx
+\connect template1
+\restrict xxxxx
+
+SET statement_timeout = 0;
+SET lock_timeout = 0;
+SET idle_in_transaction_session_timeout = 0;
+SET transaction_timeout = 0;
+SET client_encoding = 'SQL_ASCII';
+SET standard_conforming_strings = on;
+SELECT pg_catalog.set_config('search_path', '', false);
+SET check_function_bodies = false;
+SET xmloption = content;
+SET client_min_messages = warning;
+SET row_security = off;
 
 --
--- Database "andrew" dump
+-- Name: DATABASE template1; Type: COMMENT; Schema: -; Owner: buildfarm
+--
+
+COMMENT ON DATABASE template1 IS 'default template for new databases';
+
+
+--
+-- Name: template1; Type: DATABASE PROPERTIES; Schema: -; Owner: buildfarm
+--
+
+ALTER DATABASE template1 IS_TEMPLATE = true;
+
+
+\unrestrict xxxxx
+\connect template1
+\restrict xxxxx
+
+SET statement_timeout = 0;
+SET lock_timeout = 0;
+SET idle_in_transaction_session_timeout = 0;
+SET transaction_timeout = 0;
+SET client_encoding = 'SQL_ASCII';
+SET standard_conforming_strings = on;
+SELECT pg_catalog.set_config('search_path', '', false);
+SET check_function_bodies = false;
+SET xmloption = content;
+SET client_min_messages = warning;
+SET row_security = off;
+
 --
+-- Name: DATABASE template1; Type: ACL; Schema: -; Owner: buildfarm
+--
+
+REVOKE CONNECT,TEMPORARY ON DATABASE template1 FROM PUBLIC;
+GRANT CONNECT ON DATABASE template1 TO PUBLIC;
+
+
+--
+-- PostgreSQL database dump complete
+--
+
+\unrestrict xxxxx
 
 --
 -- PostgreSQL database dump
@@ -121,10 +1045,6 @@
 \unrestrict xxxxx
 
 --
--- Database "isolation_regression_brin" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -219,10 +1139,6 @@
 \unrestrict xxxxx
 
 --
--- Database "isolation_regression_delay_execution" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -303,10 +1219,6 @@
 \unrestrict xxxxx
 
 --
--- Database "isolation_regression_index" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -387,10 +1299,6 @@
 \unrestrict xxxxx
 
 --
--- Database "isolation_regression_pgrowlocks" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -485,10 +1393,6 @@
 \unrestrict xxxxx
 
 --
--- Database "isolation_regression_postgres_fdw" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -583,10 +1487,6 @@
 \unrestrict xxxxx
 
 --
--- Database "isolation_regression_tcn" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -681,12 +1581,6 @@
 \unrestrict xxxxx
 
 --
--- Database "postgres" dump
---
-
-\connect postgres
-
---
 -- PostgreSQL database dump
 --
 
@@ -708,15 +1602,43 @@
 SET row_security = off;
 
 --
--- PostgreSQL database dump complete
+-- Name: postgres; Type: DATABASE; Schema: -; Owner: buildfarm
 --
 
+CREATE DATABASE postgres WITH TEMPLATE = template0 ENCODING = 'SQL_ASCII' LOCALE_PROVIDER = libc LOCALE = 'C';
+
+
+ALTER DATABASE postgres OWNER TO buildfarm;
+
 \unrestrict xxxxx
+\connect postgres
+\restrict xxxxx
+
+SET statement_timeout = 0;
+SET lock_timeout = 0;
+SET idle_in_transaction_session_timeout = 0;
+SET transaction_timeout = 0;
+SET client_encoding = 'SQL_ASCII';
+SET standard_conforming_strings = on;
+SELECT pg_catalog.set_config('search_path', '', false);
+SET check_function_bodies = false;
+SET xmloption = content;
+SET client_min_messages = warning;
+SET row_security = off;
 
 --
--- Database "regression" dump
+-- Name: DATABASE postgres; Type: COMMENT; Schema: -; Owner: buildfarm
 --
 
+COMMENT ON DATABASE postgres IS 'default administrative connection database';
+
+
+--
+-- PostgreSQL database dump complete
+--
+
+\unrestrict xxxxx
+
 --
 -- PostgreSQL database dump
 --
@@ -25397,10 +26319,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_amcheck" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -25548,10 +26466,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_auto_explain" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -25632,10 +26546,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_bloom" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -25772,10 +26682,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_bool_plperl" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -25856,10 +26762,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_btree_gin" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -26529,10 +27431,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_btree_gist" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -27217,10 +28115,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_citext" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -27447,10 +28341,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_cube" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -27567,10 +28457,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_dblink" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -27779,10 +28665,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_dict_int" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -27877,10 +28759,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_dict_xsyn" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -27975,10 +28853,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_dummy_index_am" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -28088,10 +28962,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_dummy_seclabel" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -28249,10 +29119,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_earthdistance" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -28348,10 +29214,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_file_fdw" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -28454,10 +29316,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_fuzzystrmatch" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -28552,10 +29410,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_gin" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -28765,10 +29619,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_hstore" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -28935,10 +29785,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_hstore_plperl" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -29019,10 +29865,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_intarray" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -29151,10 +29993,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_isn" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -29235,10 +30073,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_jsonb_plperl" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -29319,10 +30153,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_lo" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -29417,10 +30247,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_ltree" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -29555,10 +30381,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_nbtree" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -29766,10 +30588,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_pageinspect" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -29850,10 +30668,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_passwordcheck" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -29934,10 +30748,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_pg_buffercache" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -30032,10 +30842,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_pg_overexplain" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -30264,10 +31070,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_pg_prewarm" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -30348,10 +31150,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_pg_surgery" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -30432,10 +31230,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_pg_trgm" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -30588,10 +31382,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_pg_visibility" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -30686,10 +31476,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_pgcrypto" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -30814,10 +31600,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_pgstattuple" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -30950,10 +31732,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_plperl" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -32612,10 +33390,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_plpgsql" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -34868,10 +35642,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_plsample" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -35041,10 +35811,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_pltcl" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -36772,10 +37538,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_postgres_fdw" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -38758,10 +39520,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_seg" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -39059,10 +39817,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_spgist_name_ops" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -39181,10 +39935,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_spi" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -39331,10 +40081,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_tablefunc" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -39566,10 +40312,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_test_binaryheap" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -39664,10 +40406,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_test_bitmapset" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -39748,10 +40486,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_test_bloomfilter" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -39846,10 +40580,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_test_copy_callbacks" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -39961,10 +40691,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_test_ddl_deparse" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -41435,10 +42161,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_test_dsa" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -41533,10 +42255,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_test_dsm_registry" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -41631,10 +42349,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_test_extensions" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -41908,10 +42622,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_test_ginpostinglist" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -42006,10 +42716,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_test_integerset" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -42104,10 +42810,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_test_lfind" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -42202,10 +42904,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_test_parser" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -42313,10 +43011,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_test_pg_dump" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -42624,10 +43318,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_test_predtest" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -42774,10 +43464,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_test_radixtree" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -42872,10 +43558,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_test_rbtree" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -42970,10 +43652,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_test_regex" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -43068,10 +43746,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_test_resowner" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -43166,10 +43840,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_test_rls_hooks" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -43250,10 +43920,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_test_shm_mq" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -43348,10 +44014,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_test_tidstore" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -43446,10 +44108,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_tsm_system_rows" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -43571,10 +44229,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_tsm_system_time" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -43697,10 +44351,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_typcache" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -43797,10 +44447,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_unaccent" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -43881,10 +44527,6 @@
 \unrestrict xxxxx
 
 --
--- Database "regression_xml2" dump
---
-
---
 -- PostgreSQL database dump
 --
 
@@ -44026,7 +44668,3 @@
 
 \unrestrict xxxxx
 
---
--- PostgreSQL database cluster dump complete
---
-