PDA

View Full Version : Postgresql wont start



Ptrckolous
03-06-2010, 11:00 AM
hello,

seems like my postgresql wont start... if i try to get it started by using holdemmanager i get the following error message :

Imageshack - erroros.jpg (http://img709.imageshack.us/i/erroros.jpg/)

any idead what i can do to get this running again?

i uninstalled any antivir and reinstalled postgresql a few times

also if i try to connect to there db by using the pgAdmin III i get this error:

Imageshack - error1j.jpg (http://img163.imageshack.us/i/error1j.jpg/)

is there a chance to reinstall postgresql/deleting the old database, creating a new one and copying my old db into the new one?

i imported tons of hands (180gb) and cant import them again, so it would be nice if i just could replace the old database folder by the new one ... would something like this work ?

edit:// if i take a look at the logs:

2010-03-06 15:37:10 CET LOG: database system was interrupted while in recovery at 2010-03-06 13:43:26 CET
2010-03-06 15:37:10 CET HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery.
2010-03-06 15:37:10 CET LOG: database system was not properly shut down; automatic recovery in progress
2010-03-06 15:37:10 CET LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-03-06 15:37:10 CET FATAL: the database system is starting up
2010-03-06 15:37:10 CET LOG: redo starts at E8/B800E058
2010-03-06 15:37:11 CET LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-03-06 15:37:11 CET FATAL: the database system is starting up
2010-03-06 15:37:12 CET LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-03-06 15:37:12 CET FATAL: the database system is starting up

does this help maybe?


thanks

fozzy71
03-06-2010, 02:42 PM
This is usually a firewall or windows update issue.

First try to reboot.

If no help, try this:

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

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

If that doesnt help delete the \postgresql\8.x\data\postmaster.pid file, if you see it.

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 :: Windows Firewall / Defender Problems (http://faq.holdemmanager.com/questions/275/Windows+Firewall+%7B47%7D+Defender+Problems)

Please try following these FAQs, step by step:

1) FAQ - Hold'em Manager Poker Tracking Software :: Can't Connect / Failed to Start PostgreSQL (http://faq.holdemmanager.com/questions/91/Can't+Connect+%7B47%7D+Failed+to+Start+PostgreSQL+ )
2) reinstall the same version of postgresql, using the same \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)
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 using these instructions

1) Uninstall PostgreSQL from the Windows Control Panel.
2) Use our combo installer to reinstall PostgreSQL. Make sure you un-check Holdem Manager during installation. http://www.holdemmanager.com/downloads/Holdem_Manager_Setup.exe

If that installer fails to install PostgreSQL, please reinstall PostgreSQL using the following instructions:
A) Start > Programs > Accessories > Command Prompt > Right-Click > Run As Administrator

net user postgres /delete
B) Reboot.
C) Try installing this version of PostgreSQL - http://www.holdemmanager.com/downloads/Postgres_8.3.9-v1.0.7.exe

Ptrckolous
03-06-2010, 03:03 PM
ive been through all this before, i saw the answer earlier today but nothing helps

i managed it to get a new database running but thats not what i want because i imported a lot of hands (170gb)

is there any chance of getting connected to my old database without the hands i imported the last 48 hours ?

kaspersky showed me a error message about a file 16638 in the base\16403 folder which was infected by a virus so i think it might have damaged my databse

is there a chance of "deleting" the last 48h import from my database so i can get back to it and dont import these files?

i think its the only chance i have to get back to my database without reimporting all of these files again because i tried almost everything for the whole day

morny
03-06-2010, 07:13 PM
Usually if your antivirus finds a virus it will delete/remove files from the folder, maybe if you can get it to recover those files and return them to the folder it might reconnect but all those files are linked together like spokes so when you remove or damage any files in there the whole system breaks so if it was a corruption of 1 of those files im afraid reimporting is probably your only option.

You could try on one of the postgreSQL forums if your determined to get this fixed rather than reimport

Ptrckolous
03-06-2010, 09:51 PM
the problem is that i cant get hm running, so how can i reimport those files again ? is there any other option of importing files to the db without using hm?

edit:// is there a chance to get this fixxed even without getting the db running because i dont get the service started either

netsrak
03-07-2010, 06:38 AM
The imported files go to your archive (default c:\hmarchive) from where you can import them again.

If you want to try to use your old database again you can try a postgresql installation with the old 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)
but i'm not sure whether this works in your case because one database file was damaged.

Ptrckolous
03-07-2010, 06:53 AM
seems like i only have hands that i played in my hmarchive because if i take a look at the 1707handhistory-1.txt for example there are only hands that i played and not the hands which i imported

netsrak
03-07-2010, 07:15 AM
Yes, only hands imported via Auto-Import are archived

Ptrckolous
03-07-2010, 07:30 AM
i figured that my external hdd (where my data folder was moved to) is fat32. everything worked well so long, might this be an issue too? i read that the hdd has to be ntfs

Ptrckolous
03-07-2010, 10:37 AM
hm this didnt fixxed it ... still the same problem like in the beginning

do i have another choice than reimporting them or is this my only option to get my db working again?

morny
03-07-2010, 11:38 PM
i figured that my external hdd (where my data folder was moved to) is fat32. everything worked well so long, might this be an issue too? i read that the hdd has to be ntfs

Some of the older postgreSQL versions wont work with FAT32 but HM should be fine


hm this didnt fixxed it ... still the same problem like in the beginning

do i have another choice than reimporting them or is this my only option to get my db working again?

Yeah it looks like reimporting is your only option