On 12/2/20 6:08 PM, David G. Johnston wrote:
On Wed, Dec 2, 2020 at 5:06 PM Ron <[email protected] <mailto:[email protected]>> wrote:On 12/2/20 5:35 PM, David G. Johnston wrote:On Wednesday, December 2, 2020, Ron <[email protected] <mailto:[email protected]>> 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 clustersThat'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.
