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

From: Daevor The Devoted <dollien(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: If pg_ctl dies, can we attach a new pg_ctl process to postgres?
Date: 2016-10-31 13:24:15
Message-ID: CAAZnbVq7yRiybP-LggVXxF+XOHkLfQtaurw5MnTQaujHcd=eAw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2016-10-31 13:41:09 Re: Rows are repeating by the trigger function
Previous Message Merlin Moncure 2016-10-31 13:19:15 Re: How to hint 2 coulms IS NOT DISTINCT FROM each other