Обсуждение: If pg_ctl dies, can we attach a new pg_ctl process to postgres?

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

If pg_ctl dies, can we attach a new pg_ctl process to postgres?

От
Daevor The Devoted
Дата:
Hi

On a Windows 10 system (using pg9.3), we have occasionally noted that the pg_ctl process is not running, but the main postgres.exe process is. Windows services then reports postgres as not running, when it is actually is.

Is it thus possible to start up a new pg_ctl process, and "attach" it to the existing postgres instance? We don't actually want to restart postgres, unless absolutely necessary.

Additionally, is there some logs somewhere I can look through to try to determine what might have caused the pg_ctl process to die?

Kind regards,
Na-iem Dollie