PDA

View Full Version : erro while creating back up database



jachtgodin1973
09-13-2011, 06:41 AM
This summerholiday i spend some time to make one new database containing all my hh files from last 2,5 years (about 250K hands). It contains hh files from3 different pokerrooms. The database itselfs works fine but while making a backup (in order to transfer this database to other laptop) i get this error messages.

Any thoughts on this?

[13-9-2011 12:36] megaverzameldatabase: error: pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: could not read block 7552 of relation base/49588/49826: Invalid argument
pg_dump: The command was: COPY public.postflopactions_month (compiledplayerresults_id, streetactiontype_id, count, betorraise, checks, checkcall, checkfold, checkraise, bet, betcall, betraise, betfold, raise, raisecall, raiseraise, raisefold, call, callcall, callraise, callfold, fold, unopenedinposition, betunopenedinposition, totalbets, totalcalls, sawshowdown, wonshowdown) TO stdout;

[13-9-2011 12:36] error: error backup up megaverzameldatabase

fozzy71
09-13-2011, 08:31 AM
Your database is corrupt.

Export your Hand Histories
http://faq.holdemmanager.com/questions/98/How+to+Import+%26+Export+Hands

Export Your Notes
http://faq.holdemmanager.com/images/notes-02.jpg

Export Your Bonuses and Rakeback – Options > Rakeback & Bonuses http://faq.holdemmanager.com/images/rakeback-bonuses-01.jpg

Export any tourney summaries by selecting all your tournaments in the Data View Sub-Tab of the Tourney > Results Menu and choose Export Tourney Results and summaries

http://faq.holdemmanager.com/images/tourney-data-view-01.jpg

Then can you create a new database http://faq.holdemmanager.com/questions/75/Create+%7B47%7D+Delete+Database

Finally reimport all your hands/notes/summaries into the new database


This is why regular backups are a good idea. If your database becomes corrupt you can restore a backup and only have to import the most recent hands (that were played after the backup was created).


We have a backup and restore feature within Holdem Manager that makes it easy for you to backup all your settings, hand histories and files.
http://faq.holdemmanager.com/questions/418/Backup+%26+Restore

This is a new feature and there are some compatibility issues with it so if you have any problems you can do this manually by following the instructions below:

Manual database backup/restore via pgadmin - http://faq.holdemmanager.com/questions/72/Backup+%26+Restore+Database