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?
Best Regards
Joachim
Обсуждение: (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.
I am installing postgresql-8.3.6-2.zip, have also tried the 8.3.5.1.
I am installing with everything as standard.
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?
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?
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 haveis 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. Couldnot connect to server: (0x0000274D/10061) Is the server running on host "127.0.0.1" and accepting TCP/IP connectionson 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
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.
I did restart my server after making the changes to pg_hba.conf?, I am running version 8.3.6.2 btw.
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.
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.