Need help with 2nd PC

[Loomis]

Using"windows XP"..... Im trying to get manager up and running on my new computer, I've dwld & registered hem PC2 and am trying to install postgres 8.3 but it will not complete installation "message" cannot create account user already exists, computer is one week old, i've never had postgres installed on it I've tried different user names i've tried 8.4 can't get past the password the only way I can get 8.3 to install is to untick the install as a service box in the account domain section, but the database control panel, can't connect. do I need to uninstall hem and try again. Thanks

[fozzy71]

Please try to follow these steps to completely uninstall and reinstall sql 8.3.


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

Turn off Windows Firewall and Windows Defender 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


Install SQL - 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.

[Loomis]

I've uninstalled it using add/remove should I still download revo? the only files left are the exe. I already have manager/sql on my old laptop I've just bought a new desktop which is the one I can't install postgres on, but I have already registered manager as PC2 should I uninstall that as well, turn firewall off and try again

[netsrak]

The Postgresql installation has nothing to do with holdemmanager installation or registration.

Try to install Postgresql without firewall as Fozzy posted and when this is running we can look after your Holdemmanager registration.

[Loomis]

All good, That worked thanks for your help. Can I just do a back up and restore now of my old database onto the new computer.

[fozzy71]

Yep, hopefully. ;)