Page History

...

• PostgreSQL can be downloaded from http://www.postgresql.org/.  It is also provided via many operating system package managers
  • If the version of Postgres provided by your package manager is outdated, you may wish to use one of the official PostgreSQL provided repositories:
    • Linux users can select their OS of choice for detailed instructions on using the official PostgreSQL apt or yum repository: http://www.postgresql.org/download/linux/
    • Windows users will need to use the windows installer: http://www.postgresql.org/download/windows/
    • Mac OSX users can choose their preferred installation method: http://www.postgresql.org/download/macosx/
• Install the pgcrypto extension.  It will also need to be enabled on your DSpace Database (see Installation instructions below for more info).
  
  • On most Linux operating systems (Ubuntu, Debian, RedHat), this extension is provided in the "postgresql-contrib" package in your package manager. So, ensure you've installed "postgresql-contrib".
  • On Windows, this extension should be provided automatically by the installer (check your "[PostgreSQL]/share/extension" folder for files starting with "pgcrypto")
• Unicode (specifically UTF-8) support must be enabled (but this is enabled by default).
• Once installed, you need to enable TCP/IP connections (DSpace uses JDBC):
  
  • In postgresql.conf: uncomment the line starting: listen_addresses = 'localhost'.  This is the default, in recent PostgreSQL releases, but you should at least check it.
  • Then tighten up security a bit by editing pg_hba.conf and adding this line:

    
    

    Code Block
    host dspace dspace 127.0.0.1 255.255.255.255 md5

    .

    
    

    This should appear before any lines matching all databases, because the first matching rule governs.
  • Then restart PostgreSQL.

...