-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
No, it wouldn't.
Let's say you want to enable 192.168.0.x, for example (x is anything in 0..255):
all all 192.168.0.0 255.255.255.0 trust
Note: "trust" for a network is a *really* *really* *really* bad idea, since it does not demand a password from any user, and anyone can just claim to be "postgres" (the database superuser), and the server will just "trust" that they are indeed who they claim to be. You should *at least* use "password", or even better use "md5"...
all all 192.168.0.0 255.255.255.0 md5
Note about Subnet Masks: when comparing two given IP addresses to determine if an incoming connection is part of the specified subnet, so to speak, both addresses are bitwise ANDed with the subnet mask, and the result must match.
So if you really trust the entire world of hackers and virus-writers with complete and unrestricted access to your database server:
all all 0.0.0.0 0.0.0.0 trust
will probably work.
On Feb 7, 2005, at 11:58 PM, Hershel Fisch wrote:
On 2/7/05 2:45 PM, "Jan Schenkel" <[EMAIL PROTECTED]> wrote:
Thanks, it works with the addition of 255.255.255.255 . My question now if I
want to enable a range of ip's how do I do that instead of putting a whole
lot of lines , like writing
All all 0.0.0.0 255.255.255.255 trust
or leaving it blank
All all 255.255.255.255 trust
would work?
Hershel
--- Hershel Fisch <[EMAIL PROTECTED]> wrote:Hi all I'm trying to connect to my postgres 8.0 server on a osx 10.3
This is a copy from the pg_hpa.con file
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only local all all trust # IPv4 local connections: host all all 127.0.0.1/32 trust
host all all 192.168.1.101 trust # this is the line I added .
# IPv6 local connections: host all all ::1/128 trust
The error " FATAL: missing or erroneous pg_hba.conf file." Thanks a mill. Ps I reinstalled postgres clean. Thanks , Hershel
Hi Hershel,
I think you forgot to add the subnet-mask at the end of that IP-address 192.168.1.101 -- I think that ought to be /24 but I'm not good with this sort of calculations. However, there are calculators on the internet.
Hope this helped,
Jan Schenkel.
===== Quartam - Tools for Revolution <http://www.quartam.com>
=====
"As we grow older, we grow both wiser and more foolish at the same time." (La
Rochefoucauld)
__________________________________ Do you Yahoo!? The all-new My Yahoo! - What will yours do? http://my.yahoo.com _______________________________________________ use-revolution mailing list [email protected] http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________ use-revolution mailing list [email protected] http://lists.runrev.com/mailman/listinfo/use-revolution
- ----------------------------------------------------------- Frank D. Engel, Jr. <[EMAIL PROTECTED]>
$ ln -s /usr/share/kjvbible /usr/manual
$ true | cat /usr/manual | grep "John 3:16"
John 3:16 For God so loved the world, that he gave his only begotten Son, that whosoever believeth in him should not perish, but have everlasting life.
$
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (Darwin)
iD8DBQFCCN9p7aqtWrR9cZoRAsGFAKCEMVI7wSpF7gHgYmZ16unoE5BYNQCfcLGx XQeR2reyjVYTmzc5ho7SAqI= =LivA -----END PGP SIGNATURE-----
___________________________________________________________ $0 Web Hosting with up to 120MB web space, 1000 MB Transfer 10 Personalized POP and Web E-mail Accounts, and much more. Signup at www.doteasy.com
_______________________________________________ use-revolution mailing list [email protected] http://lists.runrev.com/mailman/listinfo/use-revolution
