Re: pg_dump of partitioned table not working.

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.

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