BUG #14979: PostGres does not start at reboot

From: dbaber(at)rm(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Cc: dbaber(at)rm(dot)com
Subject: BUG #14979: PostGres does not start at reboot
Date: 2017-12-15 10:26:04
Message-ID: 20171215102604.29863.57629@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14979
Logged by: Darren Baber
Email address: dbaber(at)rm(dot)com
PostgreSQL version: 9.3.5
Operating system: Windows Server (standard) 2012R2 & 2016
Description:

The issue is described here:
http://www.dbforums.com/showthread.php?1707155-PostgreSQL(pg_ctl)-service-failed-to-start-but-postgres-exe-running.
We see a postmaster.pid created, some running PostGres.exe instances - BUT
the "RMConnect PostgreSQL Database Server" service is stopped (this is our
name for the key PG service running on the server). We have to kill the
running PostGres.exe instances and then this service will start.
We suspect that the Postmaster.pid file is NOT being removed cleanly at
reboot - and thus at the next reboot the file is present and the start-up of
PostGres sees this file and enters the error state.
Note: We have 9.3.5 rolled out to hundreds of customer sites and this is
only happening at a small handful right now. We cannot find a common cause
amongst them (there are different AV solutions in place - with restrictions
in place for the PostGres install folders).

Browse pgsql-bugs by date

  From Date Subject
Next Message Teodor Sigaev 2017-12-15 14:38:50 Re: 10.1: hash index size exploding on vacuum full analyze
Previous Message Peter Geoghegan 2017-12-15 01:58:39 Re: PostgreSQL crashes with SIGSEGV