PDA

View Full Version : problems to fet started



lucas
07-21-2009, 09:59 AM
hi guys im tryin to use the software for the 15 day free trial but this is happening when i try to enter the program

The Following error has occurred when trying to initialize the HoldemManager database:ERROR 22023: New encoding (SQL_ASCII) is incompatible with the encoding of the template database (UTF8)

waiting for a solution
regards

fozzy71
07-23-2009, 02:28 PM
My only decent suggestion would be to uninstall/reinstall PostgreSQL, but there may be an easier solution. Hopefully nestrak will see this and have a good idea.

If you decide to reinstall SQL:


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

netsrak
07-23-2009, 03:00 PM
Postgresql 8.4 is not officially support. Check the sticky about this or uninstall and use Postgresql 8.3