pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg96 not running as service
5+ messages / 2 participants
[nested] [flat]
* pg96 not running as service
@ 2020-08-19 12:35 Peter Watt <pwatt01@gmail.com>
0 siblings, 2 replies; 5+ messages in thread
From: Peter Watt @ 2020-08-19 12:35 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pg96 not running as service
@ 2020-08-19 12:43 Holger Jakobs <holger@jakobs.com>
parent: Peter Watt <pwatt01@gmail.com>
1 sibling, 1 reply; 5+ messages in thread
From: Holger Jakobs @ 2020-08-19 12:43 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org,Peter Watt <pwatt01@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 -
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pg96 not running as service
@ 2020-08-19 12:50 Peter Watt <pwatt01@gmail.com>
parent: Holger Jakobs <holger@jakobs.com>
0 siblings, 1 reply; 5+ messages in thread
From: Peter Watt @ 2020-08-19 12:50 UTC (permalink / raw)
To: Holger Jakobs <holger@jakobs.com>; +Cc: pgsql-admin@lists.postgresql.org
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> 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>:
>>
>> 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 -
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pg96 not running as service
@ 2020-08-19 13:01 Peter Watt <pwatt01@gmail.com>
parent: Peter Watt <pwatt01@gmail.com>
1 sibling, 0 replies; 5+ messages in thread
From: Peter Watt @ 2020-08-19 13:01 UTC (permalink / raw)
To: Dischner, Anton <Anton.Dischner@med.uni-muenchen.de>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Hi Anton,
My answers are below,
Thanks
Peter
On Wed, 19 Aug 2020 at 22:25, Dischner, Anton <
Anton.Dischner@med.uni-muenchen.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@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
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pg96 not running as service
@ 2020-08-19 13:02 Holger Jakobs <holger@jakobs.com>
parent: Peter Watt <pwatt01@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Holger Jakobs @ 2020-08-19 13:02 UTC (permalink / raw)
To: Peter Watt <pwatt01@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2020-08-19 13:02 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-08-19 12:35 pg96 not running as service Peter Watt <pwatt01@gmail.com>
2020-08-19 12:43 ` Holger Jakobs <holger@jakobs.com>
2020-08-19 12:50 ` Peter Watt <pwatt01@gmail.com>
2020-08-19 13:02 ` Holger Jakobs <holger@jakobs.com>
2020-08-19 13:01 ` Peter Watt <pwatt01@gmail.com>
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