Features Purchase HUD Store
Forum
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

    • HUD Selection
    • HUD Customization
    • HUD Packages (opens new window)
    • HUD Settings
    • Order custom HUD (opens new window)
    • Game Types
    • HUD FAQ
    • Poker HUD Explained
  • 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 (opens new window)
    • For HUD Developers
    • Video course (opens new window)
  • 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 →