Authentication configuration for local connections on Windows

On Thursday, November 17, 2011 3:41:22 pm 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?

Local refers to Unix sockets. Windows does not have them so you will need to use
localhost.

For the reason why:

http://www.postgresql.org/docs/9.1/interactive/release-9-1.html
Reject local lines in pg_hba.conf on platforms that don't support Unix-socket
connections (Magnus Hagander)

"Formerly, such lines were silently ignored, which could be surprising. This
makes the behavior more like other unsupported cases. "

--
Deepak

--
Adrian Klaver
adrian.klaver@gmail.com

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@iol.ie

On Thursday, November 17, 2011 3:41:22 pm deepak wrote:

Hi !

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?

Error in my previous post the setting should be host not localhost.

--
Deepak

--
Adrian Klaver
adrian.klaver@gmail.com

Thanks!

On Thu, Nov 17, 2011 at 7:33 PM, Adrian Klaver <adrian.klaver@gmail.com>wrote: