pg_dump not properly dumping unlogged partitioned tables

Поиск
Список
Период
Сортировка
Искать

pg_dump not properly dumping unlogged partitioned tables

От:
"Quentin de Metz" <quentin@de.me.tz>
Дата:
Вложения:
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


Re: pg_dump not properly dumping unlogged partitioned tables

От:
Steve Baldwin <steve.baldwin@gmail.com>
Дата:
Вложения:
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


FAQ