Request a Demo
Home   >   mailing lists

Re: pg_dump not properly dumping unlogged partitioned tables - Mailing list pgsql-novice

From Steve Baldwin
Subject Re: pg_dump not properly dumping unlogged partitioned tables
Date
Msg-id CAKE1AiYJqzOz6GS57rmvRM1LqhWStKFxypG3ONUs98thrLAM+A@mail.gmail.com
Whole thread
In response to pg_dump not properly dumping unlogged partitioned tables  ("Quentin de Metz" <quentin@de.me.tz>)
List pgsql-novice
Tree view
Not sure what this means but the v18 docs say that unlogged is not supported for partitioned tables, so maybe this was true for v17 but not documented. 

On Mon, 27 Jul 2026 at 06:45, Quentin de Metz <quentin@de.me.tz> wrote:
Hello,

It seems as if pg_dump is not properly dumping the UNLOGGED flag on partitioned tables.

Please find a reproduction script:

$ createdb foobar
$ psql postgresql://localhost:5432/foobar
# SHOW server_version;
         server_version
---------------------------------
 17.10 (Debian 17.10-1.pgdg12+1)
# CREATE UNLOGGED TABLE zde (id bigint) PARTITION BY RANGE(id);
[...]
$ pg_dump --version
pg_dump (PostgreSQL) 18.4
$ pg_dump --no-data 'dbname=foobar'
[...]
CREATE TABLE public.zde (
    id bigint
)
PARTITION BY RANGE (id);
[...]

Kind regards,
Quentin de Metz


pgsql-novice by date:

Previous
From: "Quentin de Metz"
Date:
Subject: pg_dump not properly dumping unlogged partitioned tables