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 CAKFQuwbSAW-uFB=W4U4TDH_N69x8EkjgQwjpwX=kKEcMO+iG_Q@mail.gmail.com
Whole thread Raw
In response to Re: 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 Wed, Dec 2, 2020 at 5:06 PM Ron <ronljohnsonjr@gmail.com> wrote:
On 12/2/20 5:35 PM, David G. Johnston wrote:
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

That's right.  What's your point?


That you were comparing apples and oranges - specifically that the database you were dumping was empty but the one you were checking was not.

David J.

pgsql-general by date:

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