Thread: Authentication configuration for local connections on Windows
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?
--
Deepak
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?
--
Deepak
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:
On Thursday, November 17, 2011 3:41:22 pm deepak wrote:
> Hi !> Although, it is not clear what options I have to use whileError in my previous post the setting should be host not localhost.
> building/configuring?
> This same configuration used to work with Postgres 9.0.3, though.
>
> Any thoughts?