problem to install postgresql-8.3
Page 1 of 2 12 LastLast
Results 1 to 10 of 12
  1. #1
    Junior Member
    Join Date
    Jul 2009
    Posts
    3

    Default problem to install postgresql-8.3

    Hi, can someone help me to tell me what should i do to install postgresql-8.3. Every time i did exsacly as i red on help page but same error is repeating. It say that " User `postgres` could not be created. The user account already exists.!"
    How i can solve this problem???
    Thanks

  2. #2
    *** HM3! *** fozzy71's Avatar
    Join Date
    Jun 2005
    Location
    HM Support
    Posts
    32,803

    Default

    The simple solution, is to pick a different user name other than the one suggested, such as 'hmpostgresuser' instead of 'postgresuser', which should get you past that road block.

    Otherwise, follow these instructions to uninstall SQL completely and reinstall it. You may not need to do the revo uninstaller portion of the instructions, if you already used the add/remove programs for it.


    Vista: Turn off UAC - http://www.holdemmanager.net/faq/afm....aspx?faqid=73

    Turn off Windows Firewall for installing HM and PostgreSQL. Once you get those installed you can add exceptions to the firewall. If you have a 3rd party firewall, uninstall it completely before installing HM/SQL - http://www.holdemmanager.net/faq/afm...aspx?faqid=171


    For uninstalling SQL please follow these steps:

    -Download Revo Uninstaller and use it to uninstall PostgreSQL. After it uninstalls it will give you options to select and delete all the associated registry entries.
    - manually delete the Program Files\Postgresql folders
    - run the command - start > run > cmd >


    PHP Code:
    net user postgres /delete 
    - reboot.
    - install again, with your firewall uninstalled or turned off if windows firewall


    Logging:

    I would suggest you turn off logging on your new SQL installation as well as these other performance improvements - Top 10: HEM performance increase tips



    To turn off logging, follow these instructions. This is the first thing I do anytime I install SQL for someone.

    - Start > My Computer > Tools > Folder Options > View > UnCheck 'Hide Extensions for known file types' > OK

    - C:\Program Files\PostgreSQL\data\postgresql.conf > Right-Click > Open With.. > NotePad > Check 'Always use this program'

    - Scroll about half way down to ~Lines 245 - 260:

    - The last line of this block of code, for the 'logging_collector', must be changed from On to Off.


    -----
    PHP Code:
    -------------------------------------------------------------------------
    # ERROR REPORTING AND LOGGING
    #------------------------------------------------------------------------------

    # - Where to Log -

    log_destination 'stderr'        # Valid values are combinations of
                        # stderr, csvlog, syslog and eventlog,
                        # depending on platform.  csvlog
                        # requires logging_collector to be on.

    # This is used when logging to stderr:
    logging_collector off        # Enable capturing of stderr and csvlog 
    File > Save; File > Close

    Start > Programs > PostgreSQL 8.3 > Reload Configuration.

  3. #3
    Junior Member
    Join Date
    Jul 2009
    Posts
    3

    Default problem again

    Thanks for quick reply. When i change account name as you told me another window pop up. It say " Internal account lookup failure. No mapping between account names and security IDs was done." Still can`t install.... Please help.

  4. #4
    *** HM3! *** fozzy71's Avatar
    Join Date
    Jun 2005
    Location
    HM Support
    Posts
    32,803

    Default

    See if these thread's suggestions help at all.

    http://www.holdemmanager.net/forum/s...ead.php?t=5363

    http://www.holdemmanager.net/forum/s...ad.php?t=10567

    http://www.holdemmanager.net/forum/s...ead.php?t=8138

    If they don't help, I am probably going to suggest a remote support session with our support manager, to try and get this resolved for you.

  5. #5
    Junior Member
    Join Date
    Jul 2009
    Posts
    3

    Default Same problem

    Hi, i`ve tried to solve this as i red on those forum threads but nothing is working on my computer... Same problem again and again... Need more help. Thanks.

  6. #6
    *** HM3! *** fozzy71's Avatar
    Join Date
    Jun 2005
    Location
    HM Support
    Posts
    32,803

    Default

    Please email me, fozzy@holdemmanager.net, with a link to this thread, and your forum name, so we can schedule a Teamviewer session. Download and install the www.Teamviewer.com software using all the default settings.

  7. #7
    Junior Member
    Join Date
    Jul 2009
    Posts
    22

    Default Error connecting to Postgresql

    I have switched from pokertracker 3 to holdem manager and I already have postgreSQL installed, but it states that HEM cannot connect and is unable to start the service. I have read other posts, but I want to see how I can set this up without wiping out my old hand histories that I want to transfer over to HEM. can someone please help?

  8. #8
    Junior Member
    Join Date
    Jul 2009
    Posts
    22

    Default db issues

    also if I uninstall the old postresql will it delete all of the data?

  9. #9
    *** HM3! *** fozzy71's Avatar
    Join Date
    Jun 2005
    Location
    HM Support
    Posts
    32,803

    Default

    Quote Originally Posted by tothetopIgo View Post
    I have switched from pokertracker 3 to holdem manager and I already have postgreSQL installed, but it states that HEM cannot connect and is unable to start the service. I have read other posts, but I want to see how I can set this up without wiping out my old hand histories that I want to transfer over to HEM. can someone please help?
    To try and get it to connec t, you can go thru these FAQs:

    http://208.109.95.123/faq/afmviewfaq.aspx?faqid=34

    http://www.holdemmanager.net/faq/afm...aspx?faqid=171

    http://208.109.95.123/forum/showthread.php?t=8261


    Quote Originally Posted by tothetopIgo View Post
    also if I uninstall the old postresql will it delete all of the data?

    Export the PT3 DB, and then you can safely reinstall SQL and import those hands to HM.

    http://208.109.95.123/faq/?f=63




    For uninstalling SQL please follow these steps:


    -Download Revo Uninstaller and use it to uninstall PostgreSQL. After it uninstalls it will give you options to select and delete all the associated registry entries.
    - manually delete the Program Files\Postgresql folders
    - run the command - start > run > cmd >

    PHP Code:
    net user postgres /delete 
    - reboot.
    - install again, with your firewall uninstalled or turned off if windows firewall


    Logging:

    I would suggest you turn off logging on your new SQL installation as well as these other performance improvements - Top 10: HEM performance increase tips


    To turn off logging, follow these instructions. This is the first thing I do anytime I install SQL for someone.

    - Start > My Computer > Tools > Folder Options > View > UnCheck 'Hide Extensions for known file types' > OK

    - C:\Program Files\PostgreSQL\data\postgresql.conf > Right-Click > Open With.. > NotePad > Check 'Always use this program'

    - Scroll about half way down to ~Lines 245 - 260:

    - The last line of this block of code, for the 'logging_collector', must be changed from On to Off.

    PHP Code:
    ------------------------------------------------------------------------------
    # ERROR REPORTING AND LOGGING
    #------------------------------------------------------------------------------

    # - Where to Log -

    log_destination 'stderr'        # Valid values are combinations of
                        # stderr, csvlog, syslog and eventlog,
                        # depending on platform.  csvlog
                        # requires logging_collector to be on.

    # This is used when logging to stderr:
    logging_collector off        # Enable capturing of stderr and csvlog 
    File > Save; File > Close

    Start > Programs > PostgreSQL 8.3 > Reload Configuration.

  10. #10
    Junior Member
    Join Date
    Jul 2009
    Posts
    22

    Default Still having issues

    tried these steps and got all the way to step 11 on the 3rd link below. And right before the SQL was finished installing the following errors came up

    "Failed to connect to the template 1 database contributed files are installed, but are not activated in any database"

    "Is the server running on host "127.0.1" and accepting tcp/Ip connections on port 5432"

    Also, as a FYI I could not log into the FAQ section (in the FAQ link). It stated I had entered an improper password/user name.

Similar Threads

  1. postgreSQL install problem
    By XBEW9295 in forum Manager General
    Replies: 9
    Last Post: 05-01-2009, 07:14 PM
  2. PostgreSQL Install Problem
    By Kleiner in forum Manager General
    Replies: 6
    Last Post: 03-17-2009, 04:35 PM
  3. PostgreSQL Install problem
    By Marcus Tranter in forum Manager General
    Replies: 1
    Last Post: 02-09-2009, 05:27 PM
  4. postgresql install problem!!!
    By Macarun in forum Manager General
    Replies: 2
    Last Post: 02-03-2009, 03:04 PM
  5. PostgreSQL Install Port Number Problem
    By Euthanasia in forum Manager General
    Replies: 7
    Last Post: 01-29-2009, 11:44 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
  •