How to Manually Install or Reinstall PostgreSQL 9.0 (Windows)

PokerTracker 4 version 4.0.x
June 2, 2014
  • Overview

    A proper installation of PostgreSQL can be the difference between a database that runs properly or constantly has problems. All PostgreSQL issues can be classified into two categories:

    1. Service Issues
    2. Database Issues

    Properly uninstalling and then reinstalling PostgreSQL will resolve all service issues and some database issues. It will not resolve a corrupted database or database files. Sometimes a corrupted database can be recovered. It is easiest for you to simply create a new PokerTracker 4 database and re-import all of your archived hand histories from your PokerTracker 4/Processed directory which will completely rebuild your database.

    Steps provided in this document may vary from different versions of Windows. Instructions which are specific to a certain version of Windows will be noted in bold immediately followed by the instructions. It is then noted when instructions return to all versions of Windows.

  • Before You Begin

    If PostgreSQL was previously installed on this computer then it is imperative for you to know which major version was installed, for example PostgreSQL 8.4.x or 9.0.x. You can determine this via several methods:

    1. If PostgreSQL is still installed on your computer, go Start -> Programs and look for PostgreSQL (version) where (version) is the major version of PostgreSQL installed on your computer.
    2. If PostgreSQL is no longer installed on your computer, open My Computer and browse to your Program Files/PostgreSQL directory. There will be a sub-directory listed which is either 8.x or 9.x depending on the version installed.
    This guide is for users who are upgrading from PostgreSQL 9.0.x only.
  • Microsoft Windows Vista, 7, and 8

    PostgreSQL requires complete administrative privileges to install and run properly.

    Although not required, we recommend that you disable User Account Control (UAC) which will ensure that you always have proper administrative permissions. Please read the Tutorial: How to Disable 'User Account Control' (UAC) for step-by-step instructions on how to disable "UAC".

    If you opt to not disable User Account Control (UAC) then you can still install PostgreSQL; however, you must right-click -> Run as Administrator whenever launching a PostgreSQL related function.

    If a step in this guide varies depending on whether UAC is enabled or disabled, it will be specified in the instructions.

  • Uninstalling PostgreSQL 9.0.x

    In Windows go Start -> Control Panel.

    Only Windows XP or 2000
    Click "Add or Remove Programs"

     

    Only Windows Vista
    In Classic View click "Programs and Features"
    In Control Panel Home under Programs click “Uninstall a program”

     

    Only Windows 7
    In the Control Panel, under Programs click “Uninstall a program”

     

    All Windows Versions
    Scroll down and select "PostgreSQL 9.0"

     

    Only Windows XP or 2000
    Click "Remove".

     

     

    Only Windows Vista or Windows 7
    Click "Uninstall"

     

     

     

    All Windows Versions
    If the program "psqlODBC" is listed, select it and uninstall as well. If it is not listed then skip.

     

    • Deleting the PostgreSQL Directory

      If you wish to preserve your existing database then please skip this step. This step should only be performed if you are going to be installing a new database or want to delete your existing database.

      Open "My Computer" and browse to your C:/Program Files directory. Locate the directory named "PostgreSQL" and right-click -> Delete.

      PostgreSQL is now completely uninstalled from your computer and you can now proceed to re-install.

    • Deleting the PostgreSQL Service Account

      Windows XP, 2000 or Windows Vista & Windows 7 (with UAC disabled)
      Go Start -> Run, 'cmd' -> OK.
       

       

      Windows Vista & Windows 7 (with UAC enabled)
      Go Start -> All Programs -> Accessories. Locate the “Command Prompt” and right-click -> Run as Administrator.

       

      All Windows Versions
      At the Windows command prompt type:

       

      net user postgres /delete

       

      Then hit <Enter>
       

       

      It should then say "The command completed successfully." If it does not say this then it failed to delete the postgres service account user due to insufficient privileges. Go back to the step for Windows Vista & Windows 7 (with UAC enabled) users and repeat.

  • Manually Installing PostgreSQL
    • Download the Installer from PostgreSQL.org

      When installing PostgreSQL for PokerTracker 4, always download and install the latest version of PostgreSQL 9.0.x (At the time of writing this guide, the latest version is 9.0.6-1).  PostgreSQL 9.1.x or newer is not supported by PokerTracker.

      Open your favorite web browser and go to the PostgreSQL download website at http://www.enterprisedb.com/products-services-training/pgdownload#windows.

      Under the Installer Version 9.0.x click the "Windows" button.  You can choose between the 32Bit or 64Bit installers.  If you have the 64Bit version of Windows 7 installed, then PokerTracker recommends that you download the Win x86-64 64Bit installer (right hand arrows).  If you do not have the 64Bit version of Windows 7 installed then we recommend you download the Win x86-32 32Bit installer. Generally speaking, users with 64Bit operating systems using a 64Bit version of PostgreSQL will see a performance boost if adequate amounts of RAM are available for the database server.

       

       

      Postgres 9.0.x Download

       

    • The PostgreSQL Setup Wizard

      Double-click the postgresql-9.0.x installer file file that was downloaded to your computer to begin the installation process, then click the Next button to proceed.

       

      • Installation Directory

        The second screen named Installation Options is the step where you can choose the location on your hard drive to install PostgreSQL. If you need to install PostgreSQL to a non-default location, such as a different hard drive, then click folder icon and browse to and select the location to install.

        PokerTracker recommends that you install to the default location unless if it is not possible, or in the event you have a dedicated Solid State Drive (SSD) for your database. Simply click Next > to continue.

      • Data Directory

        If this is a new PostgreSQL installation, you will be prompted to select the data directory. Click Next > to continue (DO NOT change this directory location. It will be a sub-directory of the installation directory that you selected in the previous step).

      • Password

        The next screen named Password is for you to create a PostgreSQL database password.

        Enter the default password 'dbpass' twice.

         

         

      • Port

        The next screen named allows you to change Port that PostgreSQL will use.  Do not change this value unless if you are an advanced user and know exactly what you are doing.  Click Next > to continue.

      • Advanced Options

        Leave the default options selected then click Next > to continue.

      • Ready to Install

        PostgreSQL is now ready to be installed. Click Next > to begin the installation process.

      • Completing the PostgeSQL Setup Wizard

        Once PostgreSQL is finished installing the final screen will prompt you to launch the stack builder upon exit. Uncheck this option then click Finish.

         

         

        PostgreSQL 9.0.x should now be successfully installed on your computer.

  • Confirm that PostgreSQL is Running

    The fastst way to confirm if the PostgreSQL service is running is by using the Windows Command Lind interface. Open a Command Line from the Windows Start menu by pressing Start, select Run, type "CMD" and click Enter. In the Command Line window that opens type net start | find "Postgre" and press Enter. The window should now display all services that are running which contain the word Postgre.  If no services are listed this means that the PostgreSQL service is not running.  

    net start | find "PostgreSQL"

     

    To check if PostgreSQL is running using the Windows GUI hit "CTRL-ALT-DELETE" to open the Task Manager.

    Only Windows Vista & Windows 7 (with UAC enabled)
    Click the Show processes from all users button.

     

     

    All Windows Versions

    Under the Processes tab, at the very bottom, make sure that Show processes from all users is checked.

    Click Image Name to sort the list of running processes alphabetically. Scroll down the list and make sure that you see several processes named postgres.exe. If you see this then PostgreSQL is installed properly and you can proceed to run PokerTracker 4.

     

     

    If you installed the 32Bit version of PostgreSQL then you should see *32 after each instance of the PostgreSQL in the list.  If you installed the 64Bit version of PostgreSQL then you should see *64 after each instance of the PostgreSQL in the list.  If you do not see PostgreSQL in the list and installation completed without any errors then:

    Windows XP, 2000 or Windows Vista & Windows 7 (with UAC disabled)
    Go Start -> Programs -> PostgreSQL 9.0 -> Start Service.

    Windows Vista & Windows 7 (with UAC enabled)
    Go Start -> Programs -> PostgreSQL 9.0 and right-click ‘Start Service’ and ‘Run as Administrator’.

     

    All Windows Versions
    PostgreSQL should now start and be listed in your Windows Task Manager. If it is not, then please contact PokerTracker support for assistance.

highfalutin