PDA

View Full Version : postgres restoring problem



Banimal
07-31-2010, 03:49 AM
hey there, i just had my computer reformatted and now i am trying to restore my Holdem manager database... However, for some reason my postgres password isnt working:

http://img293.imageshack.us/img293/4170/postgrespw.png (http://img293.imageshack.us/i/postgrespw.png/)

Uploaded with ImageShack.us (http://imageshack.us)

I went to the Postgres website but i couldn't understand this:

I lost the database password. What can I do to recover it?

You can't. However, you can reset it to something else. To do this, you

* edit pg_hba.conf to allow trust authorization temporarily
* Reload the config file (pg_ctl reload)
* Connect and issue ALTER ROLE / PASSWORD to set the new password
* edit pg_hba.conf again and restore the previous settings
* Reload the config file again

Could you elaborate on this? I cant find a this file to 'edit'....

_Loki_
07-31-2010, 05:01 AM
###

>> FAQ - Hold'em Manager Poker Tracking Software :: Password Issues (PostgreSQL) (http://faq.holdemmanager.com/questions/82/Password+Issues+%28PostgreSQL%29)

###

Banimal
07-31-2010, 10:39 AM
Thanks Loki! Heres my next problem :(




hey guys, it looks like i have a similar problem.

Here are some photos of the steps that i am taking, with no success:

http://img836.imageshack.us/img836/7672/restore1.png (http://img836.imageshack.us/i/restore1.png/)

Uploaded with ImageShack.us (http://imageshack.us)

So i choose the backupfile that i saved (note that i had to go into "All files" in order to see the file...)

http://img688.imageshack.us/img688/3913/restore2.png (http://img688.imageshack.us/i/restore2.png/)

Uploaded with ImageShack.us (http://imageshack.us)

It takes about 3-5 minutes before finishing and then i click cancel (to avoid duplicating files, as written in the FAQ)

http://img824.imageshack.us/img824/6872/restore3.png (http://img824.imageshack.us/i/restore3.png/)

Uploaded with ImageShack.us (http://imageshack.us)

Then i go into HoldemManager and i cant view any files under any screen names. I also clicked auto import (just to see if that helped) but it didnt.

p.s. I am trying to email my backup file to support@holdemmanager.com, just incase it is helpful, but the file seems too big? ... The email name is "Michael Bannar-Martin (Restoring Problems)" (if i can send it)

pp.s. i am running postgres 8.4 at the moment but i am not 100% sure what my previous hard drive was running on. I assume it is the same though because my laptop also runs on 8.4 (i could be wrong though)

please, let me know if you want me to do any other tests to get to the bottom of this.

_Loki_
07-31-2010, 01:35 PM
###
Hello Aussie Michael

Click on the 'Change' button (on the word 'Change' not the arrow to the right of the word)
A 'Select Player' dialog pops up
In the 'Enter Player Name' Field you type in a name...

& you are saying the 'Name, Site, Hands' pane below the 'Enter Player Name' Field remains blank ?

<o>http://1.2.3.9/bmi/faq.holdemmanager.com/images/player-alias-01.jpg</o>
###
From your middle picture you seem to have two DB's named 'Holdemmanag...! (can't see all the name)
Are they both the same name (I don't think that's possible ?? ) ?
What happens when you make the other 'Holdemmanag...' default ?

###
<o>The file is 250GB ~ there's no way you can email that
Upload the file to a file sharing site & email the link to support
(if you can find a free one that will take 250GB ??? )

###/
8.4 & all that ~ you read the FAQ about the need to have the same postgreSQL version in backup & restore
You did the backup & didn't note what version you backed up from ?
You no longer have access to that postgreSQL to see what version it was ?

###</o>

Banimal
07-31-2010, 09:46 PM
###
Hello Aussie Michael

Click on the 'Change' button (on the word 'Change' not the arrow to the right of the word)
A 'Select Player' dialog pops up
In the 'Enter Player Name' Field you type in a name...

& you are saying the 'Name, Site, Hands' pane below the 'Enter Player Name' Field remains blank ?

<o>http://1.2.3.9/bmi/faq.holdemmanager.com/images/player-alias-01.jpg</o>
###
From your middle picture you seem to have two DB's named 'Holdemmanag...! (can't see all the name)
Are they both the same name (I don't think that's possible ?? ) ?
What happens when you make the other 'Holdemmanag...' default ?

###
<o>The file is 250GB ~ there's no way you can email that
Upload the file to a file sharing site & email the link to support
(if you can find a free one that will take 250GB ??? )

###/
8.4 & all that ~ you read the FAQ about the need to have the same postgreSQL version in backup & restore
You did the backup & didn't note what version you backed up from ?
You no longer have access to that postgreSQL to see what version it was ?

###</o>


hey loki,
so i think i have some good news... I woke up this morning and turned my computer on and i was able to make my name appear in holdemmanager! The only problem is that somehow everything has doubled up (duplicated) and it shows that my profits look to be twice as much as they actually are. So could you please explain what to do now? Do i need to completely clear my holdemmanager and then repeat the originial steps (making sure to only restore files once). How do i do this?

_Loki_
07-31-2010, 10:53 PM
###
Sounds good, but - we are talking about a 250Gb DB...

Did you read here I noticed you have 2 x DB's with same/similar names ?
I think you've restored to a DB that wasn't empty or restored twice to the same DB...

I guess the backup is still available to you ?
Your DB's are adding up to a lot of space now - I'm concerned you might get into trouble with low/no disk space if you restore again
Which spells disaster...

I would...

** delete/drop the doubled up DB (make sure you pick the right one)
>>> FAQ - Hold'em Manager Poker Tracking Software :: Create / Delete Database (http://faq.holdemmanager.com/questions/75/Create+%7B47%7D+Delete+Database)
** vacuum/analyse full the remaining DB's
** reindex them
** defrag with all progs closed (that you can) & postgreSQL service stopped

** create a new DB with a distinctive name
>>> FAQ - Hold'em Manager Poker Tracking Software :: Create / Delete Database (http://faq.holdemmanager.com/questions/75/Create+%7B47%7D+Delete+Database)
(yeah I know - same FAQ)
** restore into the NEW EMPTY DB just the one time

After all that I think your NEW DB needs a vacuum/analyse full & reindex

###

Banimal
08-01-2010, 01:08 AM
ohh baby... its working!

thanks so much for your help. Im not sure why it worked this time (basically i just deleted all my databases and then repeated the restoring process) and it suddenly worked so i am very happy.

This is a little bit off topic, but if i wanted to delete all hands that happened before 2010 from my database would that be easy to do? This way i would only have 2010+ hands?

thanks guys

_Loki_
08-01-2010, 01:33 AM
###
Guys ? Exactly how many posters are in this thread besides you ? :)

###
Don't do any more 'funny stuff' until you have done...

vacuum/analyse full
reindex
defrag

And then give the DB a test to make sure all's well - play some poker
It's unwise to run while holding a DB (so to speak)

###
Back to you on your question in a mo, but it's time for you to tidy up your DB first. OK ?

###

The Minder
08-01-2010, 01:51 AM
###
Guys ? Exactly how many posters are in this thread besides you ? :)

###


I think it's appropriate that I jump in here and mention that I taught Loki everything he knows. So if there are any kudos being spread around I should get my cut. Agreed? :cool:

_Loki_
08-01-2010, 01:58 AM
###
I think that's 'fair dinkum'
(do Aussies REALLY say that ? They have a documentary series over here called Neighbours where this phrase is bandied about willy nilly)

###

_Loki_
08-01-2010, 02:32 AM
###
1] If you're not on 1.11.03 ~ Update to 1.11.03

1a] & Reboot

2] I'm assuming that you still have your backup safe somewhere - If you haven't make a backup. I can't stress this strongly enough.

3] Reduce wasted disk space further by deleting log files in the pg_log folder & preventing future log files from being created
This should give you many more GB of free HDD space if your backup was 250GB:
>> FAQ - Hold'em Manager Poker Tracking Software :: Large Log Files (http://faq.holdemmanager.com/questions/85/Large+Log+Files)
[only do this to the pg_log folder]

4] Make sure your DB/HM is still working (which it will not be if you messed with the wrong folder)

5] Purge all hands that you were not involved in [observed or datamined hands] right up to today by following the bottom half of this FAQ
>> FAQ - Hold'em Manager Poker Tracking Software :: Observed Hand History Configuration (http://faq.holdemmanager.com/questions/196/Observed+Hand+History+Configuration)
Put your SN in for "Do not delete hand histories played by:"
click the "All Poker Sites" button &
click the "All Dates" button
click "Purge Hand Histories"
IMPORTANT NOTE: If you have multiple SN's across multiple poker sites you have to be very careful with this feature]

6] Having finished 5] it would be wise to check that all the hands you've played still exist & also to do another vacuum/analyse full

7] Now purge all hands played by anyone before 01/01/2010
>> FAQ - Hold'em Manager Poker Tracking Software :: Purge Hands (http://faq.holdemmanager.com/questions/197/Purge+Hands)
Check all the 'stakes' boxes
leave the "Do not delete hands played by:" box empty & unchecked
click the "All Poker Sites" button &
click the button BELOW the "All Dates" button & put date ranges going back before the beginning of your DB in the left field & 31/12/2009 in the right field
click "Purge Hands"
NOTE: This will purge only your hands since you've already purged all observed hands in 5]

8] vacuum/analyse full & re-index

9] Make new backup

10] defrag your HDD after closing as many programs as possible & stopping the postgreSQL service

11] Reboot

###

Banimal
08-01-2010, 04:15 AM
###
Guys ? Exactly how many posters are in this thread besides you ? :)

###
Don't do any more 'funny stuff' until you have done...

vacuum/analyse full
reindex
defrag

And then give the DB a test to make sure all's well - play some poker
It's unwise to run while holding a DB (so to speak)

###
Back to you on your question in a mo, but it's time for you to tidy up your DB first. OK ?

###

Ok well i played some poker and it seems to be working perfectly. I dont know what vacuum/analyse full, reindex and defrag is... So i dont know how to do any of these things? :( and what they will accomplish?
You may have guessed that i am kind of a computer noob :P

_Loki_
08-01-2010, 10:41 AM
###
This stuff is important - very important ~ "Quick Tip: Vacuuming your database is like getting your car's engine serviced". Do the process in the order given below

~~~~
1] Vacuum/Analyse full:
>> FAQ - Hold'em Manager Poker Tracking Software :: Vacuum Analyze Database (http://faq.holdemmanager.com/questions/88/Vacuum+Analyze+Database+)
When you get to the picture in step 6. select the radio buttons exactly as in the picture

~~~~
2] Reindex:
Use the same FAQ as above, but in in step 6. you click on the 'reindex' button to the right in the picture

~~~~
3] Defragment:
This is a windows function. If you have Win7 the windows defragger is good enough. If you have XP or Vista the windows defragger is barely adequate & you should download/install a free defragger
This is a good one:
>> Smart Defrag - Free software downloads and software reviews - CNET Download.com (http://download.cnet.com/Smart-Defrag/3000-2094_4-10759533.html)
[Before Defragging ~ Close down as many running programs as possible
including antivirus if it will let you
Also stop the postgreSQL service (that's an option in the postgreSQL part of Start > Programs & it's simply called 'Stop Server')

~~~~
4] Reboot

###
Optional Extra:
Everyone rates this Free product very highly - it removes tons of temporary space-hogging files from your HDD. You should run it before defragging. Before using it open the program & click the 'online help' link in the bottom-left of the interface
>> CCleaner - Optimization and Cleaning - Free Download (http://www.piriform.com/ccleaner)

###

Banimal
08-03-2010, 08:16 AM
###
This stuff is important - very important ~ "Quick Tip: Vacuuming your database is like getting your car's engine serviced". Do the process in the order given below

~~~~
1] Vacuum/Analyse full:
>> FAQ - Hold'em Manager Poker Tracking Software :: Vacuum Analyze Database (http://faq.holdemmanager.com/questions/88/Vacuum+Analyze+Database+)
When you get to the picture in step 6. select the radio buttons exactly as in the picture

~~~~
2] Reindex:
Use the same FAQ as above, but in in step 6. you click on the 'reindex' button to the right in the picture

~~~~
3] Defragment:
This is a windows function. If you have Win7 the windows defragger is good enough. If you have XP or Vista the windows defragger is barely adequate & you should download/install a free defragger
This is a good one:
>> Smart Defrag - Free software downloads and software reviews - CNET Download.com (http://download.cnet.com/Smart-Defrag/3000-2094_4-10759533.html)
[Before Defragging ~ Close down as many running programs as possible
including antivirus if it will let you
Also stop the postgreSQL service (that's an option in the postgreSQL part of Start > Programs & it's simply called 'Stop Server')

~~~~
4] Reboot

###
Optional Extra:
Everyone rates this Free product very highly - it removes tons of temporary space-hogging files from your HDD. You should run it before defragging. Before using it open the program & click the 'online help' link in the bottom-left of the interface
>> CCleaner - Optimization and Cleaning - Free Download (http://www.piriform.com/ccleaner)

###

hey Loki, i did everything you told me to do... The only thing that seemed a little bit strange was when i tried to "Stop Server" (postgreSQL), it says:

"system error 5 has occurred.
Access is denied.
Press <return> to continue..."

Despite this message i still went ahead and defragged my windows 7. I hope that is ok....

My next problem with my Holdem Manager... Today i played two sessions of poker and for some reason i had a bunch of hands missing from my sessions?

The first session, my FTP client said that i played 1200ish hands and my HoldemManager said that i only played 1131 hands.

My second session, my FTP client said that i played 1600ish hands even though my HoldemManager said that i only played 1483 hands :(

So there are a bunch of HandHistorys that arn't being imported into my HoldemManager... any idea where they would be? I noticed this when i made a profit in one of my sessions, even though HoldemManager said that i lost money.... very frustrating! :(

thanks

netsrak
08-03-2010, 10:15 AM
The defrag didn't help you for your database because the postgresql service was still running and this means that the defrag couldn't access the postgres data files. You need to run the postgresql stop command as adminstrator (right mouse click).


For the missing hands:
Please try to reimport the handhistory files. You should find them in the hm archive folder (default c:\hmarchive). Please copy them to a different folder and import them again via import file or import folder.

Does this make a difference?
If not please create a new database for a test and import the hands into this database. Any difference?

Banimal
08-03-2010, 07:07 PM
The defrag didn't help you for your database because the postgresql service was still running and this means that the defrag couldn't access the postgres data files. You need to run the postgresql stop command as adminstrator (right mouse click).


For the missing hands:
Please try to reimport the handhistory files. You should find them in the hm archive folder (default c:\hmarchive). Please copy them to a different folder and import them again via import file or import folder.

Does this make a difference?
If not please create a new database for a test and import the hands into this database. Any difference?

Ok the defragment worked for postres this time! thanks

With what you said about the missing hands.... If i copy ALL of the hands from the last two days, wouldnt that duplicate even the ones that WERE successfully imported into my holdemmanager?

I dont really want to keep messing up my results (by doubling them up) anymore than they already are. Unless i can delete this "different folder" afterwards? It would be extremely difficult to just find the specific hands that went missing...

_Loki_
08-03-2010, 09:04 PM
....... If i copy ALL of the hands from the last two days, wouldnt that duplicate even the ones that WERE successfully imported into my holdemmanager?

I dont really want to keep messing up my results (by doubling them up) anymore than they already are. Unless i can delete this "different folder" afterwards? It would be extremely difficult to just find the specific hands that went missing...

Make a new folder on your desktop or somewhere easy to find
Into the new folder paste copies of all your HH for the time period when you have missing hands
Use 'Import from folder' button to find the new folder & import
HM will not import any hands that are duplicates
You can delete the new folder you made now

Banimal
08-03-2010, 10:06 PM
Make a new folder on your desktop or somewhere easy to find
Into the new folder paste copies of all your HH for the time period when you have missing hands
Use 'Import from folder' button to find the new folder & import
HM will not import any hands that are duplicates
You can delete the new folder you made now

Ok... i did exactly what you asked and when i chose "import from folder" it said that it was importing 32hands... (even though there are a lot more than 32 hands missing), either way... those 32 hands didnt change any of the results in the last couple of days i have played. So they are still missing. Hmmm...

I think it is strange that HoldemManager is successfully importing 90%+ of my hands and is only missing some of them.

what next? Thanks

_Loki_
08-04-2010, 12:03 AM
###
I'm clutching at straws here regarding these missing hands... So some ideas

Perhaps they are not missing. Maybe there is a filter applied that is hiding them from you ? As in the picture below clear the main filter by

clicking 'Filter' button followed by 'Clear'
& then 'Filter' button again followed by 'Use for all'
Try & select 'All Games'

Do they appear

http://1.2.3.13/bmi/faq.holdemmanager.com/images/clearfilter.jpg ###
How do you know they are missing ?

###
Could it be that you closed the poker client or left a table before the hand was completed ?

###

Banimal
08-04-2010, 02:06 AM
###
I'm clutching at straws here regarding these missing hands... So some ideas

Perhaps they are not missing. Maybe there is a filter applied that is hiding them from you ? As in the picture below clear the main filter by

clicking 'Filter' button followed by 'Clear'
& then 'Filter' button again followed by 'Use for all'
Try & select 'All Games'

Do they appear

http://1.2.3.13/bmi/faq.holdemmanager.com/images/clearfilter.jpg ###
How do you know they are missing ?

###
Could it be that you closed the poker client or left a table before the hand was completed ?

###

Hmm... I noticed it at first because my cashier showed that i had actually won money, even though my holdem manager said that i had lost money. Maybe i am just going crazy and i will see how it goes over the next couple of days... (keeping a close eye on the results in my cashier and in my Holdem Manager)

Could Running It Twice (RIT), have an affect on any of this?

thanks

_Loki_
08-04-2010, 02:45 AM
###
I don't know enough about RIT to advise

###
You can't assume 'missing hands' because of an a discrepancy between your cashier & HM until you've investigated the variables

eg..
Hands not imported
HM filters
HM misreading hands/pots/ante's because of a change in HH format
Multicurrency
You cleared a bonus at your site without realising it
etc
etc


For example: I play USD, but I keep some Euro & GBP for restricted tourneys where PS adds to the prize pool. So I got caught out recently playing Euro cash tables when I thought they were USD (I had turned off the filter in PS that hid the Euro tables). The small gap in my cashier & HM bugged me for days...


###
The way to figure this out (perhaps) is to see if you can get some info from your site for how your cashier balance stood at 2 or 3 points in time & then use HM to pin down where (if anywhere) the discrepancy lies

###

Banimal
08-04-2010, 03:14 AM
###
I don't know enough about RIT to advise

###
You can't assume 'missing hands' because of an a discrepancy between your cashier & HM until you've investigated the variables

eg..
Hands not imported
HM filters
HM misreading hands/pots/ante's because of a change in HH format
Multicurrency
You cleared a bonus at your site without realising it
etc
etc


For example: I play USD, but I keep some Euro & GBP for restricted tourneys where PS adds to the prize pool. So I got caught out recently playing Euro cash tables when I thought they were USD (I had turned off the filter in PS that hid the Euro tables). The small gap in my cashier & HM bugged me for days...


###
The way to figure this out (perhaps) is to see if you can get some info from your site for how your cashier balance stood at 2 or 3 points in time & then use HM to pin down where (if anywhere) the discrepancy lies

###

Ok... so i can confirm my suspicions that Holdem manager is definitely missing hands. I have made sure that the filters are all clear too, so that cant be the problem.

Here is a screenshot comparing my PTR results and my HM results. As you can see, every session recorded on PTR has significantly more hands than what is shown in my Holdem Manager:

http://img687.imageshack.us/img687/4844/hmmissinghands.jpg (http://img687.imageshack.us/i/hmmissinghands.jpg/)

Uploaded with ImageShack.us (http://imageshack.us)

I realise that PTR is not always accurate and can sometimes miss hands. However it has never been known to add extra hands.

Any ideas? thanks

netsrak
08-04-2010, 06:13 AM
Please try to reimport the files as i posted above, duplicate hands will be identified and not imported again.

Banimal
08-04-2010, 07:24 AM
Please try to reimport the files as i posted above, duplicate hands will be identified and not imported again.

Ok... so i reimported the files again in a separate folder but nothing happened.


Then i just made another Database (in pgAdmin 3) called 'HoldemManagertesting', and i went into HoldemManager>Options>Database Management and tried to change the default database to the new one and it wouldnt let me because "HoldemManager needs to be the default database".

What can i try now? I just played another session and HoldemManager didnt pick up another 93 hands... (see picture below)

http://img508.imageshack.us/img508/6641/missed93hands.jpg (http://img508.imageshack.us/i/missed93hands.jpg/)

Uploaded with ImageShack.us (http://imageshack.us)

Banimal
08-04-2010, 07:29 AM
Oh... and just a quick question. Is the little 'x' next to the postgres icon normal?

http://img14.imageshack.us/img14/6707/isthisnormalpgadmin.jpg (http://img14.imageshack.us/i/isthisnormalpgadmin.jpg/)

Uploaded with ImageShack.us (http://imageshack.us)

netsrak
08-04-2010, 10:49 AM
The x icon is normal as long as you are not connected to this database.

You need to create a new holdemmanager database via the holdemmanager database management. Otherwise it will not work.

Banimal
08-05-2010, 12:32 AM
The x icon is normal as long as you are not connected to this database.

You need to create a new holdemmanager database via the holdemmanager database management. Otherwise it will not work.

This is just absolutely insane?!

Ok... So i created a new database like you said and then reimported the hands from my last few sessions and the results were even more messed up than before!

For example: I just played a session of 2000hands. My normal HM default database said that i only played 1700 hands. Then i copied the hands into a new folder on my desktop>Created a New Database>Re-imported the hands and THEN it said i only play 1200 hands?! I have no idea what is going on here...

netsrak
08-05-2010, 03:58 AM
I think we need to take a look at your installation.
Please schedule a remote support session with our support. Email support@holdemmanager.net, with a link to this thread and your forum name, so we can setup a Teamviewer (http://www.holdemmanager.net/teamviewer) session.

Banimal
08-05-2010, 04:21 AM
I think we need to take a look at your installation.
Please schedule a remote support session with our support. Email support@holdemmanager.net, with a link to this thread and your forum name, so we can setup a Teamviewer (http://www.holdemmanager.net/teamviewer) session.

Ok... This email is sent to holdemmanager support:

TITLED: HM problem, setting up a TeamViewer session‏

Hi there, My Forum name in the HoldemManager Forums is 'Banimal'.

Netsrak suggested this in order to solve my HoldemManager problem:

"I think we need to take a look at your installation.
Please schedule a remote support session with our support. Email support@holdemmanager.net, with a link to this thread and your forum name, so we can setup a Teamviewer session. "


Here is the Link to the thread:

http://forums.holdemmanager.com/manager-general/34381-postgres-restoring-problem-3.html



I am available almost all the time to set up this TeamViewer session. I would really like to solve my problem and i would really appreciate your help. Looking forward to hearing back from you.


p.s. You can add me on AIM chat if you want, my screen name is 'banimal88'

Thank you

Banimal
08-06-2010, 08:10 PM
hi again, any idea how long HoldemManager support generally takes to respond?

I sent them the email (above) a few days ago and i still havnt heard back from them...?

thanks

netsrak
08-07-2010, 07:29 AM
Sorry for the delay, our support seems to be overloaded yesterday. Your request is still open.