From: | "Carlos Oliva" <carlos(at)pbsinet(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | FW: Allowing user to connect to a database? |
Date: | 2003-06-19 13:04:19 |
Message-ID: | E148BE531B8AD311922E005004D3EEA1010F1DE4@xchserver.pbsinet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Paul,
This worked very well. Perhaps, you can help me with another question:
If I write an aaa bbb ccc of 200.200.200.0, do all clientes with IP
addresses between 0.0.0.0 and 200.200.200.0 can connect?
Thanks in advance for your response
-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Paul Thomas
Sent: Wednesday, June 18, 2003 4:19 PM
To: pgsql-general @ postgresql . org
Subject: Re: [GENERAL] Allowing user to connect to a database?
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 |
+------------------------------+----------------------------------------
-----+
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly
From | Date | Subject | |
---|---|---|---|
Next Message | Jonathan Bartlett | 2003-06-19 13:39:35 | Re: A creepy story about dates. How to prevent it? |
Previous Message | Dick Wieland | 2003-06-19 12:47:23 | Re: pg_options in postgres 7.3.2 |