PostgreSQL problem

[gmiko]

I have the same problem on two different computers (one is Vista Home, the other is Vista Ultimate), with 3 different postgres versions, including the latest one. Vista installs are clean, I never had this problem and I installed postgres several times in the past.



Almost at the end of installation I get these 4 errors:




Activating procedural languages...

ERROR1: Failed to connect to the database. Procedural languages
files are installed, but are not activated in any databases.

ERROR2: could not connect to server: Connection refused
(0x0000274D/10061)
Is the server running on host "127.0.0.1" and accepting
TCP/IP connections on port 5432?



Activating contrib modules...

ERROR3: Failed to connect to the 'template 1' database. Contrib files
are installed, but are not activated in any databases.

and again, same as error2..

ERROR4: could not connect to server: Connection refused
(0x0000274D/10061)
Is the server running on host "127.0.0.1" and accepting
TCP/IP connections on port 5432?



Installation finishes but Holdem Manager can't connect to the database or start the service.

Any ideas?

Tried almost everything.

[morny]

We have the fix:

Hi, Microsoft released a patch last night that has caused some issues with
the postgresql service for some people on Vista. The following steps seem to
get around this problem:

1: Go to "C:\Windows\system32\drivers\etc" and open the "hosts" file with
notepad

It might look something like this:
**************************************************
# 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

::1 localhost
************************************************** ****

2: Enter "127.0.0.1 localhost" (without the quotes) at the bottom of the
file
4: Save the file
5: Restart PostgreSQL service by clicking on Start Menu - Programs -
Postgresql - Start Service

Thanks,

Roy




Anyone having issues can you please do the following and let me know what the error is:

Try and start the postgreSQL service:
Go to Control Panel > Administrative Tools > Services > Then scroll To PostgreSQL Database Server and make sure it’s started and if not Right click PostgreSQL Database Server and choose start

Most likely this will give an error like:
The postgreSQL Database service started then stopped, Some services stop automatically if they have no work to do...

When you get the error do the following:
Go to Control Panel > Admin Tools > Event Viewer > Windows Logs > Applications and in there for the time corresponding to the time you got the error starting the service you should see a postgreSQL error, copy and paste the details of the error into this thread

Lastly you do not need to delete all the text in that file, its fine if you do but you dont need to but make sure the following lines are in it:

127.0.0.1 localhost
::1 localhost

[Jamlaja]

Hello,

I make what you say but that say me : can't to create the file C:\Windows\system32\drivers\etc

Check that the name and the way of access is right

???

[fozzy71]

Save the file to your desktop after editing it. Then copy/paste it back into the proper folder and overwrite (copy and replace) the existing file.