Home > mailing lists

Thread: pg96 not running as service

pg96 not running as service

From

Peter Watt

Date:

19 August 2020, 15:35:19

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

Re: pg96 not running as service

From

Holger Jakobs

Date:

19 August 2020, 15:43:23

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 -

Re: pg96 not running as service

From

Peter Watt

Date:

19 August 2020, 15:50:55

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 -

AW: pg96 not running as service

From

"Dischner, Anton"

Date:

19 August 2020, 15:55:16

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

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

Re: pg96 not running as service

From

Peter Watt

Date:

19 August 2020, 16:01:20

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

Re: pg96 not running as service

From

Holger Jakobs

Date:

19 August 2020, 16:02:58

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> 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 -

-- 
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012