Обсуждение: --frokbackend process

Поиск
Список
Период
Сортировка

--frokbackend process

От
satyajit patra
Дата:
Dear Team,

I am using postgres database in windows 10 but suddenly we are facing some hang issue while starting the cluster and also, we observe few below process in the task manager. Is it bad impact to the database ?

Вложения

Re: --frokbackend process

От
Justin
Дата:
Hi Satyajit:

Can't tell what is going on from the task manager list.  Looks like a normal task list for PostgreSQL.  Keep in mind PG is a process based application NOT a threaded  application.  Meaning postgresql starts/forks a new process for every connection.  This means we can see each sessions activity from the task manager. 

Need to look at the postgresql logs to see why PG may be hung or possibly query  pg_stat_activity ....  

On Wed, Jun 26, 2024 at 1:06 PM satyajit patra <satyajit.patra@sunknowledge.com> wrote:
Dear Team,

I am using postgres database in windows 10 but suddenly we are facing some hang issue while starting the cluster and also, we observe few below process in the task manager. Is it bad impact to the database ?

Вложения

Re: --frokbackend process

От
Kashif Zeeshan
Дата:
Hi

It's hard to figure out the issue by just looking on the process list, to figure out the issue you need to share the DB Server Logs and thats the why to figure out the exac issue.


Regards
Kashif Zeeshan

On Wed, Jun 26, 2024 at 10:06 PM satyajit patra <satyajit.patra@sunknowledge.com> wrote:
Dear Team,

I am using postgres database in windows 10 but suddenly we are facing some hang issue while starting the cluster and also, we observe few below process in the task manager. Is it bad impact to the database ?

Вложения

Re: --frokbackend process

От
Michael Paquier
Дата:
On Thu, Jun 27, 2024 at 09:19:45AM +0500, Kashif Zeeshan wrote:
> It's hard to figure out the issue by just looking on the process list, to
> figure out the issue you need to share the DB Server Logs and thats the why
> to figure out the exac issue.

Note that it is equally hard for anybody reading your two emails to
provide any hints about what could be going on, because you are
providing zero details about what's happening in the server, and
nobody would be able to help you with only a screenshot of running
processes.  There should be at least some logs from which you could
begin some sort of investigation, for example, to know what is
happening to your system and figure out if there is even something
wrong going on.

Thanks,
--
Michael
Вложения