From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | Ron <ronljohnsonjr(at)gmail(dot)com> |
Cc: | "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:08:50 |
Message-ID: | CAKFQuwbSAW-uFB=W4U4TDH_N69x8EkjgQwjpwX=kKEcMO+iG_Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Dec 2, 2020 at 5:06 PM Ron <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> 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.
David J.
From | Date | Subject | |
---|---|---|---|
Next Message | Ron | 2020-12-03 00:09:23 | Re: pg_dump of partitioned table not working. |
Previous Message | Ron | 2020-12-03 00:06:51 | Re: pg_dump of partitioned table not working. |