Re: pg_dump of partitioned table not working.

On 12/2/20 4:38 PM, Ron wrote:
> On 12/2/20 6:21 PM, Adrian Klaver wrote:
>> On 12/2/20 4:13 PM, Ron wrote:
>>> 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:
>>
>>>> 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.
>>
>> From the POV of the mailing list participants it was necessary as the
>> below constitutes hidden information we didn't have access to. When
>> presenting a issue explicit is better then implicit. I cannot count
>> the number of times issues where solved on this list when someone got
>> around to asking for a explicit command.
>
> Shame on me for assuming, based on the explicit pg_dump command in the
> example.

The implied part was this:

postgres=# \d+ measurement

There was no indication of how you got there. You knew but we didn't and
given how many times it has happened that folks where looking at one
instance in one part of their problem report and another instance in
separate part of the report it is only prudent to ask.

>
>>
>>>
>>> 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.
>>
>>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com