Versions Compared

Old Version 3

changes.mady.by.user Tim Donohue

Saved on

compared with

New Version Current

changes.mady.by.user Tim Donohue

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

Security Configuration

A good configuration for

Code Block
/etc/postgresql/pg_hba.conf

and DSpace might be:

Code Block
# TYPE  DATAASE    USE        IP-ADDESS        IP-MASK           METHOD
local   all         postgres                                        ident sameuser
local   all         all                                             ident sameuser
host    all         all         127.0.0.1         255.255.255.255   password
host    all         all         ::1               ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff        password
host    all         all         ::ffff:127.0.0.1/128                password
host    all         all         0.0.0.0           0.0.0.0           reject

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:

Code Block
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.