View Full Version : having problems installing postgreSQL 8.3.
wash56
08-17-2009, 08:00 PM
I'm having problems with hold em manager. it says that i need to install postgreSQL 8.3. I keep getting almost to the end of the instillation and it says that the user postgres could not be created. the account already exists . I've never installed this before. Any suggestions would be great
fozzy71
08-18-2009, 12:27 AM
If you installed PT3 it was installed for their DB.
For uninstalling SQL please follow these steps:
-Uninstall PostgreSQL from the Windows Control Panel.
- manually delete the Program Files\Postgresql folders
- run the command - start > run > cmd >
net user postgres /delete
- reboot.
- install PostgreSQL again, with your firewall uninstalled or turned off if windows firewall, using these directions and postgresql.zip version.
http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=176
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.
wash56
08-18-2009, 03:37 AM
i made it to this step and now im stumped again. I dont have an note book to open it with. has the option to open as notebook in onenote. i use xp.this is the step im stumped at
- 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.
__________________
Please view the FAQs and Newb Guide before posting questions.
For every problem it's always a good idea to try the latest Beta first: http://www.holdemmanager.com/downloads/HmBetaUpdate.exe
wash56
08-18-2009, 03:46 AM
i made it through the reload configuration. it still wont connect to it. and i turned off the firewall and changed the setting so the firewall will allow it
netsrak
08-18-2009, 05:45 AM
Fozzy talked about notepad which is a windows texteditor not a note book.
I think the easiest is if we arrange a teamviewer session for the afternoon (in about 6 hours).
Prepare Teamviewer (http://www.teamviewer.com) with the default settings and send the teamviewer id and password via mail to netsrak@holdemmanager.net so i can connect to your system.
wash56
08-18-2009, 02:09 PM
sent you a email .
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.