Easy pg_hba.conf question.

[Robert]

I want to add a line in a pg_hba.conf file so that the user 'auser' can
connect to the database 'aDB' via host based authentication: so far for
the line I have:

host aDB 134.117.76.10 255.255.255.255 md5


However, I'm not sure how to specify only 'auser' can connect to the
database.

Thanks for your help,
Robert Young


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Bruno Wolff III]

On Sat, Jan 24, 2004 at 12:23:44 -0500,

Post by Robert
I want to add a line in a pg_hba.conf file so that the user 'auser' can
connect to the database 'aDB' via host based authentication: so far for
host aDB 134.117.76.10 255.255.255.255 md5
However, I'm not sure how to specify only 'auser' can connect to the
database.

What version of postgres are you using? I think the hba format changed
between 7.1 and 7.2 (though it might have been between 7.2 and 7.3)
to include a specifation for allowed users.

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ***@postgresql.org so that your
message can get through to the mailing list cleanly

[Robert]

Post by Bruno Wolff III
On Sat, Jan 24, 2004 at 12:23:44 -0500,

Post by Robert
I want to add a line in a pg_hba.conf file so that the user 'auser' can
connect to the database 'aDB' via host based authentication: so far for
host aDB 134.117.76.10 255.255.255.255 md5
However, I'm not sure how to specify only 'auser' can connect to the
database.

What version of postgres are you using? I think the hba format changed
between 7.1 and 7.2 (though it might have been between 7.2 and 7.3)
to include a specifation for allowed users.

I'm using 7.2, the one shipped with Debian Stable/3.0.


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Bruno Wolff III]

On Sat, Jan 24, 2004 at 14:18:09 -0500,

Post by Robert

Post by Bruno Wolff III
What version of postgres are you using? I think the hba format changed
between 7.1 and 7.2 (though it might have been between 7.2 and 7.3)
to include a specifation for allowed users.

I'm using 7.2, the one shipped with Debian Stable/3.0.

Then the change must have been between 7.2 and 7.3
In the older versions you couldn't restrict which users could connect
to which databases.

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ***@postgresql.org)