Traveling Between Time Zones While Using PostgreSQL 9.3

    • BarryCarter
      BarryCarter
      Headadmin
      Headadmin
      Joined: 13.01.2011 Posts: 4,973
      Prior to the release of PostgreSQL 9.2 the time zone was determined by the operating system's time zone and set each time the PostgreSQL server was started. As of PostgreSQL 9.2 the time zone used by the SQL Server is no longer taken from the host operating system, it is now permanently defined within the configuration file.

      During the initial install of PostgreSQL 9.2 or greater the time zone used by the operating system during installation will be configured to be the default time zone within the postgresql.conf file.

      This new method of defining the time zone has great benefits for the majority of PostgreSQL functions, the server is typically used within stationary computers associated with a fixed IP address. But the needs of PokerTracker 4 users are very different, poker players may use a laptop instead of a stationary computer and their IP address may frequently change.

      In the event you travel between time zones, you may discover that hand histories that you have played will be imported with a time offset. This time offset will affect all reports and filters, to correct this problematic time zone problem you will have to alter the timezone operator in the postgresql.conf file to match the current time zone and then restart the PostgreSQL Server.

      Alter the Time Zone in postgresql.conf
      You can define the time zone used by PostgreSQL 9.2 or greater by editing the postgresql.conf file.

      1. Press the 'Start' key on your keyboard and type 'notepad' to find the Notepad application.

      2. Right click on the Notepad application icon and select Run as Administrator. If a UAC message is displayed, do one of the following to allow Notepad to run with Administrative permissions:

      A) If you are logged on as a standard user, or if UAC is configured to always require credentials, enter the appropriate administrative credentials, and then click OK.
      B) If you are logged on as an administrator and UAC is not configured to always require credentials, click Yes to start the application.


      3. In Notepad open this file: C:\Program Files\PostgreSQL\9.3\data\postgreql.conf

      4. Click CTRL+F and type in "timezone =". Set the Direction to Down and click Find Next.

      5. Alter the timezone property to match your current time zone. The list of authorized time zone properties can be found at http://en.wikipedia.org/wiki/List_of_tz_database_time_zones, under the "TZ" column. For example if you installed PostgreSQL 9.3 while in London your timezone property will appear to be : timezone = 'Europe/London'. To change the time zone to reflect the time zone for Berlin change the time zone property to timezone = 'Europe/Berlin'
      timezone



      6. The # sign at the start of any line within the postgreql.conf file is used to comment out the property change defined by that line. If there is a "#" as the start of the timezone line, you must delete this character.

      7. Save the postgresql.conf file by selecting File > Save.

      8. The PostgreSQL server must now be restarted to allow the changes made to the configuration file to take effect. The easiest way to accomplish this is by restarting your computer.
  • 2 replies
    • ConteCaly
      ConteCaly
      Platinum
      Joined: 29.12.2010 Posts: 1,327
      i'm italian, sorry for my english...
      today i've installed the new version 4.11.6 of pt4, but it's impossible because there's a message that show error ...

      and i try to resolve the problem, but i suppose that i make worst.

      can you help me? or can you take the remote control of my pc and resolve my problem?

      i can't switch off my pc too...

      i sent to you the request to be friend than we can write with private message,

      i hope to have a resp

      thanks
    • PokerTracker
      PokerTracker
      Gold
      Joined: 07.06.2011 Posts: 644
      Please visit the PokerTracker website and create a support ticket, we will be happy to help you. We need to see the error so we can advise how to fix it. Typically the error is caused by a computer/PostgreSQL version that does not meet our minimum required specifications.

      https://www.pokertracker.com/contact/PT4