This is a duplicate of: https://stackoverflow.com/questions/55804806/how-does-postgres-host-based-authentication-work
(I was asked to shift this query to DBA.Stackexchange)
I am installing DSPACE which needs Postgresql.
Please see this link: DSPACE INSTALL
Then tighten up security a bit by editing pg_hba.conf and adding this line:
host dspace dspace 127.0.0.1 255.255.255.255 md5.
I have read on the internet as to how the above line works. It needs a connection type followed by database name/user name followed by IP address and the authentication scheme.
My query is: Should this not be a local (in place of host) connection since the dspace user is running locally?
Can someone show me step by step as to what happens when a request comes in? Where are the instructions that the dspace user will submit a request using md5?