PDA

View Full Version : Huge database problem



hindukush
08-28-2010, 05:06 PM
Hi, it seems like I have a rather complicated problem with my database.

Since some kind of nasty virus disturbed my plans today, Holdem Manager doesn't work properly anymore. First it said it couldn't identify my databank or something like that and ever since on launching the database control panel comes up. Because it wouldn't accept my old database details I by now re-installed PostgresSQL several times.

Yet still the control panel will always tell me "role postgres doesn't exist".

http://img507.imageshack.us/img507/9187/erroryk.png

Sometimes, strangely, another message comes up, telling me that a connection to the remote server could not be established...

Also tried some things I found in the forum like setting the parameter in pg_hba.conf to "trust", which I found was already the case...

It's a real pain - dunno what to do... Seems like it's impossible to just create a new database, re-import my old hands an get the HM Manager running properly again. Could need some help :)

Edit: Probably another noteworthy piece of information: In this thread http://faq.holdemmanager.com/questions/75/Create+%7B47%7D+Delete+Database you explain how to delete a database. On doubleclicking on the server the same "role postgres doesn't exist" message comes up. How can I create this role?

netsrak
08-29-2010, 05:51 AM
The role is the database user. It is possible somehow via right click in pgadmin to create a new role but i think your database system is damaged.
You should uninstall postgresql and reinstall the same version (download it from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org)) and try to connect to your existing data folder:
FAQ - Hold'em Manager Poker Tracking Software :: Reinstall PostgreSQL Preserving Old Database (http://faq.holdemmanager.com/questions/71/Reinstall+PostgreSQL+Preserving+Old+Database)