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(at)gmail(dot)com
> <mailto:ronljohnsonjr(at)gmail(dot)com>> wrote:
>
> On 12/2/20 5:35 PM, David G. Johnston wrote:
>> On Wednesday, December 2, 2020, Ron <ronljohnsonjr(at)gmail(dot)com
>> <mailto:ronljohnsonjr(at)gmail(dot)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.