Hi Peter,
first i would thorouhly check you hardware.
Often there are RAM problems. Do you have ECC RAM?
Do you have RAID?
Also check for full filesystems?
best,
Anton
Von: Peter Watt <pwatt01@gmail.com>
Gesendet: Mittwoch, 19. August 2020 14:35
An: pgsql-admin@lists.postgresql.org
Betreff: pg96 not running as service
Hi All,
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.
