problem with postgres

[gregp21]

Hello, i have a problem to install postgres
this message appears :
user "postgres" could not be created , the user account already exist

[fozzy71]

Vista: Turn off UAC - http://www.holdemmanager.net/faq/afm....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/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 >

net user postgres /delete 

- reboot.
- install again, with your firewall uninstalled or turned off if windows firewall


Install SQL - http://www.holdemmanager.net/faq/afm...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


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.