pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Adam Fernie <adam@mysi.co.uk>
To: pgsql-admin@postgresql.org
Subject: Re: pg_hba.conf includes
Date: Wed, 9 Aug 2006 14:32:36 +0100
Message-ID: <20060809133515.1B4555AFB1F@svr4.postgresql.org> (raw)

Hi,

I understand how the subnetting works.  What I had problems with was
putting more than one IP address / hostname into the include file.

If my include file looks like so...
<file start>
1.2.3.4
<file end>
Then it works fine

If the include file looks like this...
<file start>
1.2.3.4
1.2.3.5
<file end>
Then it doesn't work (for either address) and I get an error like...
psql: FATAL:  missing or erroneous pg_hba.conf file

Hope someone can help here...


Adam

-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Richard Broersma
Jr
Sent: 07 August 2006 14:58
To: Adam Fernie; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] pg_hba.conf includes

> host    dbname      all     @myhosts 255.255.255.255 md5
> 
> If I put a single ip or hostname in the file it works a treat but I 
> don't know how to include more than 1 host or IP address is the file.
> Should it be comma seperated, newline for each file or something 
> different?

You can add additional lines for each IP. 

Or if all of your clients are on the same sub-network, then you can
alter your net mask in the above line to allow them. i.e.
<255.255.255.0>  So for example if your client is 191.168.1.100 and your
next mask is 255.255.255.0, then all ip like 192.168.1.* will be allowed
to connect.

Regards,

Richard Broersma Jr.



---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq



Scanned by Serendipity Interactive -  MYmailSAFE






Scanned by Serendipity Interactive -  MYmailSAFE




view thread (3+ messages)

Message-ID: <20060809133515.1B4555AFB1F@svr4.postgresql.org>
Permalink:  ../20060809133515.1B4555AFB1F@svr4.postgresql.org/
Also on:    postgresql.org/message-id/20060809133515.1B4555AFB1F@svr4.postgresql.org

 · 

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: adam@mysi.co.uk
  Subject: Re: pg_hba.conf includes
  In-Reply-To: <20060809133515.1B4555AFB1F@svr4.postgresql.org>
  References: <20060809133515.1B4555AFB1F@svr4.postgresql.org>

* 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