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@xxxxxxxxx
<mailto:ronljohnsonjr@xxxxxxxxx>> 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.klaver@xxxxxxxxxxx
