Re: pg_dump of partitioned table not working.

On 12/2/20 6:08 PM, David G. Johnston wrote:

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.

While I could have shown the exact psql commands (/usr/lib/postgresql/12/bin/psql -p5433) it wasn't necessary.

I know that was the command, because I use a set of aliases:

alias pgdump12='/usr/lib/postgresql/12/bin/pg_dump -p5433'
alias pgdump96='/usr/lib/postgresql/9.6/bin/pg_dump -p5432'
alias pgrestore12='/usr/lib/postgresql/12/bin/pg_restore -p5433'
alias pgrestore96='/usr/lib/postgresql/9.6/bin/pg_restore -p5432'
alias psql12='/usr/lib/postgresql/12/bin/psql -p5433'
alias psql96='/usr/lib/postgresql/9.6/bin/psql -p5432'