pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Donald Fraser <postgres@kiwi-fraser.net>
To: [ADMIN] <pgsql-admin@postgresql.org>
Subject: Re: pg_hba.conf
Date: Tue, 22 Feb 2005 13:48:11 -0000
Message-ID: <008201c518e5$268d77b0$0264a8c0@demolish1> (raw)
References: <ED4E30DD9C43D5118DFB00508BBBA76EB165D6@neptun.sonorys.at>
	<20050222132615.GS66519@eris.tenfour>

If postgres has ssl enabled then it will by default negotiate to use ssl,
regardless of the host or hostssl settings in pg_hba. Your client software
needs to refuse ssl connections then it will fall back to a non-ssl
connection so long as there exists a host setting in pg_hba. The hostssl
setting in pg_hba means that it must use ssl to connect, where as the host
setting in pg_hba can mean either or, depending on your client.

What client software are you using?

Regards
Donald Fraser

----- Original Message ----- 
From: "Dick Davies" <rasputnik@hellooperator.net>
To: "PostgreSQL Admin" <pgsql-admin@postgresql.org>
Sent: Tuesday, February 22, 2005 1:26 PM
Subject: Re: [ADMIN] pg_hba.conf


> * K?PFERL Robert <robert.koepferl@sonorys.at> [0228 12:28]:
> > According to the excelent doc, the _first_ matching entry will be used.
>
> If that were true, the below would work, surely?
>
> > C:\> I have this:
> > C:\>
> > C:\> root@eris:postgresql80-server$ cat /opt/pgsql/data/pg_hba.conf
> > C:\> # TYPE     DATABASE    USER        IP-ADDRESS      METHOD
> > C:\> local      all         all                         trust
> > C:\> host    all         all         10.2.3.4/32   md5
> > C:\> hostssl    all         all      0.0.0.0/0   md5
>
> -- 
> 'Interesting. No, wait, the other thing - Tedious.'
> -- Bender
> Rasputin :: Jack of All Trades - Master of Nuns
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>




view thread (53+ messages)  latest in thread

Message-ID: <008201c518e5$268d77b0$0264a8c0@demolish1>
Permalink:  ../008201c518e5$268d77b0$0264a8c0@demolish1/
Also on:    postgresql.org/message-id/008201c518e5$268d77b0$0264a8c0@demolish1

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: postgres@kiwi-fraser.net
  Subject: Re: pg_hba.conf
  In-Reply-To: <008201c518e5$268d77b0$0264a8c0@demolish1>
  References: <ED4E30DD9C43D5118DFB00508BBBA76EB165D6@neptun.sonorys.at> <20050222132615.GS66519@eris.tenfour> <008201c518e5$268d77b0$0264a8c0@demolish1>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox