PostgreSQL doesn't connect

[ArtanisAce]

I made like you said in the sticky, but still doesn't connect... Anyway I have 2 files named "Hosts", one has MSN extension, but looks like the one you put on the sticky... so what can I do? Thank you

[Sarek]

Please tell what exactly you did - every step.

[ArtanisAce]

What is the extension of the file I have to modify?

[Sarek]

this file has no extention
hosts
and no more

[ArtanisAce]

I have this on the file:

# Copyright (c) 1993-2009 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

# localhost name resolution is handled within DNS itself.
# 127.0.0.1 localhost
# ::1 localhost
# Start of entries inserted by Spybot - Search & Destroy
127.0.0.1 007guard.com - 007guard and Free Antivirus (http://www.007guard.com)
127.0.0.1 007guard.com
127.0.0.1 008i.com
127.0.0.1 008k.com (http://www.008k.com)
127.0.0.1 008k.com
127.0.0.1 00hq.com (http://www.00hq.com)
127.0.0.1 00hq.com
127.0.0.1 010402.com
127.0.0.1 www.032439.com (http://www.032439.com)
127.0.0.1 032439.com
127.0.0.1 Scan | Free Anti Virus | Bitdefender | Malware | Avast | Avg | Spyware Removal | Adware at 0scan.com (http://www.0scan.com)
127.0.0.1 0scan.com

... and more like this, what I have to modify?

[olliepower]

Hi,

I asked for some help from another mod. We should be posting again shortly.

Ollie

[fozzy71]

This is usually a firewall or windows update issue.

Make sure windows is fully updated and change your Windows Control Panel > Regional Settings Format to English (USA).

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 > secondary logon > right-click > start AND right-click > properties > startup type: automatic.

First try to reboot.

If no help, try this:

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

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

*If UAC is enabled you have to Right-Click > Run As Administrator when you Start/Stop the 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 - http://faq.holdemmanager.com/questions/275/Windows+Firewall+%7B47%7D+Defender+Problems

Please try following these FAQs, step by step:

1) 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 - http://faq.holdemmanager.com/questions/71/Reinstall+PostgreSQL+Preserving+Old+Database
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 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


If none of that helps, or you have problem with any of the steps, 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/teamviewer Please let me know what time zone you are in and what time/days are convenient for you. I schedule support from 13:00 - 22:00 GMT, 7 days a week.

[ArtanisAce]

Solved, I just had to restart postgresql. Thank you very much :)