PostgreSQL 8.4 FINAL release (8.4.0-1)

[fozzy71]

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]

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]

When installing the beta version should I be using SQL ASCII for both client and server encoding?

[Alex]

When installing the beta version should I be using SQL ASCII for both client and server encoding?

yes

[fozzy71]

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]

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]

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]

Oh, OK. I was tempted to not delete the postgres user account, but I wasn't sure.

[fozzy71]

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]

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.