On 12/2/20 6:08 PM, David G. Johnston wrote:
On 12/2/20 5:35 PM, David G. Johnston wrote:
On Wednesday, December 2, 2020, Ron <ronljohnsonjr@gmail.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.
While I could have shown the exact psql commands (
/usr/lib/postgresql/12/bin/psql -p5433) it wasn't necessary.
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.