PDA

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 .