old postgesSql database
Results 1 to 2 of 2
  1. #1
    Junior Member
    Join Date
    Sep 2020
    Posts
    15

    Default old postgesSql database

    i looked on old external hard drive and i have a folder inside a program folder called postgesSQL then inside their data or data old folders from 2010, im not sure what this folder is but odds are this is old hem1 or 2 or pokertracker hh database, i tried to upload this folder to hem3 and it didnt work. got errors unrecognized file format. when i click thru the folders tho i dont see typical notepad hand histories but their is large amount of data their size wise but is encrypted format so no clue.

    Any idea to know if this was old poker databased when you or pokertracker use to use postgesSQL. their no other application i would have ever used postgesSQL. Thanks

    here is a snippet if what i see when opening in note pad of single file in their:
     >/  p  0` P@*@ @0@@И @@p@І@0@@@ @@p@ `@@ @@@@@*@ @`@   2  )  ;
    pg_statistic  Z "   , pg_toast_11459 c ,
    , ,  t   {  Z !  )  , sql_sizing_profiles 1, ,
    , , r  { [   
    o
     *  Z    , pg_toast_11454_index


    here is another snippet from different folder:

    2009-02-07 15:01:56 EST NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "pokersites_pkey" for table "pokersites"
    2009-02-07 15:01:56 EST NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "handhistories_pkey" for table "handhistories"
    2009-02-07 15:01:56 EST NOTICE: CREATE TABLE will create implicit sequence "importedfiles_importedfile_id_seq" for serial column "importedfiles.importedfile_id"
    2009-02-07 15:01:56 EST NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "allinsituations_pkey" for table "allinsituations"
    2009-02-07 15:01:56 EST NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "playerhandsflop_pkey" for table "playerhandsflop"
    2009-02-07 15:01:56 EST NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "playerhandsturn_pkey" for table "playerhandsturn"
    2009-02-07 15:01:56 EST NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "playerhandsriver_pkey" for table "playerhandsriver"

  2. #2
    *** HM3! *** fozzy71's Avatar
    Join Date
    Jun 2005
    Location
    HM Support
    Posts
    32,843

    Default

    Unfortunately, there is no way to get that data directly into HM3 as HM3 uses SQLite instead of PostgreSQL. You would need to recover or restore it to the original HM1, PT3, etc program then try and export the hands so they can be imported to HM3.
    Last edited by fozzy71; 02-27-2024 at 09:54 AM.

Similar Threads

  1. Importing hands from old database to new database?
    By Gaylord in forum Manager General
    Replies: 3
    Last Post: 12-14-2010, 11:05 AM
  2. Restoring to new database kills off old database
    By JtX in forum Manager General
    Replies: 12
    Last Post: 10-05-2010, 08:27 PM
  3. Retrieve my old hem config (and my old hands)
    By MathiasMS in forum Manager General
    Replies: 1
    Last Post: 10-24-2009, 10:34 PM
  4. Replies: 1
    Last Post: 06-16-2009, 01:44 PM
  5. New database - HUD on old database
    By manon in forum Manager General
    Replies: 1
    Last Post: 02-20-2009, 10:04 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •