On 12/2/20 5:42 PM, David G. Johnston wrote:
On Wednesday, December 2, 2020, Ron <ronljohnsonjr@gmail.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.
The individual partition tables regularly (for some site-specific definition of "regularly") change, as new partitions are added and old partitions are dropped. Or the DBA decides to change the partition scheme.
Needing to remember all the partition names is absurd, especially when there might be dozens of them
--
Angular momentum makes the world go 'round.