Features Purchase PokerMaster Manual Forum About Us
For Stables
Download
Language
  • English
  • Русский
  • 中文

Manual

Language
  • English
  • Русский
  • 中文
  • What is Hand2Note?
  • Hand2Note vs HM2/PT4
  • Getting Started
  • Supported Rooms

    • Asian Apps
    • Global Rooms
    • Suggest a New Room
    • PokerStars Restrictions
  • License

    • Free Trial
    • Add-on Selection
    • License FAQ
  • Features

    • HUD
    • Reports
    • Aliases
    • Quick Hand View
    • Notes
    • Showdowns Indicator
    • Reg-vs-Fish
    • Extended Popup on Stat
    • Range Research
    • Decision Analysis
    • Auto HUD
    • Marking Hands
    • Sharing Hands
    • Database
    • System Requirements
  • HUD

    • Poker HUD Explained
    • HUD Selection
    • HUD Customization
    • HUD Packages
    • HUD Settings
    • Order private HUD
    • Game Types
    • HUD FAQ
  • Custom Stats

    • Introduction
    • Plain Stats
    • Expression Stats
    • Rebuilding
  • Export & Moving

    • Export Hand Histories
    • Moving Database
    • Moving Config
  • Troubleshooting

    • HUD is not displayed
    • HUD is not being updated
    • Other problems
    • Updating & Older versions
    • Reinstallation
    • How to provide logs
  • Extra

    • Customer Support
    • For Affiliates
    • For Stables
    • For HUD Developers
    • Video course
  • Rooms

    • Free Poker HUD
    • PokerMaster
    • PokerKing Asia
    • RedDragon
    • Adda52
    • PokerStars
    • Winamax
    • Americas Cardroom
    • 888poker

# Database

# General information

Hand2Note uses PostgreSQL to store hands and statistical data. However, Hand2Note doesn't require PostgreSQL installed on your PC. Hand2Note by default uses its own bundled database server, so you don't need to worry about PostgreSQL at all.

By default, Hand2Note database is stored in C:/Users/YourUsername/AppData/Roaming/Hand2Note/h2ndb folder.

AppData is a hidden folder, to open it do the following:

  1. Open File Explorer
  2. Type %appdata% into the address bar and hit enter

Notes and color markers are stored in Hand2Note installation directory, not in the database.

# Database management

# Creating a new database

  1. Go to Configuration → Database
  2. Click "Create database…"
  3. Enter the name of a new database
  4. Click "Activate"
  5. Wait while Hand2Note restarts.
  6. Go back to Configuration → Database and delete the old database, if necessary.

You can import previously played hands into a new database either by pre-exporting them from the old database or from C:/Hand2NoteHH folder.

# Moving database to another drive, directory or PC

Take a look at the Moving database guide in Export and Moving section.

# Additionally

# How to delete hands from database

You can’t selectively delete hands from the database. This feature is not implemented, since the violation of data integrity significantly reduces the performance of the database.

You can create a new database and import only the necessary hands into it.

# How to use your own PostgreSQL server

Using PostgreSQL server

# How to connect to database using PgAdmin

  1. Start Hand2Note
  2. Go to Configuration → Database
  3. Disable "Connect to custom server" option and then activate an existing database
  4. Start the file Hand2Note/pgsql/bin/pgadmin3.exe
  5. Press "Add new connection to server"
  6. Enter Name=h2nserver, Host=localhost, Port=5318 and press OK
  7. Done! Server h2nserver should appear in the list of available servers

← Sharing Hands System Requirements →