Re: pg_dump of partitioned table not working.

[Ron]

On 12/2/20 6:08 PM, David G. Johnston wrote:
On Wed, Dec 2, 2020 at 5:06 PM Ron <ronljohnso...@gmail.com 
<mailto:ronljohnso...@gmail.com>> wrote:

    On 12/2/20 5:35 PM, David G. Johnston wrote:
    On Wednesday, December 2, 2020, Ron <ronljohnso...@gmail.com
    <mailto:ronljohnso...@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'

--
Angular momentum makes the world go 'round.