Обсуждение: pg96 not running as service
Examine the log output.
Only after successful start postgresql starts to write into the log file.
Hi All,System:Win server 2016Version:pg9.6I 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 viewerpg_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 -
Examine the log output.
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 2016Version:pg9.6I 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 viewerpg_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 -
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
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
There should be more detail records in the event viewer. What you show is only the first line.
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 2016Version:pg9.6I 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 viewerpg_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