On Friday, November 6, 2020, Sri Linux <srilinu...@gmail.com> wrote: > Added'' > > 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. > > ps -ef|grep -i sql > root 25412 15199 0 14:59 pts/1 00:00:00 su postgres -c > /usr/pgsql-9.4/bin/postgres --single -O -D /pgsql/9.4/data postgres > postgres 25413 25412 53 14:59 ? 02:50:00 > /usr/pgsql-9.4/bin/postgres --single -O -D /pgsql/9.4/data postgres > > On Fri, Nov 6, 2020 at 8:17 PM Sri Linux <srilinu...@gmail.com> wrote: > >> Hi All >> >> 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. David J.
