when I log in to the Linux terminal and grep process, I can only see the single-user mode process running but not sure about vacuum status. I can't run a pg_stat commands from pgsql as the db is in single-user mode.
How can I monitor and make sure that the vacuum is still running if I get lost with the session to Linux putty? I would need to check if the vacuum is still running from Linux OS.
Don’t really know but a quick read suggests you will need to basically debug the running process.
In the future use something like “screen” or “tmux” so you can just re-attach to the terminal container.
I’m not sure if there is anything special about single-user mode (way to omit critical info on your first two emails) that would discourage you from just killing the server and starting a new vacuum.