Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump of partitioned table not working. - Mailing list pgsql-general

From David G. Johnston
Subject Re: pg_dump of partitioned table not working.
Date
Msg-id CAKFQuwbTMAxAr7tM8EthAi0vc4GRGKeA2GeqfZkpoaX=6BcjZg@mail.gmail.com
Whole thread Raw
In response to pg_dump of partitioned table not working.  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: pg_dump of partitioned table not working.  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
Tree view
On Wednesday, December 2, 2020, Ron <ronljohnsonjr@gmail.com> wrote:
What am I missing?

(Specifying the whole file name because multiple versions are installed.)

$ /usr/lib/postgresql/12/bin/pg_dump --version
pg_dump (PostgreSQL) 12.5 (Ubuntu 12.5-1.pgdg18.04+1)

postgres=# \d+ measurement
                          

psql? on (default) port 5432 


 
$ /usr/lib/postgresql/12/bin/pg_dump -p5433 -d postgres -t measurement --data-only


 pg_dump on port 5433

Usually different ports means different clusters

David J.

pgsql-general by date:

Previous
From: Ron
Date:
Subject: pg_dump of partitioned table not working.
Next
From: Tom Lane
Date:
Subject: Re: pg_dump of partitioned table not working.