Re: Allowing user to connect to a database?

From: Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk>
To: "pgsql-general (at) postgresql (dot) org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Allowing user to connect to a database?
Date: 2003-06-18 20:18:36
Message-ID: 20030618211836.C19474@bacon
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On 18/06/2003 19:38 Carlos wrote:
> Hi Forum,
> What line should I enter in pg_hba.conf in order to allow all users with
> subnet-mask starting at 255.255.255.0 into database "test"? Should it
> be:
> Host test all 0.0.0.0 255.255.255.0 trust
>

I think you would need something like

Host test all aaa.bbb.ccc.0 255.255.255.0 trust

where aaa is between 1 and 254 and bbb and ccc are between 0 and 254 (for
example 10.0.7.0 or 192.168.3.0)

HTH

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+

In response to

Browse pgsql-general by date

  From Date Subject
Next Message btober 2003-06-18 20:29:25 A View to Share
Previous Message Dennis Gearon 2003-06-18 19:58:45 Single Instance of Backend