If pg_ctl dies, can we attach a new pg_ctl process to postgres? - Mailing list pgsql-general

From Daevor The Devoted
Subject If pg_ctl dies, can we attach a new pg_ctl process to postgres?
Date
Msg-id CAAZnbVq7yRiybP-LggVXxF+XOHkLfQtaurw5MnTQaujHcd=eAw@mail.gmail.com
Whole thread Raw
List pgsql-general
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

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: How to hint 2 coulms IS NOT DISTINCT FROM each other
Next
From: Adrian Klaver
Date:
Subject: Re: Rows are repeating by the trigger function