PDA

View Full Version : Help my HDD just crashed and rebooted and now i can't connect to postgreaql



chris64
07-26-2010, 12:46 AM
I'm getting error 127.0.01 or whatever. I read the sticky and that fix doesn't work.

My host file looks like this


# Copyright (c) 1993-1999 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
# xxx.xx.xx.xx rhino.acme.com # source server
# xx.xx.xx.xx x.acme.com # x client host

127.0.0.1 localhost

The fix says for me to place 127.0.0.1 at the bottom of the file. What has me confused is the fact that it is already there. I put a bunch of Xs because i'm not sure if those numbers are sensitive or not

chris64
07-26-2010, 01:13 AM
i cleared everything out of my host file and replaced it with this text from the fix thread



# Copyright (c) 1993-2006 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host

127.0.0.1 localhost
::1 localhost


Rebooted then tried again but i still get the same error.

Patvs
07-26-2010, 01:28 AM
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. And reboot.


If that doesn't help you will have to reinstall PostgreSQL completely
Read: FAQ - Hold'em Manager Poker Tracking Software :: Can't Connect / Failed to Start PostgreSQL (http://faq.holdemmanager.com/questions/91/Can%27t+Connect+%7B47%7D+Failed+to+Start+PostgreSQ L+)

The Minder
07-26-2010, 01:50 AM
Unless you're an experienced computer tech, get out of your Hosts file. Simple changes here can cause humongous problems.

There was nothing wrong with your Hosts file to start with.

chris64
07-26-2010, 02:10 AM
ok i just went to postgresql under my program files. I clicked on stop server and a little black screen popped up with the following text.
The postgresql server 8.4 service is not started

The stop command returned an error <2>

If i try to open the server through pgadmin is says server is not listening

chris64
07-26-2010, 02:17 AM
Unless you're an experienced computer tech, get out of your Hosts file. Simple changes here can cause humongous problems.

There was nothing wrong with your Hosts file to start with.

i followed the fix given in this forum

netsrak
07-26-2010, 03:24 AM
Is it still not running after you checked the FAQ Pat posted?

chris64
07-26-2010, 10:16 AM
had to reinstall even after following that faq i still got the 127 error.

Patvs
07-27-2010, 01:27 AM
Install SQL 8.3 on port 5433 and SQL 8.2 on port 5434.
Download them from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org)

In Database Management (dbcontrolpanel.exe)--> change the port number