From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org,Peter Watt <pwatt01@gmail.com>
Subject: Re: pg96 not running as service
Date: Wed, 19 Aug 2020 14:43:23 +0200
Message-ID: <CAC625F9-E7D0-4B79-8087-D02FA4392004@jakobs.com> (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>
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 -
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: holger@jakobs.com, pwatt01@gmail.com
Subject: Re: pg96 not running as service
In-Reply-To: <CAC625F9-E7D0-4B79-8087-D02FA4392004@jakobs.com>
* 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