Re: Single user model vaccum
| От | Sri Linux |
|---|---|
| Тема | Re: Single user model vaccum |
| Дата | |
| Msg-id | CAFcfow_k_b0gT5QcJnxP+gRNhNz7sjDgmXEezy2zSfH3=8s8+Q@mail.gmail.com обсуждение исходный текст |
| Ответ на | Single user model vaccum (Sri Linux <srilinux09@gmail.com>) |
| Ответы |
Re: Single user model vaccum
|
| Список | pgsql-general |
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
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 AllHow 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.RegardsSri
В списке pgsql-general по дате отправления: