Re: pg96 not running as service

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> 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>:
>>
>> 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 -
>