A good configuration for
and DSpace might be:
This allows users to access their own databases on the local machine using sockets (ie. not tcp/ip). However, for the DSpace installation we want to connect over the network, and while we'll authenticate as the DSpace user, we won't be the DSpace user.
So, to create the DSpace database, you might have to use the following:
-h localhost bit specifies that the PostgreSQL createdb command should connect to the local machine over tcp/ip.