Restart the PostgreSQL Server

PokerTracker 4 version 4.0.x
October 25, 2013
  • Overview

    On rare occasion you may need to restart the PostgreSQL server, this is usually only necessary if you needed to perform a configuration change which requires a restart.  PokerTracker 4 supports the following PostgreSQL versions and restart methods:

    Windows:

    PostgreSQL 8.3.18 or greater: Computer Restart, Start and Stop Applications, Command Line

    PostgreSQL 8.4.12 or greater: Computer Restart, Start and Stop Applications, Command Line

    PostgreSQL 9.0.7   or greater: Computer Restart, Command Line

    PostgreSQL 9.1: Not Supported

    PostgreSQL 9.2: Not Supported

    Mac OS X:

    PostgreSQL 8.4.12 or greater: Computer Restart, Start and Stop Applications, Command Line

    PostgreSQL 9.0.7   or greater: Computer Restart, Command Line

    PostgreSQL 9.1: Not Supported

    PostgreSQL 9.2: Not Supported

     

    Additionally it can be noted that PostgreSQL may be restarted from within the PokerTracker 4 Database Menu, but this assumes that PokerTracker 4 is accessable at the time. This option is not available in the Mac OS X version of PokerTracker 4 at this time, it is a Windows-only option. 

    Database Management

  • Methods That Can Be Used to Restart The PostgreSQL Service
    • Restart Your Computer

      The PostgreSQL service is an "invisible" application that runs in the background of your computer using a dedicated service account, therefore the easiest way to restart the service without any technical know how is to simply restart your computer.  The downside of this method is the extra time required, and the need to close all applications and files before restarting, but the positive is the simplicity of this alternative to restarting the PostgreSQL server when you cannot restart the server from within PokerTracker 4. 

    • Using Applets to Restart the Server

      PostgreSQL 8.3 and 8.4 provide applets which can be used to start or stop the PostgreSQL service.

      Windows:

      1. Click Start Button.  Select All Programs.
        1. PostgreSQL 8.3:
          1. Open the PostgreSQL 8.3 folder
          2. Click Stop Service
          3. Click Start Service
            PostgreSQL 8.3
        2. PostgreSQL 8.4:
          1. Open the PostgreSQL 8.4 folder
          2. Click Restart Server
            PostgreSQL 8.4

      Mac OS X: 

      1. Enter the folder found at /Applications/PostgreSQL 8.4 (PostgreSQL 8.3 is not compatible with the Mac OS X version of PokerTracker 4)
      2. Double click the Restart Server applet

      PostgreSQL Restart Server

    • Windows Manual Restart

      There are multiple ways to manually restart a service in Windows, we feel this is the simplest method to describe how to restart the PostgreSQL Service:

      1. Click Start
      2. Type services.msc and click Enter. This will open the Services Control Panel.
        1. ​Windows XP users will need to click Run, followed by services.msc and then click Enter
      3. ​Click the Name heading to sort all of the services by name
      4. Find the service whose name starts with PostgrSQL and select it. Notice that the Log On As column for this service should  contain .\postgres, this is the user account that is used by the postgreSQL server to operate. 
        1. PostgreSQL 8.3
          postgreSQL Server Service
        2. PostgreSQL 9.0 64 Bit
          postgreSQL Server Service
      5. Click the Restart Service button. 

      Restart PostgreSQL

    • Mac OS X Manual Restart

      The easiest way to restart PostgreSQL manually in the Mac OS X is by using the command line in the Terminal application.  This method differs from the graphical interface solution available for Windows users. The method used in the example below assumes you are using PostgreSQL 9.0.x since this is the only version that is compatible with PokerTracker 4 that does not include a GUI tool to restart the PostgreSQL server. 

      1. Open the Terminal application, this is usually found at /Applications/Utilities/Terminal
      2. When the command line prompt appears type sudo launchctl stop com.edb.launchd.postgresql-9.0 and click Return. You will have to enter in your administrator password to proceed. This will stop the PostgreSQL server.
      3. When the command line prompt is available once again, type sudo launchctl start com.edb.launchd.postgresql-9.0 and click Return. You may have to enter in your administrator password to proceed. This will start the PostgreSQL server.
         

      Terminal

highfalutin