From: Dischner, Anton <Anton.Dischner@med.uni-muenchen.de>
To: Peter Watt <pwatt01@gmail.com>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: AW: pg96 not running as service
Date: Wed, 19 Aug 2020 12:55:16 +0000
Message-ID: <4e3562f8d6e44759be6320fbbdd2c420@MITMB5.helios.med.uni-muenchen.de> (raw)
In-Reply-To: <CAHo0DuEva0-iKW-554Tmc=tXhu_uR-H1Ec_4+PYXAk7dBNHkmg@mail.gmail.com>
References: <CAHo0DuEva0-iKW-554Tmc=tXhu_uR-H1Ec_4+PYXAk7dBNHkmg@mail.gmail.com>
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,
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Anton.Dischner@med.uni-muenchen.de, pwatt01@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: AW: pg96 not running as service
In-Reply-To: <4e3562f8d6e44759be6320fbbdd2c420@MITMB5.helios.med.uni-muenchen.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox