Re: Authentication configuration for local connections on Windows

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: deepak <deepak(dot)pn(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Authentication configuration for local connections on Windows
Date: 2011-11-17 23:58:47
Message-ID: 4EC59FB7.2040904@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 17/11/2011 23:41, deepak wrote:
> Hi !
>
> When attempting to start Postgres 9.1.1 with hba conf for "local"
> connections on Windows, I get an error.
>
> e.g. I tried adding the following line to pg_hba.conf
> local all user1 trust
>
> and I get:
> pg_ctl -D pgsql\data -w start
> waiting for server to start....LOG: local connections are not supported
> by this build
> CONTEXT: line 92 of configuration file "C:/pg/pgsql/data/pg_hba.conf"
> FATAL: could not load pg_hba.conf
> .... stopped waiting
> pg_ctl: could not start server
>
>
> Although, it is not clear what options I have to use while
> building/configuring?
> This same configuration used to work with Postgres 9.0.3, though.
>
> Any thoughts?

On Windows you need to use a "host" line, as Unix sockets aren't available.

Ray

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Voras 2011-11-18 00:08:08 Re: Session variables and C functions
Previous Message Adrian Klaver 2011-11-17 23:53:49 Re: Authentication configuration for local connections on Windows