Re: pg96 not running as service

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

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@jakobs.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@gmail.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