From: | "Adam Fernie" <adam(at)mysi(dot)co(dot)uk> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: pg_hba.conf includes |
Date: | 2006-08-09 13:32:36 |
Message-ID: | 20060809133515.1B4555AFB1F@svr4.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Richard Broersma
Jr
Sent: 07 August 2006 14:58
To: Adam Fernie; pgsql-admin(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | mcelroy, tim | 2006-08-09 13:43:48 | Re: Start-up script for Solaris |
Previous Message | Bill Moran | 2006-08-09 13:00:31 | Re: unsubscribe |