ERROR FATAL: 3D000:database "postgres" does not exist

[matter17]

This is the message I'm getting. I've accidently deleted something important from "postgres". It doesn't seem to reload. Help please.

More Info: When troubleshooting your postgres video, when I Start Server it says "System error 5 has occured"

[udbrky]

Don't delete anything in Postgres.

It appears there might be an issue with PostgreSQL and reinstalling it should help resolve this.

Make sure windows is fully updated until 'No New Important Updates are Found' (this may require multiple restarts and multiple 'check for updates'), including Internet Explorer (even if you use a different web browser). This is important because it will install critical updates that affect PostgreSQL and maybe related to the issues you are seeing.

Please note that reinstalling PostgreSQL will mean losing all your old data. If you have access to HM2 and your database was not corrupt then please follow these instructions for backing up your database - http://hm2faq.holdemmanager.com/questions/1471/How+does+Backup+and+Restore+Database%2C+Settings+a nd+HUD+configs+work%3F

If you cannot access the database in HM2 then you can backup your database using this method: http://hm2faq.holdemmanager.com/questions/952/How+does+Backup+or+Restore+via+PostgreSQL+work%3F+ %28Advanced+Method%29 but if your database was corrupt then the best solution is to reimport all your hands from C:/HM2archive folder or if your pokersite supports it you can request all your hands and summaries and reimport them as restoring a corrupt database will just restore all the problems you had.

Once you have backed up your previous database(s) then follow the instructions below to uninstall and reinstall PostgreSQL.

1) Uninstall PostgreSQL from the Windows Control Panel.

2) Delete the \PostgreSQL\8.x\data folder that is left behind.

3) Delete the sub-folder(s) in c:\users\username\appdata\roaming\HoldemManager\Da tabase (XP - c:\documents and settings\username\application data\HoldemManager\Database).

4) Restart your PC

5) Use our combo installer to reinstall PostgreSQL. Make sure you un-check Holdem Manager during installation. http://www.holdemmanager.com/downloads/Holdem_Manager_2_Setup.exe

Start HM2 again and create a New Database.

[matter17]

I deleted Postgres but when I use the combo installer it doesn't allow the option of installing Postgres, it says it's already installed. Then, of course, it can't connect to it when I try to start HM2. (because it doen't exist obv.)

[udbrky]

Make sure you do not have more installed.

Did you delete the Postgres user?

Did you install Postgres from their website?

[matter17]

I searched my computer and deleted all the postgres files found. I don't know what the "postgres user " is. Yes, I installed from their website, but deleted that as well. Still no luck.

[udbrky]

Make sure windows is fully updated until 'No New Important Updates are Found' (this may require multiple restarts and multiple 'check for updates'), including Internet Explorer (even if you use a different web browser).

Please note that reinstalling PostgreSQL will mean losing all your old data. If you have access to HM2 and your database was not corrupt then please follow these instructions for backing up your database as a precaution in case you cannot reconnect after reinstalling PostgreSQL - http://hm2faq.holdemmanager.com/questions/1471/How+does+Backup+and+Restore+Database%2C+Settings+a nd+HUD+configs+work%3F

If you cannot access the database in HM2 then you can backup your database using this method: http://hm2faq.holdemmanager.com/questions/952/How+does+Backup+or+Restore+via+PostgreSQL+work%3F+ %28Advanced+Method%29 but if your database was corrupt then the best solution is to reimport all your hands from C:/HM2archive folder or if your pokersite supports it you can request all your hands and summaries and reimport them as restoring a corrupt database will just restore all the problems you had.

1) Uninstall PostgreSQL from the Windows Control Panel.

2) Delete the \PostgreSQL\X.x\data folder that is left behind.

3) Delete the sub-folder(s) in c:\users\username\appdata\roaming\HoldemManager\Da tabase (XP - c:\documents and settings\username\application data\HoldemManager\Database).

4) run the command - start > programs > accessories > command prompt > right-click > run as administrator

net user postgres /delete

After you click 'Enter' for the code above also do that same for this code:

sc delete postgresql-8.4

and click 'Enter' again.

5) Restart your PC

6) Install PostgreSQL 9.3 from http://www.enterprisedb.com/products-services-training/pgdownload#windows

7) Once installed you should disable the postgresql logging as instructed here - http://hm2faq.holdemmanager.com/questions/1121/Large+Log+Files

If there is still an issue, we need to know the error - it is in the temp folder - bitrockinstaller.txt file. If you can't see it, turn off the windows option that is hiding that directory. http://faq.holdemmanager.com/questions/130/How+to+See+Hidden+Files+in+Windows+

[matter17]

Step 4 is beyond me, and 2 other people I've asked. To "run the command" do I left=click the windows icon, select run, because that didn't like "start". If I right click that icon, choose start then programs then accessories isn't an option.

[udbrky]

Where did you get stuck?

Did you choose the way that is appropriate for your operating system?

[matter17]

elsewhere

[matter17]

elsewhere

[matter17]

I also tried to play on an old computer, but the HM2 licence code could not be used. If you could allow my licence code to be used again this would at least give me a work-around, which would be very helpful, and it is obviously easier for both of us.

[fozzy71]

I also tried to play on an old computer, but the HM2 licence code could not be used. If you could allow my licence code to be used again this would at least give me a work-around, which would be very helpful, and it is obviously easier for both of us.

Some of our recent releases were causing registration problems. We had to undo and correct some things in the registration code and servers to solve their problems. Unfortunately, this change means some customers that weren't having problems will have to reset their profiles and enter their code again.

The same code can be used on 2 pc's you own at once and can be reset as often as needed. Please try using our site (https://www.holdemmanager.com/store/login.php) to retrieve and/or reset the code (http://hm2faq.holdemmanager.com/questions/882/New+Computer+%7B47%7D+License+Transfer+%7B47%7D+Re set+Code) whenever necessary.


If you have any problems activating the software please see this FAQ (hm2faq.holdemmanager.com/questions/881/I+Can+Not+Activate+or+Register+Holdem+Manager) for help in resolving licensing issues.


If you continue to have problems, please reproduce the problem and send your HM2Logs folder (http://hm2faq.holdemmanager.com/questions/1921/How+Do+I+Send+a+Log+File+to+Holdem+Manager+Support %3F) with a detailed description of what you were doing and what problems you were experiencing.