Re: pg96 not running as service

There should be more detail records in the event viewer. What you show
is only the first line.

Am 19.08.20 um 14:50 schrieb Peter Watt:
> Thanks Holger. 
>
> The Windows Event Viewer only states:
>
> pg_ctl: could not start server
> Examine the log output. 
>
> which was not so useful :-)
>
> On Wed, 19 Aug 2020 at 22:13, Holger Jakobs <holger(at)jakobs(dot)com
> <mailto:holger(at)jakobs(dot)com>> wrote:
>
> Don't check the log file, but Windows event viewer.
>
> Only after successful start postgresql starts to write into the
> log file.
>
> Am 19. August 2020 14:35:19 MESZ schrieb Peter Watt
> <pwatt01(at)gmail(dot)com <mailto:pwatt01(at)gmail(dot)com>>:
>
> Hi All,
> System:Win server 2016
> Version:pg9.6 
>
> I have had an odd problem happen today. My server that has
> been running fine for 2 years has decided that it will not
> start any more. 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\..\pg96\bin\pg_ctl start -c -w --log
> "C:\tmp\logs.txt" -D "C:\PostgreSQL\data\pg96"
>
> C:\PostgreSQL\pg96\pgservice.exe "//TS//PostgreSQL 9.6 Server"
>
> but when trying to run as a service (using 
> C:\PostgreSQL\pg96\pgservice.exe "//RS//PostgreSQL 9.6
> Server") as system user i get this in the windows event viewer
> pg_ctl: could not start server
> Examine the log output.
>
> I have looked at the logs, both in C:\tmp\logs.txt (empty
> file)  and C:\PostgreSQL\data\logs\pg96 (no new lines) no no
> avail. 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.
>
> Thanks for your help!
>
> Peter
>
>
> --
> Holger Jakobs, Bergisch Gladbach
> +49 178 9759012
> - sent from mobile, therefore short -
>
--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012