(0x0000274D/10061) on Install

From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Joachim Tranvåg
Sent: Monday, March 16, 2009 1:20 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] (0x0000274D/10061) on Install

Hi, I am trying to install PostgreSQL on Windows Vista 32bit, I have deactivated
UAC and the only kind of Firewall I have is Avast Home.
I am installing postgresql-8.3.6-2.zip, have also tried the 8.3.5.1.
I am installing with everything as standard.
During installation, during Activating Procedural Languages I get the error :
"Failed to connect to the database. Procedural languages files are installed, but
are not activated in any databased. Could not connect to server:
(0x0000274D/10061) Is the server running on host "127.0.0.1" and accepting TCP/IP
connections on port 5432?"

And during Activating contrib modules, error:
"Failed to connect to the 'template1' database.Contrib files are installed, but
are not activated in any databased.Could not connect to server:
(0x0000274D/10061) Is the server running on host "127.0.0.1" and accepting TCP/IP
connections on port 5432?"

Then PostgreSQL get "successfully" installed on my system.
But when I try to connect the default database or creating a new, it won't
connect, and gives me the same error (0x0000274D/10061).

I really don't have a clue, but since it won't install it's most likely something
to do with my configutation, maybe I have deactivated some necessary services
etc?
Do you have an idea?

What are you using to attach to PostgreSQL? (e.g. psql.exe ? pgadmin III? Something else?)

What does your pg_hba.conf file look like?

I usually change mine so that the local host can attach:

# TYPE DATABASE USER CIDR-ADDRESS METHOD

# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
host all all ::1/128 trust

When you look at your services, do you see the PostgreSQL service running?

I am using pgadmin to attach to PostgreSQL.

My pg_hba.conf file is default with md5 instead of trust, but have tried to change to trust, without that having any affect on my connecting issue.

And yes, I see 6 postgres.exe services running.

Since it won't properly install it might be some of the settings on my computer instead of the settings on PostgreSQL?

Did you restart the server after making your changes to pg_hba.conf?

From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Joachim Tranvåg
Sent: Monday, March 16, 2009 2:03 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] (0x0000274D/10061) on Install

I am using pgadmin to attach to PostgreSQL.

My pg_hba.conf file is default with md5 instead of trust, but have tried to change to trust, without that having any affect on my connecting issue.

And yes, I see 6 postgres.exe services running.

Since it won't properly install it might be some of the settings on my computer instead of the settings on PostgreSQL?

I am no world champion in making good explanations, so I uploaded a printscreen of my desktop: http://img16.imageshack.us/img16/5823/desktopyoh.jpg
I did restart my server after making the changes to pg_hba.conf?, I am running version 8.3.6.2 btw.

Joachim Tranv�g wrote:

Hi, I am trying to install PostgreSQL on Windows Vista 32bit, I have deactivated UAC and the only kind of Firewall I have is Avast Home.

Just so you know, there's rarely any need to deactivate UAC. Just
shift-right-click on installers and choose "Run as administrator".

During installation, during Activating Procedural Languages I get the error :
"Failed to connect to the database. Procedural languages files are installed, but are not activated in any databased. Could not connect to server: (0x0000274D/10061) Is the server running on host "127.0.0.1" and accepting TCP/IP connections on port 5432?"

I strongly suspect that your firewall will turn out to be the problem.
Consider disabling it or uninstalling it and see if that helps.

--
Craig Ringer

Problem solved!

The sinner is probably windows defender.
Went to C:\Windows\system32\drivers\etc\ and opened the hosts file, and entered "127.0.0.1 localhost" at the bottom of the file, saved and rebooted pc.