From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | Sri Linux <srilinux09(at)gmail(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Single user model vaccum |
Date: | 2020-11-07 03:15:19 |
Message-ID: | CAKFQuwYz2xK4PhuB0ZZNTtr+K5uKnU1Dkcb99j0_FckOmwSsUA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Friday, November 6, 2020, Sri Linux <srilinux09(at)gmail(dot)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 <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.
>>
>
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Sri Linux | 2020-11-07 03:48:59 | Re: Single user model vaccum |
Previous Message | Sri Linux | 2020-11-07 02:25:32 | Re: Single user model vaccum |