Re: pg_dump of partitioned table not working.

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Ron <ronljohnsonjr(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_dump of partitioned table not working.
Date: 2020-12-02 23:42:42
Message-ID: CAKFQuwYP_R_pfgCAoHm68gtO7rvYYxX-7WL-p3y3UqOHOoAfRg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday, December 2, 2020, Ron <ronljohnsonjr(at)gmail(dot)com> wrote:

> What am I missing?
>
> postgres=# \d+ measurement
> Partitioned table "public.measurement"
>
>
> $ /usr/lib/postgresql/12/bin/pg_dump -p5433 -d postgres -t measurement
> --data-only
>

I’m unsure whether to expect a dump of only the partitioned table’s data to
be empty or include everything. I suspect “empty” is the correct answer.
If you dump everything the individual tables would be dumped, and not all
partition should be dumped.

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dave Cramer 2020-12-02 23:46:48 Re: "Server versions prior to 8.0 do not support savepoints" when using JDBC ...
Previous Message Tom Lane 2020-12-02 23:42:28 Re: pg_dump of partitioned table not working.