Security Configuration
A good configuration for
/etc/postgresql/pg_hba.conf
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:
createdb -U dspace -E UNICODE dspace -h localhost
The
-h localhost
bit specifies that the PostgreSQL createdb command should connect to the local machine over tcp/ip.