From: Holger Jakobs <holger@jakobs.com>
To: Peter Watt <pwatt01@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: pg96 not running as service
Date: Wed, 19 Aug 2020 15:02:58 +0200
Message-ID: <4e8f2fd4-1bbd-635b-0a88-5d82556f8099@jakobs.com> (raw)
In-Reply-To: <CAHo0DuEbrZZLyDF4eqkB2vvgFL1zQ=DuXyZw2g40-K9k+-VocQ@mail.gmail.com>
References: <CAHo0DuEva0-iKW-554Tmc=tXhu_uR-H1Ec_4+PYXAk7dBNHkmg@mail.gmail.com>
<CAC625F9-E7D0-4B79-8087-D02FA4392004@jakobs.com>
<CAHo0DuEbrZZLyDF4eqkB2vvgFL1zQ=DuXyZw2g40-K9k+-VocQ@mail.gmail.com>
There should be more detail records in the event viewer. What you show
is only the first line.
Am 19.08.20 um 14:50 schrieb Peter Watt:
> 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
> <mailto: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 <mailto: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
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, pgsql-admin@lists.postgresql.org
Subject: Re: pg96 not running as service
In-Reply-To: <4e8f2fd4-1bbd-635b-0a88-5d82556f8099@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