PDA

View Full Version : problem to install postgresql-8.3



carasergio
07-27-2009, 05:14 PM
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

fozzy71
07-27-2009, 07:17 PM
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/afmviewfaq.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/afmviewfaq.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 >



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
(http://208.109.95.123/forum/showthread.php?p=62613&posted=1#post62613)


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.


-----
-------------------------------------------------------------------------
# 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.

carasergio
07-28-2009, 05:24 AM
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.

fozzy71
07-28-2009, 11:06 AM
See if these thread's suggestions help at all.

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

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

http://www.holdemmanager.net/forum/showthread.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.

carasergio
07-29-2009, 07:50 AM
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.

fozzy71
07-29-2009, 08:43 AM
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.

tothetopIgo
07-29-2009, 07:14 PM
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?

tothetopIgo
07-29-2009, 07:16 PM
also if I uninstall the old postresql will it delete all of the data?

fozzy71
07-29-2009, 07:42 PM
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/afmviewfaq.aspx?faqid=171

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



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 >


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
(http://208.109.95.123/forum/showthread.php?p=62613&posted=1#post62613)

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.


------------------------------------------------------------------------------
# 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.

tothetopIgo
08-04-2009, 12:48 PM
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.

fozzy71
08-04-2009, 02:36 PM
Please email fabio@holdemmanager.net, with a link to this thread, and your forum name, so you can schedule a Teamviewer session. Download and install the Teamviewer software using all the default settings.

SAAS
08-12-2009, 05:05 PM
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.

Leave the domain name blank, and it works, simple as that.

Been tearing my hair out past hour trying to get passed this error.