Re: pg96 not running as service

Hi Anton,

My answers are below,

Thanks

Peter

On Wed, 19 Aug 2020 at 22:25, Dischner, Anton <
Anton(dot)Dischner(at)med(dot)uni-muenchen(dot)de> wrote:

> Hi Peter,
>
>
>
> first i would thorouhly check you hardware.
>
>
>
> Often there are RAM problems. Do you have ECC RAM? NOt 100% sure... This
> is a VM sitting alongside a whole bunch of onther ones, but I woudl imagine
> there are not issue here. I can ask IT in the morning when they get in.
>
>
>
> Do you have RAID? The storage it sitting on a SAN.. not sure if this is
> ont he HDD or SDD SAN but they are very much RAIDedd
>
>
>
> Also check for full filesystems? 15GB+ availabe on both (virtual) HDDs
>
>
>
> best,
>
>
>
> Anton
>
>
>
> *Von:* Peter Watt <pwatt01(at)gmail(dot)com>
> *Gesendet:* Mittwoch, 19. August 2020 14:35
> *An:* pgsql-admin(at)lists(dot)postgresql(dot)org
> *Betreff:* pg96 not running as service
>
>
>
> 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
>