Postgres Pro
Downloads
Home   >   mailing lists

Re: Single user model vaccum - Mailing list pgsql-general

From Sri Linux
Subject Re: Single user model vaccum
Date
Msg-id CAFcfow_k_b0gT5QcJnxP+gRNhNz7sjDgmXEezy2zSfH3=8s8+Q@mail.gmail.com
Whole thread Raw
In response to Single user model vaccum  (Sri Linux <srilinux09@gmail.com>)
Responses Re: Single user model vaccum
List pgsql-general
Tree view
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@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.

Please advise.

Regards
Sri

pgsql-general by date:

Previous
From: Sri Linux
Date:
Subject: Single user model vaccum
Next
From: "David G. Johnston"
Date:
Subject: Re: Single user model vaccum