literate-perfunctory
Poker Software
Page 1 of 3 123 LastLast
Results 1 to 10 of 27

Thread: postgres 9.2

  1. #1
    Member
    Join Date
    Dec 2009
    Posts
    32

    Default postgres 9.2

    Hi!

    Can you please tell me, is HM2 compatible with postgresql 9.2?
    Thanks,
    Peter

  2. #2
    HM Support Patvs's Avatar
    Join Date
    Feb 2009
    Location
    Amsterdam, the Netherlands
    Posts
    33,523

    Default

    HM1 seems to work just fine with PostgreSQL 9.1 and 9.2.

    HM2, there can be some issues with 9.1 and 9.2.
    So we still recommend just using 8.4, or 9.0.
    Participate in the Beta release of the newest Hold'em Manager version: HM Cloud. Sign-up HERE.

    If you would like to leave some feedback to help us improve the quality of the solutions, and/or the support quality you received, - you can do this here

  3. #3
    Member
    Join Date
    Dec 2009
    Posts
    32

    Default

    Thank You! I will install 9.0.

  4. #4
    Senior Member BubbleBoy's Avatar
    Join Date
    Oct 2008
    Posts
    260

    Default

    Well I went with a fresh 9.2 for HM2 and so far it's going as planned.

  5. #5
    Graphics Guru fozzy71's Avatar
    Join Date
    Sep 1971
    Location
    HM Support
    Posts
    27,908

    Default

    Quote Originally Posted by BubbleBoy View Post
    Well I went with a fresh 9.2 for HM2 and so far it's going as planned.
    9.2 seems to import hands fine but problems will likely arise for you when you try to do things in the Database Manager like backup, restore, export, purge, etc.

  6. #6
    Member
    Join Date
    May 2012
    Posts
    44

    Default

    is it recommended upgrade from 8.4 to 9? or not worth the change?

    Thanks

  7. #7
    HM Support Patvs's Avatar
    Join Date
    Feb 2009
    Location
    Amsterdam, the Netherlands
    Posts
    33,523

    Default

    Stick to 8.4 if you have no issues/problems with 8.4.
    There are no advantages in using 9.0.
    Participate in the Beta release of the newest Hold'em Manager version: HM Cloud. Sign-up HERE.

    If you would like to leave some feedback to help us improve the quality of the solutions, and/or the support quality you received, - you can do this here

  8. #8
    Senior Member
    Join Date
    Dec 2009
    Posts
    300

    Default

    Isn't 9.0 64-bit? Then in postgresql.conf we could change

    shared_buffers = 1024MB
    effective_cache_size = 2048

    to

    shared_buffers = 2048MB
    effective_cache_size = 4096

    for a big performance increase?

  9. #9
    HM Support Patvs's Avatar
    Join Date
    Feb 2009
    Location
    Amsterdam, the Netherlands
    Posts
    33,523

    Default

    I now use 9.2 (64 bit) myself.

    8.4.x is still the default version that is automatically installed with HoldemManager, but you can also use 9.0 and 9.2 (we still don't recommend 9.1).

    However, I doubt there will be much of a performance improvement.
    Whether you use 8.2 (32 bit) with shared_buffers = 32MB, or 9.2 (64 bit) with shared_buffers = 2048MB (on a computer with 16 GB RAM) the difference in import speeds will be minimal.

    9.2 will be a lot better in running faster maintenance tasks in pgadminIII, such as vacuum, analyse, reindex.
    Participate in the Beta release of the newest Hold'em Manager version: HM Cloud. Sign-up HERE.

    If you would like to leave some feedback to help us improve the quality of the solutions, and/or the support quality you received, - you can do this here

  10. #10
    Senior Member
    Join Date
    Dec 2009
    Posts
    300

    Default

    I successfully installed 9.2 and backed-up/restored my database into 9.2. I opened up postgresql.conf in the new 9.2 folder and at the buttom for customized options it had nothing. I copy and pasted this over from my 8.4 conf. What do you think of these, is there anything I could change or add?

    shared_buffers = 2048MB
    effective_cache_size = 4096
    work_mem = 64MB
    maintenance_work_mem = 128MB
    commit_delay = 10000
    checkpoint_segments = 128
    checkpoint_completion_target = 0.9
    wal_buffers = 16MB

    notecaddy is about 2x faster. I started the day off at 20hands/sec. Played with .conf and got it up to 100. 9.2 is doing 200/sec.


    Im tired, long day playin with this stuff. I'll look at those links you pasted in the other thread tomorrow.
    Last edited by LeviJ88; 05-16-2013 at 02:16 PM.

Page 1 of 3 123 LastLast

Similar Threads

  1. Replies: 11
    Last Post: 11-23-2011, 09:21 PM
  2. Replies: 1
    Last Post: 08-11-2011, 08:57 PM
  3. Importing Postgres 8.2 Data into Postgres 8.4
    By jskills in forum Manager General
    Replies: 2
    Last Post: 08-15-2010, 08:23 PM
  4. Which postgres?
    By Arizona Willie in forum Manager General
    Replies: 1
    Last Post: 12-20-2009, 03:21 PM
  5. postgres.exe
    By eightsix in forum Manager General
    Replies: 3
    Last Post: 08-13-2009, 09:29 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •