Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k8NRD-0004BI-ST for pgsql-admin@arkaria.postgresql.org; Wed, 19 Aug 2020 12:43:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1k8NRC-0006Xv-Pp for pgsql-admin@arkaria.postgresql.org; Wed, 19 Aug 2020 12:43:30 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k8NRC-0006Xo-IC for pgsql-admin@lists.postgresql.org; Wed, 19 Aug 2020 12:43:30 +0000 Received: from jakobs.com ([85.214.83.89] helo=rs.plausibolo.de) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k8NRA-0008Em-9D for pgsql-admin@lists.postgresql.org; Wed, 19 Aug 2020 12:43:30 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id 46914380627; Wed, 19 Aug 2020 14:43:26 +0200 (CEST) Received: from rs.plausibolo.de ([127.0.0.1]) by localhost (h2367442.stratoserver.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id BFV4Bg2GzWJ6; Wed, 19 Aug 2020 14:43:26 +0200 (CEST) Received: from [192.168.178.35] (ip-37-201-154-65.hsi13.unitymediagroup.de [37.201.154.65]) by rs.plausibolo.de (Postfix) with ESMTPSA id D15EF380624; Wed, 19 Aug 2020 14:43:25 +0200 (CEST) Date: Wed, 19 Aug 2020 14:43:23 +0200 User-Agent: K-9 Mail for Android In-Reply-To: References: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----28VNZW8HM0AR83I8RIK167A7TBP0NC" Content-Transfer-Encoding: 7bit Subject: Re: pg96 not running as service To: pgsql-admin@lists.postgresql.org,Peter Watt From: Holger Jakobs Message-ID: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------28VNZW8HM0AR83I8RIK167A7TBP0NC Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Don't check the log file, but Windows event viewer=2E Only after successful start postgresql starts to write into the log file= =2E Am 19=2E August 2020 14:35:19 MESZ schrieb Peter Watt : >Hi All, >System:Win server 2016 >Version:pg9=2E6 > >I have had an odd problem happen today=2E My server that has been running >fine for 2 years has decided that it will not start any more=2E >Investigating >a little i have found that it works fine when running from command >line, >using either of the below commands: > >C:\POSTGR~1\pg96\=2E=2E\pg96\bin\pg_ctl start -c -w --log "C:\tmp\logs=2E= txt" >-D >"C:\PostgreSQL\data\pg96" > >C:\PostgreSQL\pg96\pgservice=2Eexe "//TS//PostgreSQL 9=2E6 Server" > >but when trying to run as a service (using >C:\PostgreSQL\pg96\pgservice=2Eexe "//RS//PostgreSQL 9=2E6 Server") as >system >user i get this in the windows event viewer >pg_ctl: could not start server >Examine the log output=2E > >I have looked at the logs, both in C:\tmp\logs=2Etxt (empty file) and >C:\PostgreSQL\data\logs\pg96 >(no new lines) no no avail=2E Can anyone help me out?? > >This seems to happen soon after I created a new DB using pgadmin4 and >had a >new instance of bitbucket populate it, but not immediately after=2E > >Thanks for your help! > >Peter --=20 Holger Jakobs, Bergisch Gladbach +49 178 9759012 - sent from mobile, therefore short - ------28VNZW8HM0AR83I8RIK167A7TBP0NC Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable Don't check the log file, but Windows event viewer= =2E

Only after successful start postgresql starts to write into the = log file=2E

Am 19=2E August 2020 14:35:19= MESZ schrieb Peter Watt <pwatt01@gmail=2Ecom>:
Hi All,
System:Win server 2016
Version:pg9= =2E6 

I have had an odd problem happen t= oday=2E My server that has been running fine for 2 years has decided that i= t will not start any more=2E Investigating a little i have found that it wo= rks fine when running from command line, using either of the below com= mands:

C:\POSTGR~1\pg96\= =2E=2E\pg96\bin\pg_ctl start -c -w --log "C:\tmp\logs=2Etxt" -D "C:\Postgre= SQL\data\pg96"

C:\PostgreSQL\pg96\pgservice=2Eexe "//TS//PostgreSQL 9=2E6 Server"<= br>

but when trying to run as a service (using&nbs= p; C:\PostgreSQL\pg96\pgservice=2Eexe "//RS//PostgreSQL 9=2E6 Server") as sys= tem user i get this in the windows event viewer
pg_ctl: could not start server
Examine the log output=2E

I = have looked at the logs, both in C:\tm= p\logs=2Etxt (empty file)  and C:= \PostgreSQL\data\logs\pg96 (no new = lines) no no avail=2E Can anyone help me out??

This seems to happen soon after I created a new DB using pgadm= in4 and had a new instance of bitbucket populate it, but not immediately&nb= sp;after=2E

Thanks for your help!

Peter

--
Holger Jakobs, Bergisch Gladbach
+49 178 = 9759012
- sent from mobile, therefore short -
------28VNZW8HM0AR83I8RIK167A7TBP0NC--