Re: pg96 not running as service

Holger Jakobs <holger@xxxxxxxxxx> · Wed, 19 Aug 2020 15:02:58 +0200



    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@xxxxxxxxxx> 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@xxxxxxxxx>:
              
                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