From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pg_dump of partitioned table not working. |
Date: | 2020-12-03 00:38:14 |
Message-ID: | 475c9525-5573-77e0-3eec-7cffd3ee2006@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
>
>>
>> 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.
>
>
--
Angular momentum makes the world go 'round.
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2020-12-03 00:52:53 | Re: pg_dump of partitioned table not working. |
Previous Message | Ron | 2020-12-03 00:36:00 | Re: pg_dump of partitioned table not working. |