Re: Single user model vaccum

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

Thanks,
Sri

On Fri, Nov 6, 2020 at 8:17 PM Sri Linux <srilinux09(at)gmail(dot)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.
>
> Please advise.
>
> Regards
> Sri
>