Re: documentation udpates to pgupgrade.html

Bruce,

To query for Postgresql services on Windows use:

sc query type= service | find "postgresql"


On my machine this yields:

SERVICE_NAME: postgresql-9.0
DISPLAY_NAME: postgresql-9.0 - PostgreSQL Server 9.0


NB the space after type= is very important, don't ask me why...



I prefer to use 'sc start <servicename>' and 'sc stop <servicename>',
then you can use one tool for everything.

The following shows these commands (and the query command) in action.


C:\Documents and Settings\Administrator>sc stop postgresql-9.0

SERVICE_NAME: postgresql-9.0       TYPE               : 10  WIN32_OWN_PROCESS       STATE              : 3
STOP_PENDING                              (STOPPABLE, PAUSABLE, ACCEPTS_SHUTDOWN)       WIN32_EXIT_CODE    : 0  (0x0)
   SERVICE_EXIT_CODE  : 0  (0x0)       CHECKPOINT         : 0x2       WAIT_HINT          : 0x2710
 

C:\Documents and Settings\Administrator>sc start postgresql-9.0

SERVICE_NAME: postgresql-9.0       TYPE               : 10  WIN32_OWN_PROCESS       STATE              : 2
START_PENDING                              (NOT_STOPPABLE, NOT_PAUSABLE, IGNORES_SHUTDOWN))
 
       WIN32_EXIT_CODE    : 0  (0x0)       SERVICE_EXIT_CODE  : 0  (0x0)       CHECKPOINT         : 0x0       WAIT_HINT
        : 0x7d0       PID                : 3732       FLAGS              :
 

C:\Documents and Settings\Administrator>sc query postgresql-9.0

SERVICE_NAME: postgresql-9.0       TYPE               : 10  WIN32_OWN_PROCESS       STATE              : 4  RUNNING
                         (STOPPABLE, PAUSABLE, ACCEPTS_SHUTDOWN)       WIN32_EXIT_CODE    : 0  (0x0)
SERVICE_EXIT_CODE : 0  (0x0)       CHECKPOINT         : 0x0       WAIT_HINT          : 0x0
 



Hope this isn't too much info and answers all your questions :-)


Regards,

Colin