PDA

View Full Version : PostgreSQL 8.4 FINAL release (8.4.0-1)



Pages : [1] 2

Patvs
07-01-2009, 07:07 PM
PostgreSQL 8.4 FINAL (http://www.postgresql.org/download/windows) is released after 3 months of the first 8.4 beta. 8.4 is supposed to be faster and has a HUGE list (http://www.postgresql.org/docs/8.4/static/release-8-4.html) of updates.

If you are running HEM with PostgreSQL 8.3 and there are no problems stick to 8.3!
Only on special dual server XEON computers (with 32 cores), were they able to see a big improvement with 8.4. Having said that, HEM will change some of their program code in the future to be able to use some of the improvements of 8.4.

First always, please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe

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

Turn off Windows Firewall 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 or manually set \holdem manager\dbcontrolpanel.exe, holdemmanager.exe and hmhud.exe are started as administrator. Run the windows explorer and navigate to your Holdemmanager installation directory. Right click the executables and select "Run as admin" from the popup menu.

If you want to install/upgrade to 8.4, it seems 8.4 has several installation problems.
-Some users can't get past the "insert password" since it sometimes doesn't accept your normal (postgrespass) password. To RESET your password for reinstalling SQL to a new/empty DB, please follow these steps:

1) Uninstall PostgreSQL from the Windows Control Panel.
2) manually delete or rename the Program Files\Postgresql folders
3) run the command - start > programs > accessories > command prompt > right-click > run as administrator

net user postgres /delete
4) reboot.
5) Install PostgreSQL 8.4, with your firewall uninstalled or turned off if windows firewall - http://www.enterprisedb.com/products/pgdownload.do#windows


----
Also be carefull with the Tuning Wizard. On some systems it will make changes to the postgresql.conf it shouldn't, resulting in being unable to connect to the database.
If you experience this problem--> go to the 8.4/data folder, and delete postgresql.conf, and rename the backup postgresql.conf.2009(data xxxxxxxx) to "postgresql.conf" and reboot.

Windows VISTA/7 users: Sometimes you can get a "secondary logon" not found error during the installation. To fix this, rightclick my computer---> Manage--->Services and Applications---> Services---> find Secondary Logon (and start service)


--

Thanks to squalzen & luckylucky for a step by step backup & upgrade guide:


Do a backup of your HM databases

Postgres
Open PGAdminIII – Found in Start ->Programs->PostgreSQL8.3.
Right click on PostgreSQL Database Server 8.3(localhost:5432) and click Connect. Enter your password.
Select your database(s), right click and backup each one you want to keep.
HoldemManager
Export all your hands from HM, as they could be needed as you will see in step 5 later. You can do this by either running DBControlPanel.exe located in your holdemmanager folder or via holdemmanager itself under Options ->Database Management.
Click connect to your old database.
Once in the Database Control Panel – Click Export Hands for each database that you want.

Stop the PostgreSQL services (8.3)
Found in Start ->Programs->PostgreSQL8.3. -> stop service
Download and run the latest 8.4 installer
Latest installer found at http://www.postgresql.org/download/windows
Install the exe (for Vista users might be best to right click on the exe and run as administrator)
Enter your postgres password for both Password and Retype Password textboxes. Click Next.
Enter 5432 for Port. Click Next.
Leave Locale as (Default locale)
Leave Install pl/pgsql in template1 database checked.
Click next. Wait a few minutes.
Uncheck Launch Stack builder at exit. Click Finish.
Open Database Management from HoldEmManager or run DBControlPanel.exe from your HoldemManager directory.
Don’t worry if you receive “The following error occurred when trying to open the database Fatal……………..”. just click OK and connect to Database Control Panel. Create a new database (name does not have to be same as the back up databases) and set as default. Click "Start HoldemManager". Close HoldemManager.
Open PGAdminIII (make sure you do this via Start ->Programs->PostgreSQL8.4(preferably not 8.3, not sure if it makes any real difference though) and connect to the 8.4 server.
Select the database you just created.
Restore the database(s) that you backed up earlier into their new counterparts.
Click on the database, Right click and Click Restore and browse to the file where you backed up your database. On restore Database window, keep the defaults as they are and simply select OK. Wait for restore to complete (can take quite a long while) If window has (Not responding on it) you can ignore this, it’s just an intensive task that takes a long time.
Test
Open HoldemManager when the restore is finished and check if all the players, hands, reports, etc. are restored.
Uninstall old version
If all is Ok uninstall postgreSQL 8.3 (in Vista from Control Panel -> Programs and Features.)
Reboot



----

Still Can't Connect to PosgreSQL? Try This! (http://forums.holdemmanager.com/showthread.php?t=8261)

Tips and tricks to solve other problems can be found in this thread.
Post in this thread if you have problems or additional questions.

Dadishome
07-02-2009, 05:51 AM
+1 :)

rckyu
07-02-2009, 07:43 AM
Just installed PostgreSQL Version 8.4.0-1 (http://www.enterprisedb.com/products/pgdownload.do#windows), HEM 1.09 beta 11a (http://www.holdemmanager.net/forum/showthread.php?t=11641) on Microsoft Windows 7 Build 7260 RTM X86 (with secondary logon activated).

Got this error:

http://img43.imageshack.us/img43/8202/dberror.th.png (http://img43.imageshack.us/i/dberror.png/)

Any suggestions?

Dadishome
07-02-2009, 07:51 AM
Just installed PostgreSQL Version 8.4.0-1 (http://www.enterprisedb.com/products/pgdownload.do#windows), HEM 1.09 beta 11a (http://www.holdemmanager.net/forum/showthread.php?t=11641) on Microsoft Windows 7 Build 7260 RTM X86.

Got this error:

http://img43.imageshack.us/img43/8202/dberror.th.png (http://img43.imageshack.us/i/dberror.png/)

Same thing for me. The only thing working for me is to install postgresql with the pginstaller 8.4 beta2. It's the last one i found, apparently the last release 8.4 only exists in one click installer which doesn't ask for chose encoding SQL_ASCII, that's why it doesn't work I guess. I also tried to change encoding of postgre database in pgadmin but I didn't find out how to do that.

Wietse
07-02-2009, 12:59 PM
did you try dbpass ?

OngameNL1000
07-02-2009, 01:10 PM
Same thing for me. The only thing working for me is to install postgresql with the pginstaller 8.4 beta2. It's the last one i found, apparently the last release 8.4 only exists in one click installer which doesn't ask for chose encoding SQL_ASCII, that's why it doesn't work I guess. I also tried to change encoding of postgre database in pgadmin but I didn't find out how to do that.

Has anyone solved this yet?

fish
07-02-2009, 03:52 PM
When I start the

postgresql-8.4.0-1-windows.exe

i get an errormessage:


"An error occured executing the Microsoft VC++ runtime installer."

and the installation is canceled.


Any idea?

montanatoni
07-02-2009, 06:05 PM
for sql__ASCII error you must install with this file http://ftp.ua.postgresql.org/pub/mirrors/postgresql.org/binary/v8.4beta2/win32/postgresql-8.4-beta2.zip

for wrong password : before installation you must write "net user postgres /delete" in windows command.

take care you must backup your DB before install new version for safe.

jurrasstoil
07-03-2009, 08:21 AM
Hey,

are there any performance benchmarks out there?
It would be great to see a comparison between 8.2, 8.3 and 8.4.

I'm currently running 8.2 on my laptop and 8.3 on my desktop and would like to know if upgrading is worth the trouble.

Patvs
07-03-2009, 11:17 AM
http://www.kaltenbrunner.cc/blog/uploads/82vs83b4.gif

Found this on the web here. (http://www.kaltenbrunner.cc/blog/index.php?/archives/21-8.3-vs.-8.2-a-simple-benchmark.html).. (he also has 8.4. benchmarks on his site)

("tuned" is increasing # shared_buffers=1536MB, # wal_buffers=1024kB, # effective_cache_size=3084MB, etc.... and he uses an 8 core system)



I found other 8.4. benchmarks too, which stated 8.4. is as fast as 8.3. and only a LOT faster if you have more than 16 (!) CPU CORES.
(there was no noticable improvement increase with 8 cores! since all of us will have 1-4 cores, I 'm not sure we'll notice any improvements)

jurrasstoil
07-03-2009, 11:29 AM
yeah, i found the same.
But it lacks the 8.4 final :(

Patvs
07-03-2009, 02:33 PM
At the OCZ forum (http://www.ocztechnologyforum.com/forum/showthread.php?t=54038&highlight=postgres), there are many benchmarks of running PostgreSQl 8.3 on a regular harddisk vs a SSD harddisk (both desktop and on laptops).

The benchmarks seem really useful for Holdem Managers users. (especially those thinking of buying a new computer, considering an SSD harddisk or a RAID0 setup) And they also test tweaking the postgresql.conf (shared_buffers, effective_cache_size, etc.)

However they do the tests with pgbench (contained in postgresql in the contrib directory) I don't have pgbench in my contrib directory.

madlion
07-03-2009, 07:15 PM
Any one have 8.4 playing well with HEM?

Patvs
07-03-2009, 10:45 PM
I just transferred my database to 8.4beta2 and now everything works fine.
(also updated to pgAdmin III 1.10!)

My problem with 8.4.0-1 was the one-click installer just didn't work for me. The regular 8.4beta2 installer does work. But I noticed it was not set automatically to the default encoding setting of SQL_ASCII, so remember to set it to SQL_ASCII during the installation.

Supposingly, in major PostgreSQL updates 8.2-->8.3-->8.4 you should use migrate or simply import all the hand histories in a new database.

pg_migrator (I deleted the link to pg_migrator in the opening post) and it's useless ten (!) step manual to migrate a database was way too complicated for me. Also I didn't understand the MigrationWizard (can be found just as the great TuningWizard using the Application Stack Builder).

So I simply backuped my database in pgAdmin--> uninstalled PostgreSQL 8.3. Installed 8.4. Restored my database in pgAdmin. And everything works fine. I'll wait for a normal installer of 8.4.0-1 to see if I can get that to work.
(and I'll reimport all the actual handhistories if I get my new computer this month... and test Windows 7)




----
Unfortunately, I still can't do a benchmark to compare the performances of 8.3 vs 8.4. I don't understand how to use pgbench.

C34FwT
07-04-2009, 04:21 AM
At the OCZ forum (http://www.ocztechnologyforum.com/forum/showthread.php?t=54038&highlight=postgres), there are many benchmarks of running PostgreSQl 8.3 on a regular harddisk vs a SSD harddisk (both desktop and on laptops).

The benchmarks seem really useful for Holdem Managers users. (especially those thinking of buying a new computer, considering an SSD harddisk or a RAID0 setup) And they also test tweaking the postgresql.conf (shared_buffers, effective_cache_size, etc.)

However they do the tests with pgbench (contained in postgresql in the contrib directory) I don't have pgbench in my contrib directory.

here (https://projects.commandprompt.com/public/replicator/browser/trunk/contrib/pgbench?rev=1)
insructions (https://projects.commandprompt.com/public/replicator/browser/trunk/contrib/pgbench/README.pgbench?rev=1)

Alex
07-06-2009, 02:40 AM
i also had the Ascii error, but finaly i got 8.4 (final) running...

1 -> deinstalled 8.3
2 -> deleted the postgresql data-folder (made a backup before)
2 -> installed 8.4beta2 with SQL_ASCII encoding
3 -> created a new HM-Database
4 -> imported all HH into the new Database
5 -> deinstalled 8.4beta2
6 -> installed 8.4 (final-oneclick) using the data folder from the 8.4beta2 installation (the one with the new database)
7 -> start HM -> success -> at least for me ;)

you can try to skip the steps 3 to 4 and excecute them after step 6. should work too.

Dadishome
07-06-2009, 05:15 AM
i also had the Ascii error, but finaly i got 8.4 (final) running...

1 -> deinstalled 8.3
2 -> deleted the postgresql data-folder (made a backup before)
2 -> installed 8.4beta2 with SQL_ASCII encoding
3 -> created a new HM-Database
4 -> imported all HH into the new Database
5 -> deinstalled 8.4beta2
6 -> installed 8.4 (final-oneclick) using the data folder from the 8.4beta2 installation (the one with the new database)
7 -> start HM -> success -> at least for me ;)

you can try to skip the steps 3 to 4 and excecute them after step 6. should work too.

Thanks. It works :)

fozzy71
07-06-2009, 07:35 AM
This sounds like a fun little project for this afternoon. :p

netsrak
07-06-2009, 08:59 AM
For you Fozzy?
Would be nice if you post your experiences because the first users at pokerstrategy start asking about postgresql8.4 :)

fozzy71
07-06-2009, 10:16 AM
Yes, for me.

I just exported and backed up my old DB, uninstalled it, defragged. Now getting ready to follow those cliff-note instructions to attempt an install.

Probably going to try and do a restore of my 8.3 DB, as well as an import of all my archives to a new DB. I wish now, that I hadn't forgot to make an actual copy of my \data folder before uninstall, so I could try that method as well.

fozzy71
07-06-2009, 10:54 AM
i also had the Ascii error, but finaly i got 8.4 (final) running...

1 -> deinstalled 8.3
2 -> deleted the postgresql data-folder (made a backup before)
2 -> installed 8.4beta2 with SQL_ASCII encoding
3 -> created a new HM-Database
4 -> imported all HH into the new Database
5 -> deinstalled 8.4beta2
6 -> installed 8.4 (final-oneclick) using the data folder from the 8.4beta2 installation (the one with the new database)
7 -> start HM -> success -> at least for me ;)

you can try to skip the steps 3 to 4 and excecute them after step 6. should work too.

So will there be any problems with new databases that are created later, after having snuck around the SQL ASQII encoding situation?


*Edit - Attempt #1 was a complete disaster.

I attempted the shortcut of not importing my hands to the 8.4 Beta 2 installation. Instead I tried installing with that (basically empty) data folder in place. Couldn't connect, etc.

Alex
07-06-2009, 11:09 AM
So will there be any problems with new databases that are created later, after having snuck around the SQL ASQII encoding situation?

creating new databases works fine for me.

if i understood it right (without guarantee) the important thing is, that the default database "postgres" was created using ASCII. if you create a new database the "postgres"-database works as template for the new one. so the new database will also have the Ascii-encoding and will work with HM. (edit: that is why i thought skipping steps 3 and 4 would work)

edit: there was a checkbox (saying something like: ...template1...) somewhere during the installation process of 8.4 final. i am not sure if i have unchecked the box and if that setting has any influence on the success of the installation process.

fozzy71
07-06-2009, 11:36 AM
When installing the beta version should I be using SQL ASCII for both client and server encoding?

Alex
07-06-2009, 11:41 AM
When installing the beta version should I be using SQL ASCII for both client and server encoding?

yes

fozzy71
07-06-2009, 11:46 AM
I did.

I uninstalled SQL, deleted postgres user account, and rebooted.

Then I installed the 8.4 Beta 2, and chose sql ascii for both.

I then opened HM and it connected fine and created a DB. (should I not have done this step til after I get 8.4 installed the 2nd time??)

Then I uninstalled SQL, deleted the postgres user, but left the data folder, and rebooted.

Installed the 8.4 1-click, it detected my DB and said it would use it. After installation the postgres service would not start.

R_Andersen
07-06-2009, 11:51 AM
I'm giving this a try today as well. So far here is what I've done:

1. Exported all my hands from HEM.
2. Uninstalled both postgres 8.3 and HEM and deleted the user postgres
3. Installed PG 8.4 beta2
4. Isntalled HEM and patched to beta 13.
5. Started HEM and created as new database but didn't import any hands.
6. Uninstalled PG 8.4 beta2
7. Installed PG 8.4 final in the same directory as beta2 was isntalled (I think this is important). The data folder was still present and PG asked for the password and gave me a dialog box saying it was using all settings from the previous installation.
8. Started HEM and now I'm importing all my hands.

So far everything is working but the import speed is SLOW. I usually get about 60-70 hands per secondand I'm only inporting at about 20 now.

-Rob

R_Andersen
07-06-2009, 11:52 AM
I did.

I uninstalled SQL, deleted postgres user account, and rebooted.

Then I installed the 8.4 Beta 2, and chose sql ascii for both.

I then opened HM and it connected fine and created a DB. (should I not have done this step til after I get 8.4 installed the 2nd time??)

Then I uninstalled SQL, deleted the postgres user, but left the data folder, and rebooted.

Installed the 8.4 1-click, it detected my DB and said it would use it. After installation the postgres service would not start.

I did the same (see post above) but didn't delete the postgres user after uninstalling 8.4 beta and it worked for me. You might want to try that.

-Rob

fozzy71
07-06-2009, 12:07 PM
Oh, OK. I was tempted to not delete the postgres user account, but I wasn't sure. :(

fozzy71
07-06-2009, 12:13 PM
I'm giving this a try today as well. So far here is what I've done:

1. Exported all my hands from HEM.
2. Uninstalled both postgres 8.3 and HEM and deleted the user postgres
3. Installed PG 8.4 beta2
4. Isntalled HEM and patched to beta 13.
5. Started HEM and created as new database but didn't import any hands.
6. Uninstalled PG 8.4 beta2
7. Installed PG 8.4 final in the same directory as beta2 was isntalled (I think this is important). The data folder was still present and PG asked for the password and gave me a dialog box saying it was using all settings from the previous installation.
8. Started HEM and now I'm importing all my hands.

So far everything is working but the import speed is SLOW. I usually get about 60-70 hands per secondand I'm only inporting at about 20 now.

-Rob

Probably would have helped if you cleaned and defragged after deleting your old DB and exporting all those hands. I will let you know, after I finally get it importing.

Alex
07-06-2009, 12:41 PM
So far everything is working but the import speed is SLOW. I usually get about 60-70 hands per secondand I'm only inporting at about 20 now.

-Rob

same here - import speed dropped from 60 to 40. i havent done any defrag or vacuum so far (edit: but have done some other speed tuning that i havent done with 8.3 -> set some anitvirus rules in kaspesky and changed some values in the postgresql.conf ) . when i have completed defrag and vacuum i will post the import speed again.

fozzy71
07-06-2009, 12:47 PM
OK. I got it running, thanx to the last set of cliff notes.

I then imported my HM Processed files for this year, about 20k hands. I got a bit more than half my former speed. I used to get 70 - 80 h/s, but was only getting ~40 h/s with 8.4.

Then I turned off my logging collector and ran the stackbuilder for performance tuning. You have to run stackbuilder, which will download and install the tuning wizard. Then u have to run it so it can tailor to your machine specs. I chose the dedicated option.

Now I am importing an older chunk of similar HM Processed files after tuning, and getting ~60 h/s. So about a 50% increase in importing speed after tuning.


*Edit - Import speed dropped back to ~50 h/s. Running a vac/full/analyze, and then going to import my previous DB export.

**Edit - Bulk import is now going to take 2.5 hours instead of the typical 1.5. :(


Can't wait til this fall when I build my new (Hi-Performance) PC. :D

Patvs
07-06-2009, 01:09 PM
Can't wait til this fall when I build my new (Hi-Performance) PC. :D

Same here.. :)


The trick to install 8.4.0-1 into the same directory as the 8.4 beta2 also worked for me. Everything works fine now. Didn't notice the HH import decrease though.

R_Andersen
07-06-2009, 01:29 PM
To be honest I'm not to concerned with the bulk import spped. I was just hoping this new PG version would speed up the HUD performance on my laptop that I use to play with. Right now, once I get over 12 or so tables things start to lag. It's playable up to 16 tables but I'm hoping this version reduces lag some.

-Rob

fozzy71
07-06-2009, 02:06 PM
To be honest I'm not to concerned with the bulk import spped. I was just hoping this new PG version would speed up the HUD performance on my laptop that I use to play with. Right now, once I get over 12 or so tables things start to lag. It's playable up to 16 tables but I'm hoping this version reduces lag some.

-Rob

Make sure you do a full round of maintenance and performance.

Vac/analyze, defrag (w/ SQL stopped), turn off logging and delete any logs from \pg_log that you have accumulated, run enterprise tuning wizard, etc.

Top 10 Performance tips for HM (http://208.109.95.123/forum/showthread.php?p=62613&posted=1#post62613)

Cliff notes to turn off/delete logs:
(The postgresql.conf file looks a bit different in 8.4, but the particular line of code you need to edit is the same.

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

*edit:
- Start > My Computer > C:\Program Files\PostgreSQL\data\pg_log, or C:\Program Files (x86)\PostgreSQL\data\pg_log, if you have 64 bit Vista. Delete all files in that folder. And it might be a good idea to empty your recycle bin at that point, or use a 3rd party utility like CCleaner (http://www.ccleaner.com) to clean up all your junk/temporary files. You want to do this before you get to the vacuum and defrag process.

squalzen
07-06-2009, 02:14 PM
It's not so difficult :)

1- Do a restore of your HM databases
Run PGAdmin, select your database, right clic and backup
You can also export all your hands from HM to be sure.
Run DBControlPanel.exe connect to your old database, clic export hands

2- Stop the PostgreSQL services (8.3)
Start, Programs, PostgreSQL 8.3, stop server (or services)

3- Dowload and run the 8.4 installer
http://www.enterprisedb.com/getfile.jsp?fileid=586
Give your postgres password, choose 5432

4- Open PGAdmin3 and connect to the 8.4 server

5- Create a new database, HoldemManager
Right clic Databases, clic add new database
Choose a name
Select postgres as owner
Select Template0
Validate

6- Restore your database
Right clic the new databasename HoldemManager
choose restore
Choose your backup file

7- Launch HoldemManager
or run DBControlPanel.exe from your HoldemManager directory
Choose the new database as default

8- test
test everything

9- Delete old version
If all is Ok Delete the postgresl 8.3

Reboot and enjoy
(you can also defrag after reboot. Stop postgresql first)


Pascal

fozzy71
07-06-2009, 03:49 PM
Apparently I shouldn't have uninstalled 8.3, because after rebooting HM will not connect and SQL will not start for 8.4. FML

R_Andersen
07-06-2009, 04:16 PM
Apparently I shouldn't have uninstalled 8.3, because after rebooting HM will not connect and SQL will not start for 8.4. FML

Interesting. I've rebooted a few times and finished importing everything and it still works fine. I haven't played any new hands yet, so we'll see how it behaves later when I do.

-Rob

fozzy71
07-06-2009, 04:55 PM
For now I just installed 8.3 again along side it on port 5433 and started a 2nd (duplicate LOL) DB, until I can sort out what went wrong with 8.4 after a single reboot. :(

Alex
07-07-2009, 02:18 AM
after vacuum and defrag i imported 1.3 mio hands at a rate of 47 hands/sec. which is a 20% increase to what i have posted earlier in this thread.
top peak was 57 hands/sec over the first 300k hands. i guess i have to do a defrag every 300k hands from now on....

Tranclugator
07-07-2009, 01:03 PM
I think we need official info from HM developers about whether 8.4 will be supported or not ;)

Bacco777
07-08-2009, 02:47 PM
This is the worst pile of shit ever here on the HM forums.

Somebody please make a decent post on how to configure 8.4 without getting error after error.

To all of you who want to install 8.4: DONT DO IT. It just screws up everything.

Wait until someone comes up with a 100% verified solution.

fozzy71
07-08-2009, 03:51 PM
^^

That should have been obvious after I tried and failed twice. No one here from HM recommended anyone try 8.4. Our FAQs still suggest using the same 8.3.7 version.


You can leave your 8.3 server installed and install 8.4 to use port 5433. Easy peasy. I currently have 2 copies of my DB. A functional one in 8.3, and one in 8.4 I havent had time to try and get connecting properly.

Ajeto
07-11-2009, 03:30 PM
Just installed PostgreSQL Version 8.4.0-1 (http://www.enterprisedb.com/products/pgdownload.do#windows), HEM 1.09 beta 11a (http://www.holdemmanager.net/forum/showthread.php?t=11641) on Microsoft Windows 7 Build 7260 RTM X86 (with secondary logon activated).

Got this error:

http://img43.imageshack.us/img43/8202/dberror.th.png (http://img43.imageshack.us/i/dberror.png/)

Any suggestions?


+1
Running XP SP3

Patvs
07-11-2009, 05:27 PM
PostgreSQL 8.4.01 installation sets its standard encoding to UTF8, but the templete database should be in SQL_ASCII for HoldemManager.

It's very difficult to change this after you've installed 8.4.01 (unless you manage to delete the template database "postgres")

So just install 8.4.01 into the data folder of your old (8.3) database, and 8.4.01 will take over the right SQL_ASCII encoding.

bilbo-san
07-12-2009, 01:50 AM
Am I retarded? How the hell do I change the encoding? I see no options for doing this in pgadmin

ash0803
07-14-2009, 12:51 AM
I installed 8.4 and created a new database using pgadmin with SQL-ASCII encoding. I restored a backup made with 8.2 (around 3GB in size) and everything seems to be working fine.

However, obviously I wouldn't be able to create new databases because of the encoding issue. I just wanted to ask if anyone from the team or anyone at all would be nice enough to create a blank HEM database then just do a backup of it and send to me?

Would be really grateful...Thanks

mfm000
07-14-2009, 03:47 AM
I installed 8.4 and created a new database using pgadmin with SQL-ASCII encoding. I restored a backup made with 8.2 (around 3GB in size) and everything seems to be working fine.

However, obviously I wouldn't be able to create new databases because of the encoding issue. I just wanted to ask if anyone from the team or anyone at all would be nice enough to create a blank HEM database then just do a backup of it and send to me?

Would be really grateful...Thanks

Try using PGAdmin to create a new SQL_ASCII encoded database using an existing HEM database as a template.

madlion
07-14-2009, 09:13 AM
This is the worst pile of shit ever here on the HM forums.

Somebody please make a decent post on how to configure 8.4 without getting error after error.

.

Looking forward to this....

meganton
07-14-2009, 03:02 PM
Try using PGAdmin to create a new SQL_ASCII encoded database using an existing HEM database as a template.

yes, you can also create new DB using PGAdmin, with WIN1252 encoding using template0 TEMPLATE option. and then export backed up 8.3(2) HM database there. It works fine for me

rbooz
07-14-2009, 08:12 PM
yes, you can also create new DB using PGAdmin, with WIN1252 encoding using template0 TEMPLATE option. and then export backed up 8.3(2) HM database there. It works fine for me

same for me. I used sql_ascii encoding though.

netsrak
07-16-2009, 04:41 PM
I created an empty Holdemmanager database which you can use for the Postgresql 8.4 installation: http://www.holdemmanager.com/downloads/hm8.4.backup

Installation:

1. Install postgresql 8.4 (download from www.postgresql.org). The installation is much smarter than 8.3. Some computers which fail with 8.3 work with 8.4. So its worth a try.

2. After successful completion of the installation start pgadminIII and connect to the database server

3. Via right mouse click create a new empty database (for example "Holdemmanager"). Use SQL_ASCII encoding (haven't tested WIN1252) with the template0

4. Via right mouse click on this new database choose Restore, select "only schema" and choose the backup file from the link above.

5. After completion of this restore process you can start Holdemmanager and connect to this database.

fozzy71
07-16-2009, 05:27 PM
I will try this tonight or tomorrow and be back here bitching at you if it doesn't work. :D

netsrak
07-16-2009, 05:40 PM
:cool:

If it doesn't work please contact nets....... to schedule a teamviewer session

ash0803
07-16-2009, 07:00 PM
I created an empty Holdemmanager database which you can use for the Postgresql 8.4 installation: http://www.holdemmanager.com/downloads/hm8.4.backup

Installation:

1. Install postgresql 8.4 (download from www.postgresql.org). The installation is much smarter than 8.3. Some computers which fail with 8.3 work with 8.4. So its worth a try.

2. After successful completion of the installation start pgadminIII and connect to the database server

3. Via right mouse click create a new empty database (for example "Holdemmanager"). Use SQL_ASCII encoding (haven't tested WIN1252) with the template0

4. Via right mouse click on this new database choose Restore, select "only schema" and choose the backup file from the link above.

5. After completion of this restore process you can start Holdemmanager and connect to this database.

Thanks.. that was exactly what I was looking for.. haven't used it for anything but it created and loaded through HEM perfectly.

Also, just to let you guys know that I was running 8.2 before and importing around 30 h/s but now its around 45 h/s which is nice. Cheers

Cisse245
07-16-2009, 09:04 PM
when i chose restore, i have this : " pg_restore: [archiver] unsupported version (1.11) in file header

Process returned exit code 1."

any idea ?

netsrak
07-17-2009, 04:02 AM
What are you trying to do in which postgreql version?

Cisse245
07-17-2009, 07:17 AM
I just followed the steps you gave

netsrak
07-17-2009, 08:07 AM
Are you sure? "pg_restore: [archiver] unsupported version (1.11) in file header"

This message tells me that there is a version mismatch. Have you installed postgresql 8.4 and use pgadmin 1.10?

Please add some screenshots of what you are trying to do.

Cisse245
07-17-2009, 08:39 AM
mmh, are you avaible for a teamviewer session please ?

netsrak
07-17-2009, 08:55 AM
Yes ok, because its a special issue ;)

Please send me your teamviewer details to netsrak@holdemmanager.net

mfm000
07-17-2009, 02:12 PM
when i chose restore, i have this : " pg_restore: [archiver] unsupported version (1.11) in file header

Process returned exit code 1."

any idea ?

Change the setting for the bin path inside PGAdmin3 to point to the
8.4 version bin directory. Its still pointing to the 8.3 version.
The 8.4 install didn't update this.

Cisse245
07-17-2009, 02:30 PM
yeah , thank you, it was that and netsrak help me with this ;)

netsrak
07-17-2009, 03:42 PM
we took the command line call :)

CarolinaK1d
07-17-2009, 10:04 PM
I created an empty Holdemmanager database which you can use for the Postgresql 8.4 installation: http://www.holdemmanager.com/downloads/hm8.4.backup

Installation:

1. Install postgresql 8.4 (download from www.postgresql.org). The installation is much smarter than 8.3. Some computers which fail with 8.3 work with 8.4. So its worth a try.

2. After successful completion of the installation start pgadminIII and connect to the database server

3. Via right mouse click create a new empty database (for example "Holdemmanager"). Use SQL_ASCII encoding (haven't tested WIN1252) with the template0

4. Via right mouse click on this new database choose Restore, select "only schema" and choose the backup file from the link above.

5. After completion of this restore process you can start Holdemmanager and connect to this database.


I recently did a complete reinstall of everything (OS, etc). Will this method work when doing a clean install of HEM and PostgreSQL from scratch??

fozzy71
07-17-2009, 11:35 PM
Yes, it should, afaik.

jurrasstoil
07-19-2009, 08:29 PM
So, will 8.4 improve the performance for the normal users?
I've read some pdfs with graphs etc. but most of them where for multiple accesses and i'm just using HEM and that database will not get accessed by 600 people at once :D

Not sure if all the trouble is worth it :confused:

netsrak
07-20-2009, 04:17 AM
If you have a running system leave it as it is. There is no significant performance increase with postgresql 8.4 (but the installation is much smarter, which solves a lot of the standard installation problems).

nickjehz
07-20-2009, 02:14 PM
Hi,

I just bought HM and I want to install the postgreSQL and I got that SQL_ASCII error like some other people here..

but all the awnsers are about how to fix it VIA 8.3..

When i install 8.4 i cant select an encoding type so its standard at UTF8..

How can i fix this.. help me plz!

or what version should i use otherwise

thanks allready

netsrak
07-20-2009, 02:38 PM
When you create a new database you can select the coding in 8.4. Read my guide some posts before.

Otherwise use the standard 8.3.7

nickjehz
07-20-2009, 02:55 PM
I gotit to work! :) thanks

madlion
07-22-2009, 04:33 AM
I created an empty Holdemmanager database which you can use for the Postgresql 8.4 installation: http://www.holdemmanager.com/downloads/hm8.4.backup

Installation:

1. Install postgresql 8.4 (download from www.postgresql.org). The installation is much smarter than 8.3. Some computers which fail with 8.3 work with 8.4. So its worth a try.

2. After successful completion of the installation start pgadminIII and connect to the database server

3. Via right mouse click create a new empty database (for example "Holdemmanager"). Use SQL_ASCII encoding (haven't tested WIN1252) with the template0

4. Via right mouse click on this new database choose Restore, select "only schema" and choose the backup file from the link above.

5. After completion of this restore process you can start Holdemmanager and connect to this database.

Thank You. NP on clean install of Windows 7.

I did get a connection error but worked after:

Start Menu>All Programs>PostgresSQL 8.4>Reload Configuration
Start Menu>All Programs>PostgresSQL 8.4>Restart Server

Ragdollar
07-23-2009, 09:51 AM
I can't get passed the password request when trying to upgrade from 8.3 to 8.4 ?

I have the default password "dbpass", but my password is not recognized, so I can't upgrade - frustrating !

Could it be an AVG Internet Security system issue?
The firewall maybe ?

Anybody got an idea on what I need to do to be able to install the upgrade?

/Anders

netsrak
07-23-2009, 11:28 AM
There is no upgrade from 8.3 to 8.4. You need to install 8.4 on a separate port or uninstall 8.3 before installing 8.4.

Ragdollar
07-23-2009, 03:53 PM
well, netsrak.
Tried to uninstall 8.3.
The issue with invalid password remains when I tried to install 8.4.

So, now I don't have a working HM .. not so nice ..
Need to reset the password, haven't got a clue how to do that.

Anybody know ?

Patvs
07-23-2009, 04:12 PM
I had the same problem. (some of my posts about this problem are on page 1 and 2 of this thread)

I fixed it by installing 8.4beta2. (8.4beta2 has a normal install, where it doesn't ask for a pasword I didn't have). I restored my 8.3 backup in 8.3beta2.
And then installed 8.4 on top of 8.3beta2

Ragdollar
07-23-2009, 04:24 PM
Ok Patsvs, I'll try that too then.
Thanks for the tip !

/Anders

netsrak
07-23-2009, 04:27 PM
You must delete the Postgresql User:

Open a command box (Start->Run->cmd) and type
net user postgres /delete
and/or
net user postgresuser /delete

and restart the installation

Ragdollar
07-23-2009, 04:33 PM
I can't get hold of a beta-version now.
Hate this kind of problems, guess I just have to wait for answers directly from the PostgreSQL people ..

Installations and upgrades should be simple nowadays, feels like being back in the 80's again. Just don't understand why I just can't choose to install without password, or using defalut (dbpass) or just reset during installation ??

/Anders

madlion
07-23-2009, 08:21 PM
Is this the correct may to restore a db in 8.4?

1. Click create a new empty database. Use SQL_ASCII encoding with the template0

2. Via right mouse click on this new database choose Restore, select "only schema" and choose the backup file from the link above. Would I not tick "only schema" in this case?

This is a 8.4 DB fwiw.

netsrak
07-24-2009, 05:19 AM
yes

Bacco777
07-24-2009, 05:24 AM
Has anyone noted any difference in respect of import speeds?

Ragdollar
07-24-2009, 07:51 AM
thanks netsrak, that worked fine, I now have the 8.4 version installed.

But still have problem, cant initialize a new Holdem Manager database?
Get errorcode: .. Error 22023: new encoding (SQL_ASCII) is incompatible with the encoding of the template database (UTF8) ...


I got Poker Tracker 3 to work just fine with the newly installed postgreSQL 8.4.
But Holdem Manager still give me problems in creating a new database?

What to do?
Don't want to reinstall 8.4 again, afraid to mess up PT3 alos - then I don't have any working poker application at all again ..

netsrak
07-24-2009, 08:13 AM
...

2. After successful completion of the installation start pgadminIII and connect to the database server

3. Via right mouse click create a new empty database (for example "Holdemmanager"). Use SQL_ASCII encoding (haven't tested WIN1252) with the template0

...

as i wrote...you need to choose template0 instead of template

madlion
07-24-2009, 08:17 AM
@ragdollar

Obviously skip step one, you will need to use pgadminIII to create your new database just follow step three and four and a reboot before step five should do the trick.


I created an empty Holdemmanager database which you can use for the Postgresql 8.4 installation: http://www.holdemmanager.com/downloads/hm8.4.backup

Installation:

1. Install postgresql 8.4 (download from www.postgresql.org). The installation is much smarter than 8.3. Some computers which fail with 8.3 work with 8.4. So its worth a try.


2. After successful completion of the installation start pgadminIII and connect to the database server

3. Via right mouse click create a new empty database (for example "Holdemmanager"). Use SQL_ASCII encoding (haven't tested WIN1252) with the template0

4. Via right mouse click on this new database choose Restore, select "only schema" and choose the backup file from the link above.

5. After completion of this restore process you can start Holdemmanager and connect to this database.

i fail...

Ragdollar
07-24-2009, 11:19 AM
netsrak and madlion .. thanks a lot guys !

I was a bit thick there, didn't really follow your instructions to the point netsrak . Was a bit stressed out and frustrated.

Everything works fine now again .. :D

Back to the tables .. :cool:

inveki
07-26-2009, 09:14 AM
@ netsrak + madlion

got to step 2

but am confused where to right click

3. Via right mouse click create a new empty database (for example "Holdemmanager"). Use SQL_ASCII encoding (haven't tested WIN1252) with the template0

thanks


oops
found it
i had a hard night

inveki
07-26-2009, 09:54 AM
@ netsrak + madlion

3. Via right mouse click create a new empty database (for example "Holdemmanager"). Use SQL_ASCII encoding (haven't tested WIN1252) with the template0

on this do i only select the items listed above

4. Via right mouse click on this new database choose Restore, select "only schema" and choose the backup file from the link above.

when i try to complete this the ok button remains greyed out

thanks

netsrak
07-26-2009, 10:03 AM
Screenshot?

When the button is grey it means there is something missing (normally the file is not selected or sth. like that

cds0699
07-26-2009, 10:36 AM
I tried to fire up HEM today, and it didn't work, it prompted me to reconnect PostgreSQL.... I went to do that and I got the following error. Any ideas what to do? (I am using beta 20 btw)

http://i161.photobucket.com/albums/t212/cds0699/Problem-1.jpg

netsrak
07-26-2009, 12:20 PM
Please check whether your Postgresql service is running
http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=34
http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=171
and try to connect via pgadmin first

inveki
07-26-2009, 05:32 PM
screenshot?

When the button is grey it means there is something missing (normally the file is not selected or sth. Like that


1763

i am running on vista

have uac off

also holdem.exe is running as administrator

cds0699
07-26-2009, 06:29 PM
Got it fixed, ty

madlion
07-26-2009, 07:43 PM
@ netsrak + madlion

3. Via right mouse click create a new empty database (for example "Holdemmanager"). Use SQL_ASCII encoding (haven't tested WIN1252) with the template0

on this do i only select the items listed above

4. Via right mouse click on this new database choose Restore, select "only schema" and choose the backup file from the link above.

when i try to complete this the ok button remains greyed out

thanks

3. yes only what is stated leave the rest alone

4. you will need to download the file then browse to its location on your computer it looks like you have linked to the web address directly.

inveki
07-27-2009, 04:08 AM
got it

thanks

hen
07-27-2009, 06:25 PM
http://i205.photobucket.com/albums/bb23/heners_galore/untitled-5.jpg

I updated to PostgreSQL 8.4 from 8.2 but now get the above error messages when starting HEM. I installed 8.4 then uninstalled 8.2 and HEM no longer works. I also vacuumed/reindexed my databases, all in an attempt to speed it up.

Any ideas, I am running latest HEM fwiw.

madlion
07-27-2009, 07:02 PM
Try:

Start Menu>All Programs>PostgreSQL8.4>Reload Configuration

Then:

Start Menu>All Programs>PostgreSQL8.4>Restart Server

Ballerinty
07-27-2009, 08:42 PM
I'm trying to do a manual vacuum as requested by HEM, but I can't remember my password for postgres and the default passwords don't work. Any time I enter a password a popup shows this:

"Error connecting to server. FATAL: role "holdemmanager" does not exist"

Also, I changed the pg_hba.config file to say "trust", but it still asks me for a password. Any other ideas? I just imported a ton of hands so I really need to do the vacuum.

Thanks!

fozzy71
07-27-2009, 08:56 PM
........

"Error connecting to server. FATAL: role "holdemmanager" does not exist"

The username is typically postgresuser not holdemmanager



Also, I changed the pg_hba.config file to say "trust", but it still asks me for a password. Any other ideas? I just imported a ton of hands so I really need to do the vacuum.

Thanks!

It will still ask for the password, but any password should work, if you edited the file properly.



PT3's default name/password is - postgres/dbpass

If that password isn't right, you can try using svcpass, or postgrespass.


If neither of those work, you can remove the need for a password by editing the pg_hba.conf file.

Start > Programs > PostgreSQL 8.3 > Configuration Files > Edit pg_hba.conf

The file should open with Notepad

Scroll to the bottom where you will see this code




# TYPE DATABASE USER CIDR-ADDRESS METHOD

# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
#host all all ::1/128 md5
You need to change the first 'md5' to 'trust', like this




# TYPE DATABASE USER CIDR-ADDRESS METHOD

# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
#host all all ::1/128 md5

Save, and close the file.

Click: Start > Programs > PostgreSQL 8.3 > Reload configuration


Make sure you

Ballerinty
07-27-2009, 09:06 PM
I tried all this. No avail.

I changed the pg_hba.conf, and it actually had "trust" on both lines. So i changed the second one to md5. Still nothing works.

# TYPE DATABASE USER CIDR-ADDRESS METHOD

# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
#host all all ::1/128 md5




Is there a way to reset the password or find it somewhere?

BTW I used username holdemmanager when I installed postgresql.

fozzy71
07-27-2009, 11:13 PM
The trust code should do it. There is no way to reset it, only to bypass it. The only other thing I could suggest was to uninstall it fully and reinstall it as described above.

hen
07-28-2009, 04:25 AM
Try:

Start Menu>All Programs>PostgreSQL8.4>Reload Configuration

Then:

Start Menu>All Programs>PostgreSQL8.4>Restart Server

Reloaded fine, then wouldn't restart:

http://i205.photobucket.com/albums/bb23/heners_galore/untitled-6.jpg

then

http://i205.photobucket.com/albums/bb23/heners_galore/untitled-7.jpg

When I go pgAdminIII and double click on PostgreSQL 8.4 and enter what was my password for 8.2 I get this:

http://i205.photobucket.com/albums/bb23/heners_galore/untitled-8.jpg

netsrak
07-28-2009, 05:09 AM
Please configure your firewall with exceptions for postgresql and holdemmanager or disable it for a test.

hen
07-28-2009, 12:10 PM
Please configure your firewall with exceptions for postgresql and holdemmanager or disable it for a test.

I disabled it and got the same errors.

I'm going to go for an uninstall then reinstall of 8.4 and hope it works, if not, I'll try 8.3 I suppose?

Edit: Can't seem to download the Windows 8.3 from their website :s

Any other ideas? I think it's something to do with the password, because after I click to try again, I have to change the password from postgrespass to mine, but even then it doesn't work and I get the same error messages...

Patvs
07-28-2009, 01:51 PM
How I managed to flawlessly install 8.4.1

It seems 8.4.1 has several installation problems.

-Some users can't get past the "insert password" since it doesn't accept your normal (dbpass/postgrespass) password.
-When you do manage to install it, the default postgres database has the wrong encoding
-there are some recent posts by the admins how to create a new database with the proper encoding, but I was never able to delete the postgres database! causing all sorts of problems.

The easiest 8.4.1 installation is:
step1: Install 8.4 beta2 (during the beta2 installation pick ENCODING SERVER/CLIENT: SQL_ASCII!!)
(also account name = postgres, account password: postgrespass) (if it doesn't accept the password, follow these (http://www.holdemmanager.net/forum/showthread.php?t=12925&page=11) instructions)
step2: Uninstall beta2.
step3: Install 8.4.1 in the same directory as beta2.

step 4: either create a new HoldemManager database in pgAdmin and RESTORE your old database //or// simply start HoldemManager and let HEM create a new database for you.

---


The problem is 8.4 beta2 is very difficult to find now. It has been deleted for download from all PostgreSQL mirrors. But it still is on the Malaysian server (http://wwwmaster.postgresql.org/redir/379/f/binary/v8.4beta2/win32/postgresql-8.4-beta2.zip):

http://wwwmaster.postgresql.org/redir/379/f/binary/v8.4beta2/win32/postgresql-8.4-beta2.zip

---

Also be carefull with the Tuning Wizard. On some systems it will make changes to the postgresql.conf it shouldn't, resulting in being unable to connect to the database.
If you experience this problem--> go to the 8.4/data folder, and delete postgresql.conf, and rename the backup postgresql.conf.2009(data xxxxxxxx) to "postgresql.conf" and reboot.

netsrak
07-28-2009, 02:24 PM
Edit: Can't seem to download the Windows 8.3 from their website :s


I think you mean Postgresql 8.3? Its on our homepage: http://www.holdemmanager.com/downloads/postgresql.zip

hen
07-28-2009, 02:41 PM
I just meant the Windows version.

The link won't work for me; I get this:

http://i205.photobucket.com/albums/bb23/heners_galore/asgda.jpg

netsrak
07-28-2009, 03:33 PM
But thats not a problem of the link its a problem of your computer.
Clear browser cache, use a different browser.
Make sure that your harddisk has enough free space available

hen
07-28-2009, 04:33 PM
Thank you, sorry my bad.

Downloaded 8.3, uninstalled 8.4 and got 8.3 going fine. Now HEM is working, but alas there are no databases to chose when I start up...

Any idea where my old databases would be or are they gone for ever?

netsrak
07-28-2009, 05:17 PM
After the uninstallation and the other procedures you made i'm pretty sure they are gone.

Before such operations you should make a backup and / or archive your handhistories. I recommend this procedure once in a month.

excelvba
07-31-2009, 01:53 PM
Can you use postgreSQL 8.3 with the latest version of holdem mgr.
Also I have holdem mgr version 1.06.03h How do I upgrade to version 1.08.04 and is there any additional cost to upgrade?

fozzy71
07-31-2009, 02:17 PM
Wow, that is an ancient version. You should really try and stay more current.

You can update straight to the current version, 1.09 beta 21 from the link in my signature.

There have been changes to the software protection, and you are going to have to email sales@holdemmanager.net to have your license reset once you upgrade.

platy
08-01-2009, 11:50 AM
http://dimitrik.free.fr/db_STRESS_PostgreSQL_837_and_84_May2009.html

very interesting comparisons.

gregp21
08-05-2009, 04:24 PM
Hello, i have a problem to install postgres
this message appears :
user "postgres" could not be created , the user account already exist

fozzy71
08-05-2009, 07:08 PM
Hello, i have a problem to install postgres
this message appears :
user "postgres" could not be created , the user account already exist

Important steps are bolded.

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.

vlsup
08-06-2009, 06:17 PM
It's hard to read all 12 pages...
finally - сan I install this 8.4 and what wersion exactly to use with HEM?
do you recommend this - or better to remain with 8.3?

fozzy71
08-06-2009, 06:31 PM
I recommend you stick with 8.3.7 - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=176

reallygambling
08-08-2009, 07:17 AM
I have just bought holdem manager and downloaded the latest version of PostgreSQL as I couldn't get the previous versions to work for me. Now I can pass through the 'connect to PostgreSQL' phase but when I try to create a new database I get the error:22023:new encoding (SQL_ASCII) in incompatible with the encoding of the template database (UTF8).
help please!?

netsrak
08-08-2009, 08:03 AM
You find all the answers in this thread. Please see my earlier posts

ImSoCute
08-09-2009, 04:17 AM
I can't make a new database in v.8.4

http://img145.imageshack.us/img145/9591/hemdb.png

PROBLEM SOLVED WITH THIS SOLUTION:


I created an empty Holdemmanager database which you can use for the Postgresql 8.4 installation: http://www.holdemmanager.com/downloads/hm8.4.backup

Installation:

1. Install postgresql 8.4 (download from www.postgresql.org). The installation is much smarter than 8.3. Some computers which fail with 8.3 work with 8.4. So its worth a try.

2. After successful completion of the installation start pgadminIII and connect to the database server

3. Via right mouse click create a new empty database (for example "Holdemmanager"). Use SQL_ASCII encoding (haven't tested WIN1252) with the template0

4. Via right mouse click on this new database choose Restore, select "only schema" and choose the backup file from the link above.

5. After completion of this restore process you can start Holdemmanager and connect to this database.

C34FwT
08-12-2009, 05:49 AM
@ Holdemmanager Change to UTF-8 already, or why not

netsrak
08-12-2009, 07:15 AM
Sorry but i don't understand your question

ImSoCute
08-12-2009, 07:25 AM
i guess he wants you to change to UTF-8 coding HEM db

netsrak
08-12-2009, 08:59 AM
This will be in the next Beta

mfm000
08-12-2009, 11:25 AM
This will be in the next Beta

If we're going to be dumping the entire database and reimporting again: Please allow the hand history to be exported to a user defined location rather than be hardcoded to the HEM program installation directory.

netsrak
08-12-2009, 01:07 PM
You can suggest it here: http://holdemmanager.uservoice.com/pages/5307-holdem-manger-suggestions

C34FwT
08-13-2009, 06:27 AM
This will be in the next Beta

now that was quick :)

mfm000
08-13-2009, 04:10 PM
You can suggest it here: http://holdemmanager.uservoice.com/pages/5307-holdem-manger-suggestions

Already done that. That blog is like talking to a wall.

fozzy71
08-13-2009, 05:26 PM
That is there for when the developers need ideas for what features to add next. You will not get a response there from an HM employee. It is basically like a giant wish-list of things people want HM to be able to do.

4entourage
08-14-2009, 05:42 PM
This is the worst pile of shit ever here on the HM forums.

Somebody please make a decent post on how to configure 8.4 without getting error after error.

To all of you who want to install 8.4: DONT DO IT. It just screws up everything.

Wait until someone comes up with a 100% verified solution.


Agreed

Bacco777
08-14-2009, 07:01 PM
Agreed

The latest beta added support for the 8.4. Just create a new database with HM though. Also make sure the port is 5433 instead of 5432 AND stop the 8.3 server and start the 8.4 service before attempting to start HM. No need to uninstall 8.3, you can have both versions installed at the same time.

You'll see what I mean.

GL

Patvs
08-14-2009, 07:35 PM
deleted by poster

netsrak
08-15-2009, 05:15 AM
The latest Beta 1.09.24 supports UTF-8 so there should be no more need for installation tricks with Postgresql 8.4 :)

annabel6
08-15-2009, 07:50 AM
I'm having trouble installing Postgres......on Vista. After I choose language in the installation proccess I get this error message:

"CAn't open the installation package. Make sure det package excist and that you have access to it or contact your programprovider to confirm that it's a valid Windows install package.


Can someone please help me.

netsrak
08-15-2009, 07:59 AM
The zip file you downloaded for the installation needs to be completely extracted to a temporary folder. After that you start the installation from this folder.

http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=108

DrawMaster
08-17-2009, 02:14 PM
Installation:

1. Install postgresql 8.4 (download from www.postgresql.org). The installation is much smarter than 8.3. Some computers which fail with 8.3 work with 8.4. So its worth a try.

2. After successful completion of the installation start pgadminIII and connect to the database server

3. Via right mouse click create a new empty database (for example "Holdemmanager"). Use SQL_ASCII encoding (haven't tested WIN1252) with the template0

4. Via right mouse click on this new database choose Restore, select "only schema" and choose the backup file from the link above.

5. After completion of this restore process you can start Holdemmanager and connect to this database.

Nice,

Did that, and yes it worked until reboot. After restarting windows i get those same error messages again.

:mad::mad:

netsrak
08-17-2009, 02:33 PM
Please update to the latest Beta 1.09.24 it should support UTF8 databases and make sure you have the right database configured as default.

$$$
08-17-2009, 03:18 PM
OK sorry if this has been asked but its long thread and most of its over my head, maybe someone can just quote a reply. My problem is that to get hold em manger started i have to go to start, click run, services.msc, then find PostgeSQLdatabase8.3,right click, stop, then right click again and click run. I tryd to download 8.4 but was stop when it asked for a password. Is there anyway to get holdem manger to run without having to do this every time. Again sorry if this is an old problem.
Thank you for any help

netsrak
08-18-2009, 03:19 AM
This is not the normal behaviour. Is the Postgresql service start type set to automatic?

I think its a firewall/security software issue. You have to configure exceptions for postgresql.

If you want to install postgresql 8.4 you need to uninstall 8.3 before doing so. Dont forget to backup your data.
For installing both version you need to enter a different port (5433 for example) and you have to use the original postgres - user and password you entered during the installation of 8.3 (you'll find it in the holdemmanager.config file in the config folder of the holdemmanager installation).

$$$
08-18-2009, 04:54 AM
OK,first i tried to down load 8.4 b4 i got rid of 8.3. I erased them both and reloaded 8.4. Still have the same problem, i was also unable to find anything under Postresql service start or a start type. Do i need to reload holdem manger? The error says "holdem manager needs to know where to find the database.

netsrak
08-18-2009, 05:52 AM
As long as postgresql is not running there is no need to do anything with holdemmanager.

You should find the start type in the windows services for postgresql.

If your postgresql service is running can you connect via pgadmin?

http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=171

$$$
08-18-2009, 04:54 PM
Would it be possible to schedule a time when you'd be available to answer questions either on the forum, AIM, or skype in "real time" with the guy that works on my computer.

netsrak
08-18-2009, 05:11 PM
Sorry but i'm busy til tomorrow evening. If that is ok you can contact me via netsrak@holdemmanager.net to schedule a skype or teamviewer session or you mail fabio@holdemmanager.net with a link to this thread to arrange the same.

$$$
08-18-2009, 06:42 PM
if you could let me know what time 2morrow evening and some other times this week you'd be available just in case and i'll ask my computer guy when he can do it, that'd be great.

$$$
08-18-2009, 09:07 PM
PS. im on central american time, just let me know what works for you, Thanks alot

netsrak
08-19-2009, 01:08 PM
I have central european summer time here so i think you are 7 hours behind me (i hope this is correct, i'm not used to this different time zones). Normally you can get me between 6 and 11 pm my time. You can also email me netsrak@holdemmanager.net and we can share skype accounts to get a better connection.

PJFA1000
08-19-2009, 02:27 PM
This is not the normal behaviour. Is the Postgresql service start type set to automatic?

I think its a firewall/security software issue. You have to configure exceptions for postgresql.

If you want to install postgresql 8.4 you need to uninstall 8.3 before doing so. Dont forget to backup your data.
For installing both version you need to enter a different port (5433 for example) and you have to use the original postgres - user and password you entered during the installation of 8.3 (you'll find it in the holdemmanager.config file in the config folder of the holdemmanager installation).

I was to fast and installed 8.4 before backup/uninstalled 8.3. Is it safe to just uninstall 8.4 now and just start again from the beginning?

netsrak
08-19-2009, 03:43 PM
If your 8.4 is up and running there is no need to uninstall it. Beta 1.09.24 supports UTF8 databases for postgresql 8.4

PJFA1000
08-19-2009, 04:49 PM
If your 8.4 is up and running there is no need to uninstall it. Beta 1.09.24 supports UTF8 databases for postgresql 8.4

Yes but how can I get the datebase from 8.3 to 8.4? 8.3 and 8.4 have different ports now. So my holdemmanager still runs throu 8.3.

Have no iaé what I should do?

Please help me.

fozzy71
08-19-2009, 08:14 PM
Export your hands from the 8.3 DB and import them to the 8.4 DB, would be the simplest probably.

http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=146

http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173

dipstikdave
08-19-2009, 10:40 PM
for wrong password : before installation you must write "net user postgres /delete" in windows command.



this does not work for me. cannot get past password portion of setup. can anyone help?

netsrak
08-20-2009, 12:06 PM
Try a different user, for example postgresuser and if it doesn't work please post a screenshot of the error message.

dipstikdave
08-20-2009, 10:26 PM
http://img89.imageshack.us/img89/5015/screenshotk.jpg (http://img89.imageshack.us/i/screenshotk.jpg/)

netsrak
08-21-2009, 11:21 AM
net user postgres (SPACE) /delete

$$$
08-21-2009, 12:10 PM
Ready when you are

dipstikdave
08-21-2009, 06:33 PM
thanks net, i knew it was something simple.

Sharukh10
08-21-2009, 07:07 PM
I uninstalled PostgreSQL 8.3 and installed PostgreSQL 8.4, when i open holdem manager it says Holdemmanger database cannot be found, have i lost my database or is there a way to recover it.

Thanks

fozzy71
08-21-2009, 08:47 PM
Why did you uninstall 8.3? You can have them both installed along side each other.

Your 8.3 DB is probably right where it was before you uninstalled. \postgresql\8.3\data. I don't thin you can use that with 8.4. You would want to export the hands from your DB, when it is running on the 8.3 server. Then you shut down 8.3, turn on 8.4 (port 5433 instead of 5432) and import the hands to the new 8.4 db.

PunkAss
08-22-2009, 12:40 AM
I created an empty Holdemmanager database which you can use for the Postgresql 8.4 installation: http://www.holdemmanager.com/downloads/hm8.4.backup

Installation:

1. Install postgresql 8.4 (download from www.postgresql.org). The installation is much smarter than 8.3. Some computers which fail with 8.3 work with 8.4. So its worth a try.

2. After successful completion of the installation start pgadminIII and connect to the database server

3. Via right mouse click create a new empty database (for example "Holdemmanager"). Use SQL_ASCII encoding (haven't tested WIN1252) with the template0

4. Via right mouse click on this new database choose Restore, select "only schema" and choose the backup file from the link above.

5. After completion of this restore process you can start Holdemmanager and connect to this database.

Worked perfectly.

Ergospace
08-23-2009, 04:28 PM
Does it worth installing PostgreSQL 8.4? (I mean on clear machine with new DB)
Or there is no any important improvements and 8.3.7 more stable?

netsrak
08-24-2009, 04:45 AM
If you have a running 8.3 you should not touch it.

bumbi0
08-25-2009, 06:48 AM
I reimported my all hands in new postgres 8.4.0-1 UTF-8 database, but I steel can't writing accentuated letters/characters in the note. HM version is 1.09 b28 and the OS is Windows 7 x64.
How can be this?

bumbi0
08-29-2009, 01:49 PM
How can I change the postgres passworld?

netsrak
08-29-2009, 03:30 PM
pgadmin->connect to your database server->roles->postgres->properties.

For your notes question: the editing feature is not changed yet. I hope this will come in one of the next releases.

bumbi0
08-29-2009, 04:51 PM
Thanks, but int the Postgres 8.4 can change your password in File -> Change Password :).

tommyrobin
08-31-2009, 10:02 AM
I am working on getting postgres to work for 3 days now.

I was running 8.3 fine until it gave me the can't connect message.
I tried everything in the posts about this and the FAQ steps....no help.

I have now uninstalled postgres 8.3 and tried to install 8.4 and 8.4 beta
I don't get past the pasword thing ( postgrespass )

I i am now trying to install 8.3 again and get the same password error (invalid usrename )

I am close to quitting HEM and POSTgres and poker huds..

Useraccount is off. firewall is off I only have norton running ( firewall off ).
The only thing I am not gonna do is clear and reinstall Norton for this.
Vista obv and I think all shit started after an update.


Suggestions? 4 days and counting before I kill myself

bumbi0
08-31-2009, 11:46 AM
Uninstall/restart, then reinstall/restart.
The 8.3 database don't compatible with 8.4.0-1 database.

fozzy71
08-31-2009, 01:59 PM
I wish you would have come to the forums sooner so we could have helped with this issue.


....

Useraccount is off. firewall is off I only have norton running ( firewall off ).
....

Add exceptions to the windows firewall, even if it is off. If you have a 3rd party firewall, uninstall it completely before installing HM/SQL - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=171

Uninstall norton completely, using the Norton Removal Tool from their site.

I personally would suggest you never reinstall it. There are better options, but you can worry about that after you get postgresql working again.


For uninstalling SQL please follow these steps:

1) Uninstall PostgreSQL from the Windows Control Panel.
2) manually delete the Program Files\Postgresql folders
3) run the command - start > run > cmd >

net user postgres /delete
4) reboot.
5) install PostgreSQL again, with your firewall uninstalled or turned off if windows firewall, using these directions and postgresql.zip version. - [url]http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=176


If that doesn't work, I will be glad to try and assist you personally.

Please email me at fozzy@holdemmanager.net, with a link to this thread, and your forum name, so we can schedule a Teamviewer session. Download and install the www.Teamviewer.com Quick Support version.

tommyrobin
09-01-2009, 08:52 AM
Ty for your Reply Fozzy,

ATM I am not mentally ready to go thru the whole process again.
I did the firewall things ( though I could not find all files ) and I had 2 guys doing a teamviewer session with me. I downloaded all updates uninstalled reinstalled. But first I followed all the FAQ's.
I am not a computer nerd but I understand the things as I go along, also English is not my native language making it very hard to follow guidelines with 7-8 steps off changing my computer.

I don't have the power anymore to do it again and also thinking about reinstalling Norton makes me not wanna start my CPU. It may not be the best program but it kept my CPU clean for the last 5 years and that's very important to me.

HEM is a great program and I love it very much. The problems with postgres is probably not much your fault but I do think a good product does not need me to work for 4 days and reinstall my basic programs.

I hope within a few months their will be a patch for this and I can use it again. I also think if it happens now it can happen again and I am not up for that .

Best regards,

Tom

base
09-02-2009, 03:16 PM
I purchased your product and I use postgres 8.3, and trying to import bulk hh's..at the start i tried importing the folders which is the wrong way.. then tried to import smaller files which went to a speed of 80 to 300 /s.. this worked for little while then the speed never went above 30/s while importing.

I read about some tunning and vaccumizing/analyzing/reindexing.. all is done few times now..(I did this logging in through PgadminIII then chose holdemmanager db)
I also uninstalled my antivirus prog. configured exceptions in the windows firewall.. All of this never helped a bit.. deleted all logfiles in data folder too..

Now i need to try 1 last thing and then I am done for now with this madness..it is extremely annoying to invest days in this to make it work while the HM software is a quality product no doubts..I want to restore and dump as my last effort for now.. anyone knows how to do this in windows vista..only found linux manual for the dump/restore action..


Hope to read some reply soon..I don't know if it is possible to create a script for something like this. it would be a bliss for most users:)

Thx in advance

C34FwT
09-02-2009, 08:14 PM
I think those specific instructions are for linux not windows

base
09-03-2009, 03:34 AM
I think those specific instructions are for linux not windows

:eek:lol you are right..it is for linux.. edited my post..anyone have manual for windows? could not find any..

fozzy71
09-03-2009, 05:04 PM
:eek:lol you are right..it is for linux.. edited my post..anyone have manual for windows? could not find any..

I think this thread should have some links to the instructions you want.

http://www.holdemmanager.net/forum/showthread.php?t=11194

base
09-03-2009, 06:19 PM
I think this thread should have some links to the instructions you want.

http://www.holdemmanager.net/forum/showthread.php?t=11194

Great Fozzy thx alot.. will look into it..

BobiLiN
09-05-2009, 04:34 PM
Did anyone figure out the encoding error, how can I change it in the settings options?

fozzy71
09-05-2009, 05:36 PM
Did anyone figure out the encoding error, how can I change it in the settings options?

If you update to the latest HM version, and create a new UTF database, you should be fine.

Please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe.

Billion$Guy
09-07-2009, 08:57 AM
Hi!

Im sry but Im a noob. I have the problme w password on installing sql.

I had PT3 trial and deleted, also deleted postgreSQL.

Now I purchased HolemManager and cant start it. It wants the password for SQL but I dont know it. dbpass isnt working and postgrespass neither.

Please help

regards

Billy

Billion$Guy
09-07-2009, 09:29 AM
What a fuck! I pay $55 dont get a reg nr. cant even run the trial HEM, wont get help with that fucking SQL shit.

I allready see how much value this is!!

If possible send back my money!!!

If not get me my reg. key .

netsrak
09-07-2009, 10:00 AM
If you want a refund please contact sales@holdemmanager.net.

If you want help please stay calm and delete the postgres user before starting the postgresql installation:
1) Uninstall PostgreSQL from the Windows Control Panel.
2) manually delete the Program Files\Postgresql folders
3) run the command - start > run > cmd >

net user postgres /delete
4) reboot.

fozzy71
09-07-2009, 10:08 AM
If you have not received your license in 12 - 24 hours, please send your details to sales@holdemmanager.net CC roygon@gmail.com to be sure it goes through.

Why would you post a question about your license in this thread? A new thread would have been seen sooner. I also answered your posts on 2p2.

Billion$Guy
09-07-2009, 10:15 AM
already sent email to sales....

Its really ridiculous! holdemmanager to mention in one breath w pokertracker.
U know since over a full year that ppl that pay with moneybookers arent getting their reg. key....nothing changed.

And when I buy this program I dont wanna search forums and work shit!

Maybe ur good support but still suck


kind regards

tommyrobin
09-07-2009, 01:38 PM
already sent email to sales....

Its really ridiculous! holdemmanager to mention in one breath w pokertracker.
U know since over a full year that ppl that pay with moneybookers arent getting their reg. key....nothing changed.

And when I buy this program I dont wanna search forums and work shit!

Maybe ur good support but still suck


kind regards

Many doors will open for you in your life reacting this way I suppose.
I have some issues with the program atm also but not with these guys who do their upmost in answering every question, even if it is for the billionth time.

So don't be a douche, nothing good will come from that.

Tranclugator
09-07-2009, 03:26 PM
Many doors will open for you in your life reacting this way I suppose.
I have some issues with the program atm also but not with these guys who do their upmost in answering every question, even if it is for the billionth time.

So don't be a douche, nothing good will come from that.

+1 :D


So theese are my questions which are not offtop :p :
1) It seems to me that 8.4 server is a little bit (7-10%) slower than 8.3.7 on my machine with dual-core processor and 2 Gb RAM (Win7 x64) being "tuned". I mean huge HH-collection import operation (200k+ hands). On the other hand, 8.4 shows almost the same performance with much less aggressive RESOURCE USAGE-settings (shared_buffers 128MB and effective_cache_size = 64MB is even slightly faster than shared_buffers 256MB plus effective_cache_size = 256MB).
Can somebody approve this?

2) I have Russian Win7 and i don't have idea wich locale shoud I use when i install 8.4 - tried Rus, Eng/Eng , Default, Eng/USA - but in the terminal messages (when i go Progs->Pgsql->Start/Stop/Restart Server) i always see the same abracadabra encoding bullshit. Can I do smth with it :confused:

Rvg72
09-07-2009, 04:30 PM
already sent email to sales....

Its really ridiculous! holdemmanager to mention in one breath w pokertracker.
U know since over a full year that ppl that pay with moneybookers arent getting their reg. key....nothing changed.

And when I buy this program I dont wanna search forums and work shit!

Maybe ur good support but still suck


kind regards

Keys are sent out within a couple of hours during normal hours and normally never more than 8 hours. We are also working on an automated system but there have been some issues which have delayed the launch.

Also, don't be a jerk when you are posting. You purchased the best software for online poker and now have access to the best support. Your initial delay of a few hours in getting your code doesn't warrant this reaction.

Roy

fozzy71
09-07-2009, 05:47 PM
+1 :D


So theese are my questions which are not offtop :p :
1) It seems to me that 8.4 server is a little bit (7-10%) slower than 8.3.7 on my machine with dual-core processor and 2 Gb RAM (Win7 x64) being "tuned". I mean huge HH-collection import operation (200k+ hands). On the other hand, 8.4 shows almost the same performance with much less aggressive RESOURCE USAGE-settings (shared_buffers 128MB and effective_cache_size = 64MB is even slightly faster than shared_buffers 256MB plus effective_cache_size = 256MB).
Can somebody approve this?

I noticed this somewhat slower bulk importing speed the first time I used 8.4. This recent reinstall of 8.4 I got the speeds I used to get with 8.3. I haven't investigated the other performance differences/aspects of it, but I assume that type of stuff is documented on the various PSQL forums and reviews.




2) I have Russian Win7 and i don't have idea wich locale shoud I use when i install 8.4 - tried Rus, Eng/Eng , Default, Eng/USA - but in the terminal messages (when i go Progs->Pgsql->Start/Stop/Restart Server) i always see the same abracadabra encoding bullshit. Can I do smth with it :confused:

I have done a few foreign installations of the new 8.4, and haven't had problems yet. I always leave it to how it defaults. I have done some spanish, german, and french installs, but don't recall doing any with a russian customer. Can you be more specific about what you see? A screen shot perhaps? Hopefully netsrak has some suggestions for you.

Billion$Guy
09-07-2009, 06:17 PM
Keys are sent out within a couple of hours during normal hours and normally never more than 8 hours. We are also working on an automated system but there have been some issues which have delayed the launch.

Also, don't be a jerk when you are posting. You purchased the best software for online poker and now have access to the best support. Your initial delay of a few hours in getting your code doesn't warrant this reaction.

Roy

Ok guess ur right. Sry for overreaction. Was up 40h and excited to finally buy HM...then disappointed.


edit: its now 15 hours since I payed, no email yet

Billion$Guy
09-07-2009, 06:29 PM
I now got it to run.

fozzy, netsrak and all other supports Im sry for my missbehaviour.

Would like to stay w Holdem Manager.

Since I sent the email wanting my money back, could u stop that?
Or I email again?

how to proceed here?


Would also understand if u dont want me as a customer.

fozzy71
09-07-2009, 09:47 PM
You should resend the email to Roy to be sure he doesn't issue the refund. I will forward your reply here and this thread to him again as well. Between those 2 actions I would think all will be taken care of.

Tranclugator
09-08-2009, 04:47 AM
I have done some spanish, german, and french installs, but don't recall doing any with a russian customer. Can you be more specific about what you see? A screen shot perhaps? Hopefully netsrak has some suggestions for you.

Here it is
http://img401.imageshack.us/img401/1563/bullshit.png (http://img401.imageshack.us/i/bullshit.png/)

netsrak
09-08-2009, 04:54 AM
Sorry but for me its the same abracadabra bullshit like for you

Tranclugator
09-08-2009, 04:58 AM
yeah looks like that messages use the encoding that is not supported by Russian Windows :(
I thought maybe i can change smth in conf to fix it. Have no idea about it :(

netsrak
09-08-2009, 05:53 AM
Isn't there a russian postgresql version available? Check www.postgresql.org

Azalin
09-08-2009, 09:53 AM
I am thinking of installing postgres 8.4 in order to improve my database performance (my current db has more than 30 million hands in it).

Is this a good idea? I mean will I notice a significant performance improvement over the 8.3 version?

netsrak
09-08-2009, 11:12 AM
Nope, you will only have problems during the installation and no remarkable performance boost (only for vacuum and backup/restore).

I suggest you purge mined hands to make the database smaller. The stats will remain in the database.

http://208.109.95.123/forum/showthread.php?p=62613&posted=1#post62613

fozzy71
09-08-2009, 12:55 PM
I am thinking of installing postgres 8.4 in order to improve my database performance (my current db has more than 30 million hands in it).

Is this a good idea? I mean will I notice a significant performance improvement over the 8.3 version?

I would try and tune up your current DB, instead of trying to rebuild such a large DB.

I would suggest you do the majority of the things in this thread: http://www.holdemmanager.net/forum/showthread.php?t=11194

Some of the most important things, imo:

- Remove the WinnerName, WinnerCards and WinnerWon from the Hands View Column Selector
- Turning off logging and deleting existing logs
- Vacuum/Full/Analyze, then Reindex - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=163
- SQL Tuning Wizard - see below*
- Defrag last and make sure you stop the postgresql service before you defrag. I personally use Defraggler.
- Do a Cold Boot (Shut Down > Start) before you use HM again

*SQL Tuning:

1)Go to Start > Programs > PostgreSQL 8.3 and look for Application Stack Builder.

Steps 2 - 7 are obsolete and unnecessary.

8) At the end of the installation, launch the Application Stack Builder.
9) Select your PostgreSQL Database Server and click Next.
10) Expand AddOns and select EnterpriseDB Tuning Wizard.
11) Download the tuning wizard by selecting your country and continuing.
12) Continue through the end of installation and launch the EnterpriseDB Tuning Wizard.
13) Select your PostgreSQL Database server and click Next.
14) Under Server Utilization, select Mixed and click Next.
15) Continue through the installation of the tuning wizard.

PostgreSQL memory usage has now been configured specifically for your computer's specifications and performance should be improved.

Tranclugator
09-08-2009, 02:02 PM
PostgreSQL installation is multilingual, in some terminal windows i see normal russian text - so maybe it's internal PGSQL localisation bug

netsrak
09-08-2009, 02:15 PM
What this command does is stopping and starting the postgresql windows service.

You can try this via Administration -> Windows services or via the net stop / net start command on your own.
You need to find out why the service is not running or what is your basic problem?
It would be easier if you open a new thread with your problem description...

dennadanne
09-08-2009, 02:31 PM
i've been trying to install 8.3 forever now.. and my only problem is that when it has started to install I get an error message that
"user postgres could not be created. the user allready exists"
What can I do? I have never had it installed before and I do everything the manual says.

Please some help :confused:

Tranclugator
09-08-2009, 02:42 PM
What this command does is stopping and starting the postgresql windows service.

You can try this via Administration -> Windows services or via the net stop / net start command on your own.
You need to find out why the service is not running or what is your basic problem?
It would be easier if you open a new thread with your problem description...

I think i would better send a bugreport to postgresql.org ;) 'cause now i think that this is an internal bug in 8.4 localisation

aenetomic
09-11-2009, 01:56 AM
the postgre/HM connection is annoying.

I dl'd the HM update recently, and of course now the database is not connecting. tried to update posgre and the strange password prompt is still telling me that i have the wrong password even though i've tried uninstalling postgreSQL completely. I still have not been able to fix this problem... but have little doubt that others will follow.

it really seems to work great as long as NOTHING goes wrong. the moment something starts to go wrong the whole damn toilet has to come out because $*&# is hitting the fan.

I like holdem manager a lot (when its working), and its certainly possible that the instability of the program is a user related problem... but then you guys should design your product so that these user related problems are avoided. Poor design is most often the cause of user error.

I'm sure I'll figure out why its messed up and get it working over the next couple of days... but between now and then I'll consider switching to poker tracker and "between now and then" is probably a common occurrence for your users. I've had it happen 4 or more times now after owning HM for just a few months. It isn't as though we're all stupid or something... but it certainly seems that way sometimes.

My suggestion is that you guys should be striving to make this program more reliable. These monthly hangups which lead to multiple hours of trouble shooting are ridiculous.

netsrak
09-11-2009, 02:47 AM
Your latest problem was caused by a Windows Update. A simple reboot would have fixed it.

PT3 uses the same Postgresql thing as HM does...

aenetomic
09-11-2009, 04:15 AM
I rebooted this morning before trying anything else. It didn't fix it. I installed the latest HM updates and rebooted. It didn't work. Then, i tried to upgrade to the latest version of postresql (something i wouldn't mind doing anyways).

My latest problem is that I can't reinstall postgresql because its prompting me for a password for the superuser even though i've uninstalled postgresql (i've tried both standard passwords).

Your suggestion, which doesn't even seem to be for my problem, it didn't work. I gave you the benefit of the doubt since, why would you just assume that I hadn't tried the simple solution? Its still an interesting question.

fozzy71
09-11-2009, 10:44 AM
......
My latest problem is that I can't reinstall postgresql because its prompting me for a password for the superuser even though i've uninstalled postgresql (i've tried both standard passwords).

....

The vista update connection issue seems to be cured for most people by a:


Start > Programs > PostgreSQL > 8.x > Stop Service

Start > Programs > PostgreSQL > 8.x > Start Service



For your sql reinstall issue:


Please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe.

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

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

1) Uninstall PostgreSQL from the Windows Control Panel.
2) manually delete the Program Files\Postgresql folders
3) run the command - start > run > cmd >

net user postgres /delete
4) reboot.
5) Install PostgreSQL again, with your firewall uninstalled or turned off if windows firewall, using postgresql 8.4.0-1 - http://www.enterprisedb.com/products/pgdownload.do#windows


If that user name says it does not exist or cant be deleted, the simple solution is to create any new, unique username when installing such as postgresqlhm, or similar.

You can also try this:

http://forumserver.twoplustwo.com/showpost.php?p=12511512&postcount=14138

aenetomic
09-11-2009, 06:13 PM
thank you very much. the run cmd suggestion fixed my password problem. postgresql is installing now.

Patvs
09-12-2009, 07:33 PM
A new PostgreSQL 8.4.1-1 (http://www.enterprisedb.com/products/pgdownload.do#windows) has been released (previous version was 8.4.0-1)
There also is a 8.3.8-1 (http://www.enterprisedb.com/products/pgdownload.do#windows) update for 8.3 users.


Fixed/Updated in both releases:

"This release fixes one moderate-risk and two low-risk security issues: an authentication issue, a denial of service issue, and a privilege-escalation exploit. All users should upgrade their database installations as soon as reasonably possible.

This update release also fixes the "could not reattach shared memory" issue which has plagued many Windows PostgreSQL users, and updates time zone files for several countries. There are 23 other minor fixes, many of them affecting only version 8.4."

phishman420
09-14-2009, 12:48 AM
http://i27.tinypic.com/21lq42x.png

what should i do? just reformatted with win7 and installed the new version of posgresql

Patvs
09-14-2009, 01:31 AM
Did you also update HEM to 1.09 beta 30b?
The wrong encoding issue should have been resolved since 1.09 beta 24.

fozzy71
09-14-2009, 09:06 PM
Did you also update HEM to 1.09 beta 30b?
The wrong encoding issue should have been resolved since 1.09 beta 24.

Please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe.


So your new DB screen looks like the one in this faq:

http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=146

hochiminh
09-18-2009, 02:16 PM
http://i27.tinypic.com/21lq42x.png

what should i do? just reformatted with win7 and installed the new version of posgresql

I hve the lastes HEM update but i have the same problem when I'm trying to create ASCII database

fozzy71
09-18-2009, 02:28 PM
Create a new UTF database using HM 1.09 Beta 33

If this is a clean install of postgresql 8.3, and a clean DB, I would suggest you install sql 8.4 also.


Please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe.

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

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

1) Uninstall PostgreSQL from the Windows Control Panel.
2) manually delete or rename the Program Files\Postgresql folders
3) run the command - start > run > cmd >

net user postgres /delete
4) reboot.
5) Install PostgreSQL 8.4, with your firewall uninstalled or turned off if windows firewall - http://www.enterprisedb.com/products/pgdownload.do#windows


If you are restoring an old 8.3 database or \data folder, you need to make sure you are using 8.3 and not 8.4.

Tranclugator
09-19-2009, 05:15 AM
Returned to 8.3 'cause on my machine it runs about 10% faster than 8.4 :D
Looks like 8.4 was designed for more powerful computers but i only have core2duo with 2 Gib memory. Perhaps one needs at least 4 cores to get compearable performance. And 8-16 cores to make 8.4 overtake 8.3 :p

Misti Blue
09-19-2009, 08:48 AM
PostgreSQL 8.4 FINAL (http://www.postgresql.org/download/windows) is released after 3 months of the first 8.4 beta. 8.4 is supposed to be faster and has a HUGE list (http://www.postgresql.org/docs/8.4/static/release-8-4.html) of updates.


It seems 8.4.1 has several installation problems.



No kidding, I've been trying to work on that for 3 days now "it kept giving me error message that file was invalid or corrupt!

...thanks for the link above, I have installed it just now, within 5 mins.

hochiminh
09-19-2009, 09:04 AM
finally, i'm on 8.4 and it seems to me that the performance has increased a bunch.

Misti Blue
09-19-2009, 10:33 AM
Ok I'm stuck & need some help


In order to fully finish the installment of progre....it asks me to pick one application from Stack Builder 2.1.0. I don' t know which to choose...a HM support guy told me to skip it, but I can't.

It says I must choose one application to continue. These are the applications (if I don't need them can u just give me one to click on that isn't so big so it won't take up much of my harddrive space?) ty.

These are the choices:

add on, tools & utilities
database drivers
registration required add ons
replication solutions
spatial extentsions
web applications
web development

pls help I can't download hm unless this is completed first. ty





EDIT: couldn't wait anymore...so I chose registration required addons: EnterpriseDB Tuning Wizard for PostgreSQL v1.3-2

Taking me to long to download this HE with all the problems it has in installing it, I hope I won't have this many problems while using that software. Geez.



GUESS ALL SUPPORT STAFF IS OFF ON THE WEEKEND HUH?

netsrak
09-19-2009, 11:54 AM
Not really, i just answered this question some hours ago in another thread....

You could skip this step normally

Misti Blue
09-19-2009, 01:42 PM
Not really, i just answered this question some hours ago in another thread....

You could skip this step normally

Too late, I already chose a category and installed it.


Also downloaded & installed HM but now I'm stuck on this :

http://i36.tinypic.com/2aha1zc.jpg

Misti Blue
09-19-2009, 01:43 PM
What do I do with that?

This is error message I receive when I click on Create New Database

http://i37.tinypic.com/vy5rbq.jpg

Misti Blue
09-19-2009, 05:19 PM
Am I ever gonna receive an answer here...today?

Misti Blue
09-19-2009, 05:32 PM
Create a new UTF database using HM 1.09 Beta 33

If this is a clean install of postgresql 8.3, and a clean DB, I would suggest you install sql 8.4 also.


Please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe.

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

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

1) Uninstall PostgreSQL from the Windows Control Panel.
2) manually delete or rename the Program Files\Postgresql folders
3) run the command - start > run > cmd >

net user postgres /delete
4) reboot.
5) Install PostgreSQL 8.4, with your firewall uninstalled or turned off if windows firewall - http://www.enterprisedb.com/products/pgdownload.do#windows


If you are restoring an old 8.3 database or \data folder, you need to make sure you are using 8.3 and not 8.4.


I know this answers my last question, but I DON'T KNOW MUCH ABOUT COMPUTERS AND I HAVE NO IDEA WHAT TO DO... :( That's like gibberish to me...

netsrak
09-20-2009, 05:19 AM
Please update to the latest Beta http://www.holdemmanager.com/downloads/HmBetaUpdate.exe and create an UTF database.

If you had read this thread you would know that older HM versions do not support Postgresql 8.4...

Delite
09-20-2009, 10:41 AM
Hi, I have reinstalled hm by the way u have been posting and also installed the beta update but still i get this message everytime i want to connect to postgresql. "A connection to postgresql could not be made. Would you like to have Holdem Manager attempt to start the service"
My UAC and firewall is turned off.
Rapid answer is very appreciated. Thanks in advance. =)

Delite
09-20-2009, 10:47 AM
Sorry, saw the great FAQ now. Will start there ofc!

fozzy71
09-20-2009, 12:46 PM
Hi, I have reinstalled hm by the way u have been posting and also installed the beta update but still i get this message everytime i want to connect to postgresql. "A connection to postgresql could not be made. Would you like to have Holdem Manager attempt to start the service"
My UAC and firewall is turned off.
Rapid answer is very appreciated. Thanks in advance. =)


This is typically a firewall issue blocking the communication of HM and PostgreSQL.

What firewall? 'Off' is not enough. You need to also set exceptions.

Add exceptions to the windows firewall, even if it is off. If you have a 3rd party firewall, do the equivalent or uninstall it temporarily - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=171


Please try following all of these FAQs, step by step:

1) http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=34
2) http://www.holdemmanager.net/forum/showthread.php?t=8261

If that doesn't help at all we may want to schedule a remote support session to assist you.

Nikademus
09-20-2009, 07:13 PM
i also had the Ascii error, but finaly i got 8.4 (final) running...

1 -> deinstalled 8.3
2 -> deleted the postgresql data-folder (made a backup before)
2 -> installed 8.4beta2 with SQL_ASCII encoding
3 -> created a new HM-Database
4 -> imported all HH into the new Database
5 -> deinstalled 8.4beta2
6 -> installed 8.4 (final-oneclick) using the data folder from the 8.4beta2 installation (the one with the new database)
7 -> start HM -> success -> at least for me ;)

you can try to skip the steps 3 to 4 and excecute them after step 6. should work too.

Is this the only way to upgrade to 8.4? There's no database migration from within postgres? This seems ridiculous.

fozzy71
09-20-2009, 07:24 PM
There is an app/utility called pg_migrator but I don't know the first thing about it or how to use it. I simply exported my SQL 8.3 DB to text files from the HM DB Control Panel and installed 8.4, then imported the text files.

Tranclugator
09-21-2009, 03:50 AM
Is this the only way to upgrade to 8.4? There's no database migration from within postgres? This seems ridiculous.

I think backup/restore procedure also possible. Backup in 8.3, upgrade to 8.4 and restore using 8.4. You can try this using PGAdmin application, which you will find in start->programs->postgresql 8.x.

fozzy71
09-21-2009, 10:22 AM
I think backup/restore procedure also possible. Backup in 8.3, upgrade to 8.4 and restore using 8.4. You can try this using PGAdmin application, which you will find in start->programs->postgresql 8.x.

I need to try this with one of my old 8.3 backup files.

netsrak
09-21-2009, 11:56 AM
The backup from 8.3 restore in 8.4 should work. But keep the handhistories as a 2nd chance.

chusoooo
09-28-2009, 12:41 PM
Hello, I installed postgres 8.4 and HM 1.09 beta 34 and restored my old database (until July this year) and everything works ok.

The problem is when I want to import hand histories from August / September. Right now I have the txt and HHF belonging to partypoker. But HM I do not mind the hands!

This is an example:

http://img525.imageshack.us/img525/6444/hmerrorimport.th.png (http://img525.imageshack.us/i/hmerrorimport.png/)

111721 Errors in 404 files. (September)

fozzy71
09-28-2009, 01:27 PM
Please try creating a new utf db and importing them. I have seen nothing but problems with the DBs after people backup in 8.3 and restore to 8.4. I suggest you restore 8.3 in 8.3, and export the hands, to be imported to 8.4.

chusoooo
09-28-2009, 03:31 PM
The problem is not with the backup since postgres 8.3. It is importing hands partypoker who are in txt format and HHF.
I did a session today and I are different amounts of hands on the Graphs, in reports and at HM import.

Graph:
http://img89.imageshack.us/img89/8411/diferenciademanoshm.th.jpg (http://img89.imageshack.us/i/diferenciademanoshm.jpg/)

fozzy71
09-28-2009, 06:37 PM
Please www.7zip.org the hands and email them to fabio@holdemmanager.net, with a link to this thread, and your forum name.

wolfi
10-03-2009, 12:11 PM
[QUOTE=montanatoni;63512]for sql__ASCII error you must install with this file http://ftp.ua.postgresql.org/pub/mirrors/postgresql.org/binary/v8.4beta2/win32/postgresql-8.4-beta2.zip

The link is down.
I need the 8.4 (with right encoding) because I experience errors connecting to the database with 8.2 and 8.3.

fozzy71
10-03-2009, 03:34 PM
http://www.enterprisedb.com/products/pgdownload.do#windows

Rikiardu
10-09-2009, 06:49 AM
Just installed PostgreSQL Version 8.4.0-1 on windows XP and got this error:

http://img43.imageshack.us/i/dberror.png/


how can i solve this problem :(

netsrak
10-09-2009, 10:35 AM
Please use the latest Beta and create an UTF database.

Rikiardu
10-09-2009, 03:55 PM
i didnt understood... can you please tell me step by step what i have to do?

Thank you for you help :)

Rikiardu
10-09-2009, 04:06 PM
i've already done it...

thank's a lot for your help :D

cchill07
10-13-2009, 10:11 PM
I have had HEM for months and never could get it to act just right so I just reinstalled Windows 7 and now when installing database I get error message "This installation package could not be opened. Verify that the package exists and that you can access it or contact the vendor to verify that this is a valid Windows installer pkg." I downloaded it straight from the link in support so I am flustered.

fozzy71
10-14-2009, 02:44 AM
You have to unzip a ZIP file before you can run the contents. It sounds like you are talking about our old postgresql 8.3 installer, not 8.4.

If you only double clicked the postgresql.zip download, you only opened it up in a preview window of sorts.

- Right-Click > Extract All to your postgresql.zip file.
- That should create a new folder with the contents, which should allow the setup to run properly.
- If you have any issues with the windows not having an Extract menu under Right-Click, try www.7zip.org.


I suggest this instead: http://www.enterprisedb.com/products/pgdownload.dowindows

Cartman121
10-16-2009, 02:45 AM
Downloaded and purchased the $80 version of Hold'em Manager. Installed this PostgreSQL 8.3 program and followed the FAQ to do it correctly, all went fine. When I go to open up Holdem Manager all i'm getting is this "Database Control Panel" popping up asking me for my Server Name, Port Number, Login Name and Password. I've left the Server Name and Port Number as is, but when I type in the same Login Name (postgreuser) and Password (postgrespass) that they said to use in the FAQ/Installation of PostgreSQL it comes up with this message

"The Username and/or password was incorrect. Would you like to have Holdem Manager configure the database to accept this login and password?" I click yes.
"Holdem Manager updated PostgreSQL. Please try connecting again." I try and connect again and all I get is the same message over and over...any ideas? I've never actually got to even see the Hold'em Manager program at all, just all this crap to do with PostgreSQL.

And now trying to download this 8.4 FINAL realse of PostgreSQL and can't get passed the password screen in the installation. Would really appreciate any help at all guys, cheers. :)

fozzy71
10-16-2009, 03:19 AM
Please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe

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

Turn off Windows Firewall 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 reinstalling SQL to a new/empty DB, please follow these steps:

1) Uninstall PostgreSQL from the Windows Control Panel.
2) manually delete or rename the Program Files\Postgresql folders
3) run the command - start > run > cmd >

net user postgres /delete
4) reboot.
5) Install PostgreSQL 8.4, with your firewall uninstalled or turned off if windows firewall - http://www.enterprisedb.com/products/pgdownload.do#windows

Cartman121
10-16-2009, 03:55 AM
Alright i've completed all of that cheers Fozzy. Still having trouble installing PostgreSQL 8.4 though, in the setup when it asks for the password i've tried both dbpass/postgrespass as the password yet I keep on getting the Warning:
The password specified was incorrect. Please enter the correct password for the postgres windows user account

Also noticed on startup that it had created another user called "postgres" is this normal?

netsrak
10-16-2009, 04:54 AM
Thats not normal, Fozzy posted how to delete this user before the installation (net user ...)

Cartman121
10-16-2009, 05:34 AM
Thats not normal, Fozzy posted how to delete this user before the installation (net user ...)

Thought I did that, did it again and its gone now. Working perfectly, cheers guys. :)

QiD
10-17-2009, 08:05 AM
I would like to delete my postgres account in order to make a new database. I already uninstalled postgreSQL, deleted the folders, but I don't know how to do this:

3) run the command - start > run > cmd >

Could you please give me spesific help what should I do? I use windows 7 and I'm totally lost with this one.

I tried to write "net user postgres /delete" in command prompt but it said "System error 5 has occured." and "Access is denied."

I also have user called "postgres".

Please help me, so I can install postgresql again andf get hem working.

netsrak
10-17-2009, 09:40 AM
The command prompt is the right thing to use but you need to start it as administrator.
http://www.blogsdna.com/2168/windows-7-how-to-open-elevated-command-prompt-with-administrator-privileges.htm

QiD
10-17-2009, 10:07 AM
I managed to delete old postgres user and get SQL 8.4 working.

All I need to know now is it normal or not to have postgres user on startup like the guy before? If it is not, how can I delete it and NOT mess my database again?

fozzy71
10-17-2009, 10:15 AM
I managed to delete old postgres user and get SQL 8.4 working.

All I need to know now is it normal or not to have postgres user on startup like the guy before? If it is not, how can I delete it and NOT mess my database again?

It is normal. It can be removed with a minor registry hack.

http://www.howtogeek.com/howto/windows-vista/remove-user-accounts-from-the-logon-screen-in-windows-vista/

SEGGREPACSI
10-17-2009, 08:05 PM
I have windows 7. Intalled HM , than the beta version. Intalled postgressql 8.3 initially and it would not work. Did not take me to the create database page. I than deleted it and reinstalled 8.4.01 and have a problem with sql encoding. I may need the 8.4beta2 with SQL_ASCII encoding and do not know where to find it. WHERE DO I FIND THAT? ITS NOT ON THE POSTGRES SITE.

Also took netsrak's advice and did a clean install once again of 8.4.01 and tried this.

I created an empty Holdemmanager database which you can use for the Postgresql 8.4 installation: http://www.holdemmanager.com/downloads/hm8.4.backup

Installation:

1. Install postgresql 8.4 (download from www.postgresql.org). The installation is much smarter than 8.3. Some computers which fail with 8.3 work with 8.4. So its worth a try.

2. After successful completion of the installation start pgadminIII and connect to the database server

3. Via right mouse click create a new empty database (for example "Holdemmanager"). Use SQL_ASCII encoding (haven't tested WIN1252) with the template0

4. Via right mouse click on this new database choose Restore, select "only schema" and choose the backup file from the link above.

5. After completion of this restore process you can start Holdemmanager and connect to this database.

Still no luck. It gives me the same error. I need a team veiwer session with anyone who knows what there doing:( Please help a desperate soul:)

fozzy71
10-18-2009, 12:53 AM
Please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe

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

Turn off Windows Firewall 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 reinstalling SQL to a new/empty DB, please follow these steps:

1) Uninstall PostgreSQL from the Windows Control Panel.
2) manually delete or rename the Program Files\Postgresql folders
3) run the command - start > run > cmd >

net user postgres /delete
4) reboot.
5) Install PostgreSQL 8.4, with your firewall uninstalled or turned off if windows firewall - http://www.enterprisedb.com/products/pgdownload.do#windows

When creating a new DB in the HEM DB Control Panel use the UTF option.