PokerTracker

Anyone know how I can restore it? I don't think I did a dump of it prior so I don't know if I can do a db_restore. Please help.

If you have a dump of it before you dropped the database, you can get it back by restoring in PGAdmin (see the Database/Postgres FAQ for a detailed walkthrough). There is no way to restore a dropped database without a backup, so if you don't have that backup, you'd need to create a new database and reimport your hands into it.