PDA

View Full Version : Postgre SQL error 1053 when starting



Luckycharms74
10-31-2009, 08:35 AM
Hi guys. I asm having problems starting my HEM. Each time I try and start the postgre SQL does not start. I have tried to force start in the services menu but when I do get the error above.

http://img263.imageshack.us/img263/9215/postgresqlerror.png.

If I reinstall postgre SQL or install the new version 8.4, will I loose all the data in my current HEM database.

Casius14
10-31-2009, 09:49 AM
i am getting the same error but with version 8.4

fozzy71
10-31-2009, 12:28 PM
This is usually a firewall or windows update issue.

Please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe

Under Vista and Windows 7 make sure UAC is disabled http://www.holdemmanager.net/faq/afmmain.aspx?faqid=73 or holdemmanager.exe, hmhud.exe, and dbcontrolpanel.exe are started as administrator. Run the windows explorer and navigate to your Holdemmanager installation directory. Right click the dbcontrolpanel.exe, holdemmanager.exe, and the hmhud.exe executable and select "Run as admin" from the popup menu.

Add exceptions to the windows firewall, even if it is off. If you have a 3rd party firewall, do the equivalent or uninstall it temporarily - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=171


First try to delete the \postgresql\8.x\data\postmaster.pid file, if you see it, and reboot.

If no help, try this:

Start > Programs > PostgreSQL > 8.x > Stop Service

Start > Programs > PostgreSQL > 8.x > Start Service


Please try following all of these FAQs, step by step:

1) http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=34
2) reinstall the same version of postgresql, using the same \data folder - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=177
3) http://www.holdemmanager.net/forum/showthread.php?t=8261

If that doesn't help you will probably have to reinstall PostgreSQL completely and reimport your hands.

Casius14
10-31-2009, 01:40 PM
ive gone through all of these steps on windows 7 and none of it has worked with 8.4.

i uninstalled 8.4 to try with 8.3 and whaen i come to install it comes up with an error reading:
"The 'Seconday Logon' service is not running. This service is required for the installer to initialise the databse. Please start this serbice and try again."

I have no clue now....teamviewer session?!

fozzy71
10-31-2009, 01:52 PM
The secondary logon service is a standard windows service which is available on every windows computer. In the latest versions it is not started automatically. You need to start it via control panel > administrative tools > services. Right-Click > Properties > Startup > Automatic should insure it works in the future also.

Casius14
10-31-2009, 02:00 PM
thanks.....got 8.3 installed seems i can at least get into hem now, however....

i get teh following error message now

"The following error occured when trying to open the database: FATAL: 3D000: database "Poker" does not exist!"

i'm just praying i havnt lost my original database

fozzy71
10-31-2009, 09:37 PM
Try clicking Ok and getting to the HEM DB Control Panel. That is probably just a warning because the config file doesnt match now, but it could also be because the expected DB is truly gone.

You uninstalled 8.4 and installed 8.3? Or you had 8.3? I am a bit confused by this thread.

Your 'database' is contained in your \postgresql\8.x\data folder. If you didnt delete that you should still have it. When reinstalling 8.3 and trying to use those files, you have to make sure to deselect the [ ] Initialize DB Cluster option.

Casius14
10-31-2009, 10:18 PM
yeah i had 8.4...unistalled that......put 8.3 on and that seemed to work although couldt track a database.

ive just started a fresh one fwiw so no problems atm with that.

thanks tho!

Luckycharms74
11-01-2009, 06:38 AM
This is usually a firewall or windows update issue.

Please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe

Under Vista and Windows 7 make sure UAC is disabled http://www.holdemmanager.net/faq/afmmain.aspx?faqid=73 or holdemmanager.exe, hmhud.exe, and dbcontrolpanel.exe are started as administrator. Run the windows explorer and navigate to your Holdemmanager installation directory. Right click the dbcontrolpanel.exe, holdemmanager.exe, and the hmhud.exe executable and select "Run as admin" from the popup menu.

Add exceptions to the windows firewall, even if it is off. If you have a 3rd party firewall, do the equivalent or uninstall it temporarily - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=171


First try to delete the \postgresql\8.x\data\postmaster.pid file, if you see it, and reboot.

If no help, try this:

Start > Programs > PostgreSQL > 8.x > Stop Service

Start > Programs > PostgreSQL > 8.x > Start Service


Please try following all of these FAQs, step by step:

1) http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=34
2) reinstall the same version of postgresql, using the same \data folder - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=177
3) http://www.holdemmanager.net/forum/showthread.php?t=8261

If that doesn't help you will probably have to reinstall PostgreSQL completely and reimport your hands.

Hi Fozzy

I have tried all the above steps and only want to reinstall new database and postgreSQL as a last resort.
Can we try a teamviewer session as last resort before reinstalling postgreSQL

fozzy71
11-01-2009, 07:31 PM
Sure, but I really dont have any other tricks in my bag. I will just be trying some of those same things most likely.

Please email me at fozzy@holdemmanager.net with a link to this thread, and your forum name, so we can schedule a Teamviewer session. Download the Teamviewer Quick Support Module - http://www.holdemmanager.com/downloads/TeamViewerQS.exe. Please let me know what time zone you are in and what time/days are convenient for you.

foh23
11-01-2009, 10:00 PM
I am trying to vacume analyze the date base. I need the postSQL pass word to do this. I have to do it thru PostgreSQL. Where can I find this password?

Thank you for your time.

fozzy71
11-02-2009, 12:13 AM
The first few lines of your \holdem manager\config\holdemmanager.config file.

Luckycharms74
11-02-2009, 06:51 AM
Hi Fozzy

Thanks fo the reply. I just reinstalled Postgre SQL. It's the easiest way. Working fine now.

rocoso
02-10-2011, 02:37 PM
This is usually a firewall or windows update issue.

Please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe

Under Vista and Windows 7 make sure UAC is disabled FAQ - Hold'em Manager Poker Tracking Software (http://www.holdemmanager.net/faq/afmmain.aspx?faqid=73) or holdemmanager.exe, hmhud.exe, and dbcontrolpanel.exe are started as administrator. Run the windows explorer and navigate to your Holdemmanager installation directory. Right click the dbcontrolpanel.exe, holdemmanager.exe, and the hmhud.exe executable and select "Run as admin" from the popup menu.

Add exceptions to the windows firewall, even if it is off. If you have a 3rd party firewall, do the equivalent or uninstall it temporarily - FAQ - Hold'em Manager Poker Tracking Software (http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=171)


First try to delete the \postgresql\8.x\data\postmaster.pid file, if you see it, and reboot.

If no help, try this:

Start > Programs > PostgreSQL > 8.x > Stop Service

Start > Programs > PostgreSQL > 8.x > Start Service


Please try following all of these FAQs, step by step:

1) FAQ - Hold'em Manager Poker Tracking Software (http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=34)
2) reinstall the same version of postgresql, using the same \data folder - FAQ - Hold'em Manager Poker Tracking Software (http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=177)
3) Still Can't Connect to PosgreSQL? Try This! - Holdem Manager Forums (http://www.holdemmanager.net/forum/showthread.php?t=8261)

If that doesn't help you will probably have to reinstall PostgreSQL completely and reimport your hands.
Gracias a mi si me funciono en un Windows XP y con el postgres 8.2
Thankssssss!!!!
ajua