PDA

View Full Version : PostgreSQL cannot start error 127.0.0.1



LURPED
01-24-2011, 07:10 PM
I've tried everything in the forums please help.

M

pjo336
01-24-2011, 07:49 PM
This is usually a firewall or windows update issue and the following guide will help you to fix this problem.

Go to Start > Programs (or all programs) > PostgreSQL 8.x > choose Stop Service

Start > Programs (or all programs) > PostgreSQL 8.x and choose Start Service. This may take some time and a black dos window may appear while itís starting. If it fails to start delete the C:\Program Files\postgresql\8.x\data\postmaster.pid file, if you see it. Do not delete any other files

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) - Windows Firewall / Defender Problems

If none of those worked Please reboot and 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+ ) Canít Connect / 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+DatabaseReinst all) PostgreSQL Preserving Old Database

Failing that you will probably have to reinstall PostgreSQL completely and reimport your archived hands using these instructions. Once you do this you wonít have access to the hands in the old database but since you canít connect to the database your already in that situation. In the case itís not possible to reconnect you can either contact the PostgreSQL forums who may be able to help with advanced connection issues or you can reinstall. Iíve listed 3 PostgreSQL forums below
PostgreSQL Help Forums (http://forums.devshed.com/postgresql-help-21/)
PostgreSQL (http://old.nabble.com/PostgreSQL-f759.html)
PostgreSQL - dBforums (http://www.dbforums.com/postgresql/)

1) Uninstall PostgreSQL via Control Panel > Programs & Features (Add/Remove Programs on XP).
2) Use our combo installer to reinstall PostgreSQL. Make sure you un-check Holdem Manager during installation. http://rvgsoftware.fileburst.com/Holdem_Manager_Setup.exe

If that installer fails to install PostgreSQL, please reinstall PostgreSQL using the following instructions:

The secondary logon service is a standard windows service which is available on every windows computer and is required to be running to install PostgreSQL. In the latest versions it is not started automatically. You need to start it via control panel > administrative tools > services. Starting it once should insure it works in the future also.

Go to Start > Programs > Accessories > Command Prompt > Right-Click > Run As Administrator
In the window that appears please type the following and press enter:

net user postgres /delete

If none of this works, let us know.

LURPED
01-24-2011, 08:27 PM
none of this is working can you please connect using team viewer and help me?

Patvs
01-25-2011, 10:28 AM
If you tried EVERYTHING listed above.

Download a different version of SQL from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org)
Try 8.2 if 8.4 fails.

LURPED
01-25-2011, 02:19 PM
I think i've screwed it up even more. I obviously don't know what I'm doing so could you please help me with this? I really need to get it fixed. I'll pay you. Just please help me

LURPED
01-25-2011, 02:48 PM
nevermind fixed it

Tecahai
02-01-2011, 05:16 PM
how did you fix it

netsrak
02-02-2011, 02:23 PM
If you cant figure it out with the hints we posted Please schedule a remote support session with our support. Email support@holdemmanager.net, with a link to this thread and your forum name, so we can setup a Teamviewer (http://www.holdemmanager.net/teamviewer) session.

Tecahai
02-03-2011, 12:32 PM
I fixed it by reducing the windows 7 security levels to the minimum

takeem21
02-06-2011, 07:45 PM
. If it fails to start delete the C:\Program Files\postgresql\8.x\data\postmaster.pid file, if you see it. Do not delete any other files



ok i have 2 questions...

1. what will deleting that file do?

2. is postmaster.opts the same thing or different. and should i delete it or leave it be?
i didnt see a postmaster.pid file.

Patvs
02-07-2011, 01:09 AM
Don't delete the opts file.

Delete the .pid file, and either:
restart your computer
stop--> start the PostgreSQL server

PostgreSQL will re-write the .pid file. It's like a reset.
Similarly if a HoldemManager file with settings is corrupted (holdemmanager.conf, exenames.txt, any file in your Config folder) if you delete it and restart HoldemManager, HoldemManager will re-create the file back to DEFAULT)

AntarMauna
02-19-2011, 01:24 PM
Hi,

I have the same problem PostgreSQL cannot start error 127.0.0.1

I has worked for a long time, and all of a sudden I got the error. I tried uninstallling a couple of new programs (which I suspected was involved in the sudden error) but the error was still there, so I even uninstalled my firewall, Zonealarm, which previously had no problems working with HEM and PostgreSQL. I have tried reinstalling PostgresSQL a few times. My database (which I would not like to loose, since it contains millions of hands including 100.000's of my own) is in postgres 8.3. And I have tried everything, without any luck, in the post from pjo336, untill


Failing that you will probably have to reinstall PostgreSQL completely and reimport your archived hands using these instructions.

Which instructions are you talking about?


Once you do this you wonít have access to the hands in the old database

Why not, if I have just reimported them(as you say) ?



but since you canít connect to the database your already in that situation. In the case itís not possible to reconnect you can either contact the PostgreSQL forums who may be able to help with advanced connection issues or you can reinstall. Iíve listed 3 PostgreSQL forums below
PostgreSQL Help Forums
PostgreSQL
PostgreSQL - dBforums
Reinstallation does not work. So the next thing I should do is contact the database forums? I am a poker player for crying out loud, I am a user of a statistics program, how much work do I have to do, and how much of a database expert do I have to become to use your program? It is driving me insane.

What now?

netsrak
02-20-2011, 06:53 AM
Reinstall Postgresql following this guide: http://faq.holdemmanager.com/questions/71/Reinstall+PostgreSQL+Preserving+Old+Database

This may restore your old database.
If that fails create a new database and reimport your hands from the archive folder (default c:\hmarchive) via import file or import from folder.

You should do regular backups in the future.