pg_dump segfaults with publication

Started by Amit Langoteover 9 years ago2 messageshackers
Beta feature

Hackorum builds and tests every patch posted to the lists, not only commitfest submissions. This is Hackorum's own CI rather than the PostgreSQL project's, and it is still under testing - please report anything that looks wrong.

won't retrysuccessCI history

You can run a PostgreSQL built from this patch straight from Docker, with no checkout and no build:

docker run --rm -p 5432:5432 ghcr.io/hackorum-dev/postgres-patch:t36183
psql -h localhost -U postgres

Built from patchset v1 (message #1), July 28, 2026 at 07:58 AM.

Every patchset is also pushed to a branch of our PostgreSQL fork, so you can check out the same tree CI built. Without a PostgreSQL checkout:

git clone --branch t36183_1 https://github.com/hackorum-dev/postgres.git

In a checkout you already have, add the fork once:

git remote add hackorum https://github.com/hackorum-dev/postgres.git

then, for this patchset and every later one:

git fetch hackorum t36183_1 && git checkout t36183_1

Patchset v1 (message #1) is on t36183_1

Jump to latest
#1Amit Langote
Langote_Amit_f8@lab.ntt.co.jp

Hi,

pg_dump segfaults if there are more than one DO_PUBLICATION_REL objects to
dump.

create table foo (a int);
create publication foo_pub;
alter publication foo_pub add table foo;

$ pg_dump
<OK>

create table bar (a int);
alter publication foo_pub add table bar;

$ pg_dump -s
Segmentation fault (core dumped)

The reason is DumpableObject.name is not set being set in
getPublicationTables(). Attached patch fixes that.

Thanks,
Amit

Attachments:

t36183_1
0001-Set-DumpableObject.name-for-PublicationRelInfo-objec.patchtext/x-diff; name=0001-Set-DumpableObject.name-for-PublicationRelInfo-objec.patchDownload+1-1
#2Peter Eisentraut
peter_e@gmx.net
In reply to: Amit Langote (#1)
Re: pg_dump segfaults with publication

On 3/6/17 03:06, Amit Langote wrote:

pg_dump segfaults if there are more than one DO_PUBLICATION_REL objects to
dump.

Fix committed with a test case. Thanks.

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers